You should use TRY CATCH, but error messages are stored in sys.messages so you can get the description from there. You also need the language to limit the results....

You might want to look into a 3rd party backup tool like SQLBackup from RedGate, LightSpeed from Quest. There are others.

If I knew what the original question was I might be able to help. If you are replying to someone's reply to an earlier post, you need to make...

Here's a script from Brent Ozar's BLITZ! 60 Minute SQL Server Takeovers presentation.

USE master

GO

SELECT *

FROM master.INFORMATION_SCHEMA.ROUTINES

WHERE OBJECTPROPERTY(OBJECT_ID(ROUTINE_NAME),'ExecIsStartup') = 1

It doesn't appear you can audit at the column level.

From BOL (http://msdn.microsoft.com/en-us/library/cc280663.aspx):

Can you look at and post the VB code?

If they were using parameters in ADO to call the proc there wouldn't be an issue.

Why are you using @@...

Now we are getting somewhere.

Have...

You can query msdb.dbo.sysjobs to get the job id if you know the job name.

SELECT S.job_id FROM msdb.dbo.sysjobs AS S WHERE S.name = 'name'

I suggest changing this:

SET @count = (SELECT count(*) FROM @temptable)

to

SET @count = @@ROWCOUNT

That way you aren't reading the table variable for no reason.

What are you using to connect?

Are you connecting from the server or from a remote PC?

What is the error message you are getting?

The online option just reduces blocking locks it does not reduce all resources needed to rebuild an index so there will be a performance hit, but tables with indexes being...

To the best of my knowledge someone has to put a database into single user mode and the user must have ALTER database permissions.

Of course since you are using sa...

Sure you should be able to see all the temp tables regardless of connection. The first query I provided will do that. Perhaps you need to be sysadmin...

Without seeing the dynamic_pivot procedure I can't give you the solution you probably want. I'm going to agree with Eddie.

If the ID column is int you don't need to...

Why do you need to find the table in another connection?

Temp tables are tied to a connection/session, so you can use the same name in each connection without...