Right-click the file. Click Open With. Click on SSMS (If SSMS is not one of the Recommended Programs, click Other Programs and click SSMS). Make sure the...

That is pretty much what I concluded. With the transaction volume we have, I may leave it in for a while and then take it out to compare execution...

Unless you are updating tables, you could also do this as a user-defined funciton.

Never even thought of that for DB names. Will have to give it a try.

OK, I see what you mean by addressing the objects. Can't do synonyms on...

The deprecated join is only th *= (LEFT OUTER) join. For some goofy reason they left the RIGHT OUTER join shorthand alone (at least in initial releases of SQL...

First off, check with the vendor to see what database objects they typically drop during updates. Chances are good that they are mostly adding new columns, keys, constraints, views,...

Can you give more details about what you are trying to accomplish?

The RDL files are the base of the reports being deployed. The format for these don't change unless you upgrade the SQL Server.

Seems like you should be able to...

If the DB you are accessing is on the same server, I don't understand why you use a linked server.

I have an inner facing DB with data that is accessed...

Here is a link to Microsoft's SQL Server 2008 Compliance site. It includes whitepapers and other useful information.

http://www.microsoft.com/sqlserver/2008/en/us/compliance.aspx

A couple of things:

First, make sure the sa account is enabled on the Status page of the SA accounts Properties dialog box.

Second, move the EXECUTE AS sa into the body...

You can add an output parameter to the stored procedure that returns a code or string to the calling app.

Not sure what the difference was with EXCEPT but that worked perfectly!

Thanks!

This link is for R2, but I am pretty sure it is the same. http://msdn.microsoft.com/en-us/library/ms143506(SQL.105).aspx

Only the Express, Standard and Developer editions are officially supported on Win7. The Developer edition...

I did try trimming on all of the email columns. It made the query run much longer, but came up with the same results.