I get the following error when running the query against one of my servers:

Msg 102, Level 15, State 1, Line 14

Incorrect syntax near '-'.

(260 row(s) affected)

(260 row(s) affected)

... I have...

Brian,

I didn't see any specific versions of SQL Server mentioned. What version are your Production and DR servers running for SQL Server 2005? SQL Server 2005 Service Pack...

elliot.howes

What are you trying to accomplish? Perhaps there is a different way to get you to your goal. If you are looking to dump data into a CSV file...

Daire,

What exact error syntax is SQL Server giving you?

This may help:

SQL Server 2005 Books Online (September 2007)

Troubleshooting: Timeout expired

http://msdn2.microsoft.com/en-us/library/ms190181.aspx

SSH,

You are quite welcome. It seems that you are on the right track with having a "sandbox" to play and work in. Nothing like practice makes you look...

SSH,

You have done a lot by getting your MCTS, congratulations. Keeping to work on your MCITP is a very challenging goal.

Build a Lab Computer at home. If you...

daniel,

Welcome to Date and Time fun with SQL Server!

Dates (and Times) are a controversial topic in the both the way they are stored in a database as well as how...

kiruba,

Congratulations on passing your 40-731 Exam! You are now certified as an MCTS.

MCTS: SQL Server 2005 Certification Requirements

http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx

Be sure to order your Welcome Kit and Certificate! (You must...

sandhyarao49,

SQL Server 2005 Books Online (September 2007)

CREATE INDEX (Transact-SQL)

http://msdn2.microsoft.com/en-us/library/ms188783.aspx

Clustered Index

The bottom, or leaf, level of the clustered index contains the actual data rows of the table. A table or view...

Bill,

Thanks for taking the time to write this article. I have implemented a similar process in my environment. To collect the majority of my data, I use a...

Greg,

Hooray! (... or should that be Huzzah!) I have another tool for my SQL Server Tool Belt.

Thanks for sharing your solution, I will definitely be using this function...

hisham2778,

Do keep us posted on your progress. If you are successful in getting your connection to work with your DBISAM system, please post your notes and findings so that...

Adding a little more advice to the heap here ...

You need to let your management know that what they are asking you to develop is a constant, never-ending cycle...

Angela,

There are windows registry keys involved (and other behind the scenes installation components) for installing the SQL Server Native Client.

For loading the SQL Server Native Client on your workstations for...

avinash repe,

I agree with the recommendations from both steveb and GSquared. I am not sure how much control you have over being able to change the structure of your...