I'm not positive but I believe you can use the @@NESTLEVEL function as well.

The first thing I'd do is re-evaluate my recursive triggers. There should be a way...

Changing the collation started the problem because the msdb you restored was created using the original collation.

As far as why you are still having problems I have no idea....

If you have Profiler installed on your local machine then you can run Profiler against any server on which you have ALTER TRACE permissions (2005/2008) or are a member of...

Something like this:

Declare @query varchar(1000)

Set @query ='

Select

J.name as job_name,

JH.step_name,

Case

When JH.run_status = 1 Then ''Succeeded''

When JH.run_status = 2 Then ''Retry''

When JH.run_status = 3 Then ''Canceled''

When JH.run_status = 4 Then ''Running''

Else ''Failed''

End...

Select

EmpNo,

PhoneNumber,

Count(RowNo) as total_calls

From

dbo.Test

Group By

...

Oops, I think this is a little better:

[font="Courier New"]SELECT

   DB_NAME() AS database_name,

   MP.name AS database_user,

   RP.name AS database_role,

   SP.name AS server_login,

   SPR.name AS server_role

FROM

   sys.database_principals MP LEFT JOIN

   sys.database_role_members R...

Brandie,

I think this code is close to what you need:

[font="Courier New"]SELECT

   DB_NAME() AS database_name,

   MP.name AS database_user,

   RP.name AS database_role,

   SP.name AS server_login,

   SPR.name AS server_role

FROM

   sys.database_principals RP JOIN

   sys.database_role_members...

Thanks, but you only get there by being prolific not necessarily correct. In this case I happen to be right, but if you answer enough questions you have to...

Shrinking the database is not a recommended practice. If you shrink it then you will likely go right back and grow it again if autogrow is not on and...

You can check out http://www.jumpstarttv.com as there is a series of short vidoes on how to use Profiler. Just a disclaimer, I did the videos. They are based...

What events are you collecting using Profiler? Linq queries come across on the SQL:BatchStarting and SQL:BatchCompleted events.

Why not handle this in the original transaction? If the user changes the 2 columns then send the 3rd column to the database as a null value.

What if the...

Glad I could be of help. Sorry about the errors, the second one you mention was a brain cramp on my part. The first one probably has...

I don't know as far as the question you are asking. I will comment that you probably don't need to rebuild all the indexes every week. If you...

You cannot use a variable for the database name in a use statement. You would need to use dynamic SQL to accomplish this.