Always close and deallocate a cursor when your are done with it. In your code you have done before you...

Can provide answer to following:

1. what is the command you used?

2. where is the file located?

3. Is your SQL server local or remote?

One more logical error is there in the code...

The code should like...

DECLARE

@liDepLinksID ...

Following 2 lines will come after last END

CLOSE lMCursor

DEALLOCATE lMCursor

Also, you can try below query to check if any SQL object is there where you have a (unwanted) DELETE statement for your table.

SELECT o.name,c.text from sys.syscomments c

INNER JOIN...

How are you so sure that it's not SQL injection....? As you are using inline queries sql injection can be the reason if not enough validations are done at the...

Without a delete or truncate query records will not vanish any where...

Are there any triggers defined on that table? May be there is a trigger on some other table that...

Here is something that you can try....

1. Create a sql job of OS command type.

2. Write the below command:

Start cmd /c dtexec /f "[package name]"

This command will call a create...

It's a bit weird....There is no problem preformance problems with dtexec (as per my knowledge).

Can you execute your SP once again and see whether there are any blockings happening...

You are trying to create the job on a remote server not your local server.

When you fire the below command, it tries to connect to you local instance of SQL...

Alter table query stated by crazyman is your solution

DISTINCT is going to give the distinct values for the combination of following columns:

InPurchaseId,StCompanyName,StAccountName,StProcDTime,BoIsActive,StNotes

i.e the distinct value of the combination of columns in the SELECT clause

Hope you are looking...

PIVOT is supported by all editions.

Check out the below link that gives a mapping of varous features to various editions:

http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx

DELETE FROM [ReportServer].[dbo].[Subscriptions] -- to delete all the existing Subscriptions

Dude...I would suggest you to go through the BOL and then come up with your doubts