Thanks Satya . I have sent a mail to sqlwish@microsoft.com .
Dear Shekar , I went through the link which you provided. Its doesnot deal with multiple logs problem.Thanks for your reply. Hello...
Please see if the column to save the textdata has enough length to store the sql statements
Hello All, I am trying to get the log space used by all the databases in sql server 2000/2005. I used "DBCC...
Hello All, I am trying to monitor login failures in SQL Server 2000 and YUKON. I could successfull implement a trace to monitor login...
Hello all, I need to get all the strings in between ''(sdf,adf,satish,rajesh,satish)from a table containing the below mentioned strings. I...
hey brentj, It is possible to mirror 2 instances in the same machine. we need to see that the endpoints being created have different...
Dear Chappy ,<br /> I used select statement (select @TraceIdOut[TraceId]) to return the value. I could get the value using...
Hi,<br /> I am in a process of creating a trace event class using ADO . These are the statements to create a trace event.<br /><br />...
Thanks Chappy . running set event number of times will allow us to trace more than 1 column. But in my case no column contains information regarding...
Environment<img src='/community/emoticons/emotion-7.gif' alt=':S' />QL Server 2005 Enterprise in Win2k3 Enterprise on 32(x86) bit machine<br /><br...
HelloAll, I am trying to create a trace for user error messages using audit user error messages event class.I could create .trc file. But...
Hello All I have a small query . Can we use any stored procedures / queries which can do the task of Index tuning wizard. What I mean is ; Is...
I would like to monitor all the performance counter intormation related to database mirroring.there are sys tables which has information related to...
Hey luis , thanks for your help. This forum has some information which needs us to use index tuning wizard. Like we have trace...
Hello All, I have a requirement to import .trc(trace file) into a table . Can any one please help me out regarding this....
Basically I am a developer and not a DBA . So, I cannot set the security of the Server. I shall put the question in a different way.I would like...
Hi, I would like to know the table/log which is populated by the SQL SERVER when failed attemps to login a SQL SERVER using SQL INJECTION IS...
Hi Luis, I haved surfed the net to get as much as info regarding the unused indexes. your information seems to be great. I am SQL SERVER...
hi...please go through the following link http://www.sql-server-performance.com/optimizing_indexes.asp the writer has asked us to use profiler and...
Separate names with a comma.
