February 18, 2010 at 12:14 pm
Hello,
I created a custom template on and select existing connection, rpc:starting, rpc:completed, sp:completed, sql:batchcompleted, sql:batchstarting. I then filter on the database id. I started a new trace and selected the template name. Then I ran a SQL script containing a variety of SQL statements and nothing showed in my trace. Nothing.
My account has sysadmin role. What did I miss?
Joe
February 18, 2010 at 12:42 pm
I assume that you specified the correct Database ID and that there is not a leading or trailing space embedded in the Database ID Filter?
What happens if you remove the filter? I had a problem like before...
If that does not work you may want to try adding some additional events or create a new Trace and start removing events and adding filters, etc.
Just a thought.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 18, 2010 at 2:11 pm
Yes, it is very odd. What I was doing was to start a new trace, then select the custom template I made, and check the events within the template, and then run. I think that you cannot do that. I saw a couple of times that the database id was fine but then SQL was putting things in the NOT Like part of the filter, something like that.
So, I stopped everything tracing. Started a new trace, selected my template, did not look at it, ran the trace. Then I went into a New Query and ran my script of SQL statements and they showed up fine.
The concern I have is that I tried this several times before it finally worked. Why did it not work? Oh, and the other thing I did was to raise the permissions for my account on the database I want to trace to dbowner. I added the dbcreator, processadmin, serveradmin to go along with the sysadmin role I already had. Hmmm, and then it worked.
February 18, 2010 at 3:15 pm
If you are a member of the SysAdmin Role you do not need to grant any Database Roles.
If you are a member of the DBOwner FIxed Database Role then you inherit all of the Database Fixed roles with the exception of db_denyreader & db_denywriter.
I hope this helps.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 18, 2010 at 3:17 pm
--------------------------------------------------------------------------------------------
I saw a couple of times that the database id was fine but then SQL was putting things in the NOT Like part of the filter, something like that.
---------------------------------------------------------------------------------------------
I suspect that it may have been the Database ID Filter... 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply