Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Incorect Sintax Expand / Collapse
Author
Message
Posted Sunday, May 31, 2009 12:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 5, 2009 11:55 PM
Points: 1, Visits: 3
Hello,

Can someone help me with this problem: when creating BackupRetention] table a get the following error:
Server: Msg 170, Level 15, State 1, Line 20
Line 20: Incorrect syntax near '('.

I guess it's the problem at this line ([Name] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] some quotes are not right. Please help.
Post #726359
Posted Sunday, May 31, 2009 1:14 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:09 PM
Points: 40,172, Visits: 36,560
The line you posted looks fine. Please post the entire script.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #726361
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse