Viewing 15 posts - 511 through 525 (of 644 total)
Try this:
BULK
INSERT UDEF_WEB_ORDER_TEMP_0001
FROM 'D:\WebFiles\Web_File_Order_In\RORD0001.txt'
WITH
(
FIELDTERMINATOR = '\t',
ROWTERMINATOR = ''
)
SELECT @Error = @@ERROR
IF @Error = 0 /* No error found*/
BEGIN
-----------YourCodeToBeExecutedHere-----------
END
ELSE
BEGIN
RAISERROR ('Some error occurred',16,1)
END
Note:
1. Waitfor delay has been removed because @@Error catches...
December 13, 2011 at 2:31 am
Lavanyasri (12/13/2011)
If any one help me on locking mechanism of SQl server .
1.How to find the type of locking on a particular table or database ?
2. What...
December 13, 2011 at 1:55 am
ramji543210 (12/12/2011)
I am new to SQL Server DBA responsibilities.
I would like to restrict users to ALTER , CREATE or DROP Stored Procedures but I wanna let them to EXECUTE...
December 12, 2011 at 11:08 pm
abhishek_dwivedi03 (12/12/2011)
when to use update statistics sql server ???
You can schedule it with your index maintenace task. As other SSC guys said above there is no "exact" answer to this,...
December 12, 2011 at 10:23 pm
Glad to hear this 🙂
December 12, 2011 at 9:53 pm
Dev (12/12/2011)
December 12, 2011 at 6:40 am
kautuk (12/12/2011)
December 12, 2011 at 5:56 am
Nope. per BOL:
For failover cluster configurations, use the domain user account and the start up type is set to manual..
I missed the "cluster" word completly & thought he (OP)...
December 12, 2011 at 5:41 am
forsqlserver (12/12/2011)
In a cluster sqlserver service and sql server agent service should be automatic or manual.
They should be automatic, so that should any server restart occur due to any reason,...
December 12, 2011 at 5:08 am
2Tall (12/12/2011)
December 12, 2011 at 4:02 am
kautuk (12/12/2011)
But what about replications? The users should have privileges to create replications so they will be effectively creating procs.
Replication is something precisely done by DBAs only. So what is...
December 12, 2011 at 3:53 am
vaithi.saran846 (12/11/2011)
how can i increase the response time in this. If i increase it or make it as infinite i think it will work.regards,
Vaithilingam.K
Yes it will work. However,...
December 11, 2011 at 11:34 pm
if timeout error is not available then the time difference in the log file is 5 min. if the timeout error occurs then the time difference in log file is...
December 11, 2011 at 10:47 pm
what value have you set for dbcommand.timeout in the .Net code ?
December 11, 2011 at 10:35 pm
Ninja's_RGR'us (12/9/2011)
Taking stabs in the dark here.Isolation level changed?
I suffered this issue few months back. The application developers uploaded a new build & they explicitly set the isolation level to...
December 9, 2011 at 5:16 am
Viewing 15 posts - 511 through 525 (of 644 total)