I think such events are captured in the default trace, so you can query that.  If you want to store this information on an ongoing basis, you might prefer to...

Logins are in sys.server_principals; users are in sys.database_principals in each database.  You can join the two to find out which database users are orphaned and/or which logins don't have explicit...

Run the command exactly as Lowell posted.  You missed the hyphen out.

John

No, the table is dropped when the connection that created it finishes.  So if the code in question will be executed multiple times from the same connection then yes, you...

SELECT STUFF(STUFF(RIGHT('0' + '92332',6),5,0,':'),3,0,':')

John

This is a question that only you can answer, I think.  From here, it looks as if you enjoy the work, you enjoy the company and you're well paid, so...

Check the ExecutionLog table in Reporting Services to see how much of the time the report took to execute was query time and how much was rendering time.  Also check...

Yes, I noticed that as well.  It disturbs me a little, too.  I suppose only Ola knows the reason for it.  I have been known to go through the jobs...

I typed "function v stored procedure" into my favourite search engine and got a whole load of results.  You could do the same.

I'm not sure what your expert...

You're going to need a sysadmin to something for you, whether that's enabling ad hoc distributed queries, or setting up a linked server object.  There are other options, as long...

There's a hostname column in sysprocesses - have you looked at that?  You shouldn't be using sysprocesses at all, though - it's only provided for backwards compatibility with SQL Server...

Nicole

With no DDL or sample data, it's difficult to visualise.  But if you type "concatenate for xml" into your favourite search engine, you should get plenty of results...

The somewhat obtuse answer is nobody inserted it, because your primary key constraint did what it's there for and blocked it.  If you really need information like this, I would...

How is the audit file structured?  Is it CSV, XML, or something else?

John