monitoring tables access

I have a sql server 2000 in windows 2003 domain.
A third part software connects to this sql and make query and it writes
record.
How can I keep track of the activity of this software on sql tables ?
Can I see which query the software make on the sql?
Many Thanks
> Can I see which query the software make on the sql?
SQL Profiler is your friend. Do please check it in Books OnLine.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message

monitoring tables access

I have a sql server 2000 in windows 2003 domain.
A third part software connects to this sql and make query and it writes
record.
How can I keep track of the activity of this software on sql tables ?
Can I see which query the software make on the sql?
Many Thanks> Can I see which query the software make on the sql?
SQL Profiler is your friend. Do please check it in Books OnLine.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message

monitoring tables access

I have a sql server 2000 in windows 2003 domain.
A third part software connects to this sql and make query and it writes
record.
How can I keep track of the activity of this software on sql tables ?
Can I see which query the software make on the sql?
Many Thanks> Can I see which query the software make on the sql?
SQL Profiler is your friend. Do please check it in Books OnLine.
--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message

Monitor SQL data/log file % used

Is there a way to monitor the % (or size) of the data file used in a SQL
2005 database? I can use the Performance Monitor to track the log file (Log
file(s) used size (kb)), but I don't see the same option for the data file.
Am I jut missing something?
ThanksQuery select size from sys.database_files in SQL 2005 or select size from
sysfiles in SQL 2000.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tim Kelley" <tkelley@.company.com> wrote in message
news:O5Tb7pe0GHA.1040@.TK2MSFTNGP06.phx.gbl...
> Is there a way to monitor the % (or size) of the data file used in a SQL
> 2005 database? I can use the Performance Monitor to track the log file
> (Log file(s) used size (kb)), but I don't see the same option for the data
> file. Am I jut missing something?
> Thanks
>

Monitor SQL data/log file % used

Is there a way to monitor the % (or size) of the data file used in a SQL
2005 database? I can use the Performance Monitor to track the log file (Log
file(s) used size (kb)), but I don't see the same option for the data file.
Am I jut missing something?
ThanksQuery select size from sys.database_files in SQL 2005 or select size from
sysfiles in SQL 2000.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tim Kelley" <tkelley@.company.com> wrote in message
news:O5Tb7pe0GHA.1040@.TK2MSFTNGP06.phx.gbl...
> Is there a way to monitor the % (or size) of the data file used in a SQL
> 2005 database? I can use the Performance Monitor to track the log file
> (Log file(s) used size (kb)), but I don't see the same option for the data
> file. Am I jut missing something?
> Thanks
>