Matt Miller (7/6/2009)

That's reason enough for me to add a post...

Well, in reality, you probably don't want to give SA access within a stored procedure, but you can use EXECUTE AS to change security context

Nope, no FINALLY in SQL Server at this time. http://technet.microsoft.com/en-us/library/ms175976.aspx

Can you post the settings you have for the linked server? How have you setup login mapping?

Can anyone with some Service Broker knowledge help out on this one

A SID is a GUID that AD uses to uniquely identify an account (they are also used in SQL Server for SQL Accounts). When you assign an account to...

I'd agree with Jeff on this one. If I were to be working on certification I'd go with 2008.

The Optimizer uses statistics to determine if a seek or a scan is the likely "best" access method for a given query. It actually takes a very small percentage...

Did you uses Surface Area Configuration to re-assign the account to the SQLServerAgent Service? It sounds like you have mismatched SID's which is why you are getting unknown. ...

I have to ask, what kind of application do you have where the users are running DDL statements? This is not a typical situation, at least not in my...

There are 2 ways to return a single value from a stored procedure, as a resultset and as an output parameter and the recommended method would to use an output...

Is the Ray-PC\Ray account an administrator on the PC?

Have you identified what type of component is causing the error? This would help others help you determine the issue.

Have you double-checked that the email address is correct? Have you looked in the inbox for the SQL Server account to see if you got a system undeliverable message...

Just be aware that the solution you have selected will not scale well as it can at best do a index scan because of the function being used on the...