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...
August 13, 2013 at 3:47 pm
Edward Mlynar (8/12/2013)
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...
August 12, 2013 at 3:56 pm
August 12, 2013 at 2:35 am
jerome.morris (8/11/2013)
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...
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...
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...
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.
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...
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...
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....
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...
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...
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.
August 9, 2013 at 3:27 pm
Viewing 15 posts - 886 through 900 (of 1,219 total)