 | |
Incorrect syntax near 'ANSI_PADDING'.
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Incorrect syntax near 'ANSI_PADDING'. -
07-01-2008
, 05:58 AM
|
....DotNet4Ever.... (hate.spam (AT) nowhere (DOT) com) writes: I can't believe nobody has seen this error happening... I don't know. It must something funny in the atmosphere were you live... In any case, I looked at your post, and I could not a get grip of what you were doing, and finally I gave it up, as I did not really have a good answer. In any case, since SET ANSI_PADDING ON is in a command batch on its own, and ANSI_PADDING is on by default anyway in SQLCMD, why not just ignore it, or delete the line? -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#22
| |||
| |||
|
|
....DotNet4Ever.... (hate.spam (AT) nowhere (DOT) com) writes: I can't believe nobody has seen this error happening... I don't know. It must something funny in the atmosphere were you live... In any case, I looked at your post, and I could not a get grip of what you were doing, and finally I gave it up, as I did not really have a good answer. In any case, since SET ANSI_PADDING ON is in a command batch on its own, and ANSI_PADDING is on by default anyway in SQLCMD, why not just ignore it, or delete the line? -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#23
| |||
| |||
|
|
....DotNet4Ever.... (hate.spam (AT) nowhere (DOT) com) writes: I can't believe nobody has seen this error happening... I don't know. It must something funny in the atmosphere were you live... In any case, I looked at your post, and I could not a get grip of what you were doing, and finally I gave it up, as I did not really have a good answer. In any case, since SET ANSI_PADDING ON is in a command batch on its own, and ANSI_PADDING is on by default anyway in SQLCMD, why not just ignore it, or delete the line? -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#24
| |||
| |||
|
|
....DotNet4Ever.... (hate.spam (AT) nowhere (DOT) com) writes: I can't believe nobody has seen this error happening... I don't know. It must something funny in the atmosphere were you live... In any case, I looked at your post, and I could not a get grip of what you were doing, and finally I gave it up, as I did not really have a good answer. In any case, since SET ANSI_PADDING ON is in a command batch on its own, and ANSI_PADDING is on by default anyway in SQLCMD, why not just ignore it, or delete the line? -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#25
| |||
| |||
|
|
....DotNet4Ever.... (hate.spam (AT) nowhere (DOT) com) writes: I can't believe nobody has seen this error happening... I don't know. It must something funny in the atmosphere were you live... In any case, I looked at your post, and I could not a get grip of what you were doing, and finally I gave it up, as I did not really have a good answer. In any case, since SET ANSI_PADDING ON is in a command batch on its own, and ANSI_PADDING is on by default anyway in SQLCMD, why not just ignore it, or delete the line? -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#26
| |||
| |||
|
|
....DotNet4Ever.... (hate.spam (AT) nowhere (DOT) com) writes: I can't believe nobody has seen this error happening... I don't know. It must something funny in the atmosphere were you live... In any case, I looked at your post, and I could not a get grip of what you were doing, and finally I gave it up, as I did not really have a good answer. In any case, since SET ANSI_PADDING ON is in a command batch on its own, and ANSI_PADDING is on by default anyway in SQLCMD, why not just ignore it, or delete the line? -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#27
| |||
| |||
|
|
....DotNet4Ever.... (hate.spam (AT) nowhere (DOT) com) writes: I can't believe nobody has seen this error happening... I don't know. It must something funny in the atmosphere were you live... In any case, I looked at your post, and I could not a get grip of what you were doing, and finally I gave it up, as I did not really have a good answer. In any case, since SET ANSI_PADDING ON is in a command batch on its own, and ANSI_PADDING is on by default anyway in SQLCMD, why not just ignore it, or delete the line? -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#28
| |||
| |||
|
|
....DotNet4Ever.... (hate.spam (AT) nowhere (DOT) com) writes: I can't believe nobody has seen this error happening... I don't know. It must something funny in the atmosphere were you live... In any case, I looked at your post, and I could not a get grip of what you were doing, and finally I gave it up, as I did not really have a good answer. In any case, since SET ANSI_PADDING ON is in a command batch on its own, and ANSI_PADDING is on by default anyway in SQLCMD, why not just ignore it, or delete the line? -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.