If you see the URL below:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/debug/base/system_error_codes.asp

It clearly mentions that this is a Lock_Violation error...Pls check what other processes have a lock on this file..try using some other file...

Yes, I agree with Phill there ....if the DTS is a scheduled job then its always better to maintain it...but again it depends on what you are trying to do...

Thx Ck.. What i meant here was...typically what are the steps involved in the execution of a query from a client over LAN. What are the various steps that go...

The truncate statement removes data by deallocating the data pages and logs the deallocation of data pages whereas the delete statement removes data one row at a time and logs...

As far as I know and what we have followed for some time is to decide the Tables and the Attributes in each table and their relations with other tables...

Prerequisite: The SQL Server Agent service must be running on the Windows login Account with access to the mail profile set up on the Machine.

A Mail Profile needs to be...

Yeah...I got the import into DTS part...thats a good one...

But Can i use the DTS in someway to download the excel from the certain location in the intranet...thru HTTP IP.....and...

select substring(name,1,charindex(' ',name)) as Name from t1

Try this it will give the first word in the column before the blankspace where name is the columnname and ' ' is the...

select substring(name,1,charindex(' ',name)) as Name from t1

Try this it will give the first word in the column before the blankspace where name is the columnname and ' ' is the...

select substring(name,1,charindex(' ',name)) as Name from t1

Try this it will give the first word in the column before the blankspace where name is the columnname and ' ' is the...

I agree with most of the guys but i can agree more with Arsenal....I really appreciate his comments...

I am a SQL DBA for 2.5 years now and I am thinking...

Go to Support Services from EM and check if the mail profile is configured as the SQL Server uses sqlmail rather than the SQLagentmail which you have been checking. Ensure...