Click here to Skip to main content
15,940,246 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello.

I have database, published at azure. And I'm trying to execute this script:
SQL
DELETE FROM [dbo].[Merchants]


So I get next message:
SQL
Msg 40510, Level 16, State 1, Procedure TR_TreeDelete_Merchants, Line 1
Statement 'SELECT INTO' is not supported in this version of SQL Server.


What is the problem?

Thanks a lot.
Posted
Comments
There is a problem inside Procedure TR_TreeDelete_Merchants. Please take a look at that.
Tejas Vaishnav 16-Nov-13 0:29am    
have you applied trigger on delete on merchants, and what is code you have write in your procedure TR_TreeDelete_Merchants. can you please more info for it, so we can check it out and determine where is the actual problem is.

1 solution

Have a look here: Deleting Large Amounts of Records From A Table Without Truncating on Windows Azure SQL Database[^]
I hope it will help you.

Not sure, but Truncate table[^] statement would works too.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900