The TRUNCATE TABLE SQL construct or statement is not supported
in [Programming SQL]
|
Prev: How to restore a .bak from full-recovery mode without trans logs
Next: back up jobs, re-index question
From: Mike on 2 Mar 2008 20:35 The following command, when done in Query Editor, produces the message: TRUNCATE table mytablenamehere Mike "Andrew J. Kelly" wrote: > Can you be a little more specific on this? What exactly was the command and > was this done from the Query Editor? > > -- > Andrew J. Kelly SQL MVP > Solid Quality Mentors > > > "Mike" <Mike(a)discussions.microsoft.com> wrote in message > news:180A51CD-8B43-471D-BACE-94FC33FDFFFB(a)microsoft.com... > > Hi. Why in SQL Server Management Studio do I get the message "The TRUNCATE > > TABLE SQL construct or statement is not supported." when running a > > TRUNCATE > > command? > > > > Just curious because this message never appeared in SQL Server 2000. > > > > Thanks > >
From: Aaron Bertrand [SQL Server MVP] on 2 Mar 2008 22:44 > The following command, when done in Query Editor, produces the message: > > TRUNCATE table mytablenamehere Use a query window in SSMS (not any of the visual designers) for creating and running T-SQL commands... A
From: Andrew J. Kelly on 3 Mar 2008 08:47
I have never seen that message before. Are you sure you weren't in SQLCmd more? What version and edition of SQL Server are you connected to? I would try closing SSMS and reopening a new Query window and see if it persists. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Mike" <Mike(a)discussions.microsoft.com> wrote in message news:AEB7E214-0A4B-4F2A-98A8-BD737425EDEA(a)microsoft.com... > The following command, when done in Query Editor, produces the message: > > TRUNCATE table mytablenamehere > > Mike > > > "Andrew J. Kelly" wrote: > >> Can you be a little more specific on this? What exactly was the command >> and >> was this done from the Query Editor? >> >> -- >> Andrew J. Kelly SQL MVP >> Solid Quality Mentors >> >> >> "Mike" <Mike(a)discussions.microsoft.com> wrote in message >> news:180A51CD-8B43-471D-BACE-94FC33FDFFFB(a)microsoft.com... >> > Hi. Why in SQL Server Management Studio do I get the message "The >> > TRUNCATE >> > TABLE SQL construct or statement is not supported." when running a >> > TRUNCATE >> > command? >> > >> > Just curious because this message never appeared in SQL Server 2000. >> > >> > Thanks >> >> |