Viewing 15 posts - 31 through 45 (of 68 total)
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...
March 23, 2016 at 2:35 pm
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...
February 22, 2016 at 4:03 pm
I had this problem in SQL 2008 R2 (local & remote). Just removing the USE statement fixed it for me.
November 2, 2015 at 1:17 pm
That's why we have QA departments - what we mean and what we code don't always turn out to be the same thing.
October 2, 2015 at 11:13 pm
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....
September 29, 2015 at 9:49 am
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...
June 28, 2015 at 2:31 pm
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...
June 18, 2015 at 12:15 pm
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...
October 31, 2014 at 12:08 am
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...
October 31, 2014 at 12:06 am
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...
September 12, 2014 at 9:38 pm
Lawrence Moore (9/12/2014)
So can someone explain how a synonym is superior to a view?
A SYNONYM can be to any object, including stored procedures and functions. I don't think you...
September 12, 2014 at 9:26 pm
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...
September 11, 2014 at 11:11 pm
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...
March 20, 2014 at 12:37 pm
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...
March 19, 2014 at 11:12 pm
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....
February 10, 2014 at 9:20 pm
Viewing 15 posts - 31 through 45 (of 68 total)