Viewing 15 posts - 1 through 15 (of 227 total)
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)
... I have...
August 28, 2008 at 8:29 am
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...
July 28, 2008 at 1:37 pm
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...
July 7, 2008 at 9:46 am
What exact error syntax is SQL Server giving you?
This may help:
SQL Server 2005 Books Online (September 2007)
Troubleshooting: Timeout expired
April 29, 2008 at 6:26 am
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...
April 17, 2008 at 10:54 am
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...
April 17, 2008 at 8:55 am
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...
April 15, 2008 at 9:44 am
Congratulations on passing your 40-731 Exam! You are now certified as an MCTS.
MCTS: SQL Server 2005 Certification Requirements
Be sure to order your Welcome Kit and Certificate! ...
April 15, 2008 at 6:04 am
CREATE INDEX (Transact-SQL)
The bottom, or leaf, level of the clustered index contains the actual data rows of the table. A table...
April 14, 2008 at 7:54 am
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...
April 14, 2008 at 7:31 am
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...
April 10, 2008 at 6:46 am
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...
April 8, 2008 at 7:09 am
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...
April 4, 2008 at 2:57 pm
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...
April 4, 2008 at 2:31 pm
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...
April 4, 2008 at 9:42 am