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....

The two more significant bits and the least significant bit were how I got it.

😉

That is a nice trick that dateadd(yy, datediff(yy, 0, @ThisDate) + 1, 0) returns the first moment of next year. However, it does have the downside that if @ThisDate...

Using sp_executesql with parameters does NOT do a replace like this:

@cmd = REPLACE(@cmd, N'@name', @name);

It generates inline code like this:

set @name = 'Some Name''; GRANT CONTROL TO [Malicious User];--'

SELECT *...