I needed to create temp tables that match a remote system's data, and the remote system has an ever increasing number of programatically named views that I need to get...

Hi,

I found the KB 956032 article, too. We just rebuilt our SQL Server instance from (SQL 2008 R2 on Win 2008 R2) to (SQL 2014 SP1 on Win 2012...

I had this problem in SQL 2008 R2 (local & remote). Just removing the USE statement fixed it for me.

That's why we have QA departments - what we mean and what we code don't always turn out to be the same thing.

The question had trick wording. The answer does not keep a single instance on the host. It drops the single instance and replaces it with a difference instance....

We just implemented a new scenario for SYNONYM use (at our location). We use the Ektron content management system. Ektron has a product, eSync, that copies Ektron content...

Hi,

I know I'm a little late to the table here (no pun intended), but I came across this thread because I was getting the same error message. I figured...

An important aspect of the "unknown" nature of NULL in SQL Server has been overlooked in the article and this forum. SQL Server looks at the column or variable...

An important aspect of the "unknown" nature of NULL in SQL Server has been overlooked in the article and this forum. SQL Server looks at the column or variable...

Books Online 2012:

The base object need not exist at synonym create time. SQL Server checks for the existence of the base object at run time.

Synonyms can be created for...

A SYNONYM can be to any object, including stored procedures and functions. I don't think you...

Wow. I just created my first SYNONYM just a couple weeks ago. What timing. We have a case where we replicate stuff from a couple databases from...

Regarding cursors: One of my DBAs had starting writing WHILE loops to avoid cursors. I was enhancing some of her code like this, and I started to optimize...

One of the challenges with assigning permissions to stored procedures is the fact that SQL Server has no inherent way of knowing whether a stored procedure is effectively read-only or...

I agree about moving forward with the newer temporal data types, but the old datetime has some nice features, like zero as an int will implicitly cast to 1900-01-01 00:00:00....