Viewing 15 posts - 631 through 645 (of 1,219 total)
There are two possible reasons for this error:
1) The network connection is bad and corrupts the data sent over it.
2) The application uses a client API which has an incorrect...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 7, 2013 at 3:46 am
Not simple to investigate from the SQL Server side of things. Doing "sp_helptext sp_columns_ex", I find this:
from
...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 6, 2013 at 4:17 pm
I don't fully understand your description, but it seems that you check Tools->Options->SQL Server Object Explorer->Scripting and that the option "Generate script for dependent objects" is set to False.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 6, 2013 at 4:07 pm
Personally, I would not care about the trace flag at all and I don't understand why Microsoft bothered implementing it. The point with IDENTITY is that is a meaningless number...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 6, 2013 at 3:46 pm
I'm not sure that I understand your question; it seems that you are leaving out some details. Are you tracing for auditing purposes?
Since tables on a linked server are outside...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 6, 2013 at 3:43 pm
TheSQLGuru (9/6/2013)
For features that are "difficult" and/or don't get much attention it could be never. MERGE anyone?!? 🙂
I see MERGE in use every now and then.
INTERSECT admittedly has some...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 6, 2013 at 3:40 pm
PHXHoward (9/6/2013)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 6, 2013 at 12:28 pm
lisa.ogle (9/6/2013)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 6, 2013 at 12:25 pm
Yes, a support case can be expensive. But you have to weigh this against the alternatives. How much does it cost you to not being able to apply the CU?...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 6, 2013 at 12:14 pm
I would double-check that you don't have CU5 for SQL 2012 RTM, and after having verified that you actually have the files for http://support.microsoft.com/kb/2861107, I would open a case with...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 6, 2013 at 1:41 am
Paul White (9/5/2013)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 6, 2013 at 1:05 am
lisa.ogle (9/5/2013)
I still cannot get it to work I used this I put the ; after my select statement before your with statement and still get an error.
We don't see...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 5, 2013 at 4:17 pm
The error nessage Could not find the Database Engine startup handle. usually means that Setup could not connect to the Database Engine, which it expects to be running at this...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 5, 2013 at 4:12 pm
What does "SELECT @@version" report for this instance?
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 5, 2013 at 4:07 pm
Sanz (9/5/2013)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 5, 2013 at 4:01 pm
Viewing 15 posts - 631 through 645 (of 1,219 total)