[ virtualVoid @ 27.01.2010. 22:44 ] @
Hocu da sa nedokumentiranom procedurom sp_MSForEachTable drop-am sve tabele u testnoj bazi. Napisao sam tsql kod Code: EXEC sp_MSForEachTable 'DROP TABLE ? NOCHECK CONSTRAINT ALL' ali mi se javlja greska Citat: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'NOCHECK'. Gdje grijesim? Druge komande poput print (exec sp_MSforeachtable 'print ''?''' ) rade. Inace ovu komandu sam prepravio od originalne koja glasi ovako (ona samo brise podatke iz tabela) Citat: CREATE PROCEDURE sp_EmplyAllTable AS EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’ EXEC sp_MSForEachTable ‘DELETE FROM ?’ EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’ GO PS. baza je na sql server 2008 |