Viewing 15 posts - 886 through 900 (of 1,219 total)
Shaira (8/12/2013)
Then I plan on turning off the identity in the archive table and using what is originally assigned in the production table.
Note that you cannot turn off IDENTITY with...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 13, 2013 at 3:47 pm
Edward Mlynar (8/12/2013)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 13, 2013 at 3:44 pm
ChrisM@Work (8/12/2013)
"Text, Ntext, and Image data types are invalid for local variables." is misleading:
In such case you should file a Connect bug on message 2739. Although I don't really understand...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 12, 2013 at 3:56 pm
ChrisM@Work (8/12/2013)
Gosh, where did you read that?
Maybe in an error message?
DECLARE @a text
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 12, 2013 at 2:35 am
jerome.morris (8/11/2013)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 12, 2013 at 1:12 am
Since log and data files are the same size, one get the suspicioun that maybe someone set the size to the same for both files by mistage. Before you go...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 10, 2013 at 4:07 pm
The sample data you posted is not fixed length, but I will have to assume that there were accidents when you pasted into the web form.
Your format file should look...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 10, 2013 at 3:53 pm
akshay9986 (8/9/2013)
The 500 tasks are will be allocated to most top parents...i m thinking that this 500 tasks can be stored in emp table itself...
That depends on the relation between...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 10, 2013 at 2:58 am
I you want to learn about SQL Server Audit, I suggest that you read about it in Books Online.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 10, 2013 at 2:47 am
jerome.morris (2013-08-09)
My Next question is using that file is it possible to specify the format of a date time to "M/d/yyyyHH:mm:ss"
You cannot specify any format for datetime values, but the...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 9, 2013 at 4:13 pm
Because it is a conscious design of SQL Server to make the product as confusing as possible. And particularly when it comes to error handling, Sybase and Microsoft have save...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 9, 2013 at 4:06 pm
No, Profiler is not the only tool. To start with, Profiler is only a GUI to SQL Trace and any real tracing should be conducted server-side, particularly in production system....
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 9, 2013 at 3:47 pm
ramyours2003 (2013-08-09)
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.where can we check to resolve this issue ?
First find out...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 9, 2013 at 3:42 pm
It seems that you have not enabled AWE. Which means that you are only able to use 2GB or memory.
First check your BOOT.INI, and verify that you have the /PAE...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 9, 2013 at 3:35 pm
The user needs the permission ALTER ANY LINKED SERVER.
I strongly recommend that you don't give the user this permission, but that you create the server for him.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 9, 2013 at 3:27 pm
Viewing 15 posts - 886 through 900 (of 1,219 total)