Or use the buil in function

OBJECT_NAME(<id> )

just combine with Mike's comment.

No because profiler adds a bit of overhead to you system and bandwidth utilization. You ca get software such as MS MOM which can monitor and notify you of some...

This should help a bit bu version differences may require so adjusting.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=108832

Take a look here and see if comes out the same.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=307988

The EM diagrammer is no designed to show those relationships. You need to use a tool live Visio or other than can work with multiple databases at a time.

If the transaction didn't commit it will be rolled back.

If the query hasn't changed (and doesn't have variabled inputs) then I would probably defrag the indexes (or rebuild), run sp_updatestats and DBCC UPDATEUSAGE.

If it has changed due to variable input...

Look at sysdepends in BOL and you shoul b able to come up with something.

See if this helps you http://support.microsoft.com/default.aspx/kb/176256

Many people lok at the Execution Plan to see what the procedure is doing and measure the time.

Try this, came from http://www.webservertalk.com/archive132-2005-9-1196296.html

Under properties of SQL Server Agent there's a setting under the job system tab:

"Non-sysadmin job step proxy account" - I checked this off and users...

I was joking because the statements of compatibility flying around. And yes Steve I stuck my hand up many a time in the betas and said, "What the h*!!". I...

Yes that is pretty large but you know it can be a lot larger. I would give it maybe a month and see how big it is, if larger than...

I usually do this

BACKUP LOG tempdb WITH TRUNCATE_ONLY

DBCC SHRINKFILE (templog,[value])

GO

which usually works.

Have you tried to open the report manager to see if there are any messages? Or does it just come back blank?