Viewing 15 posts - 16 through 30 (of 58 total)
Thanks to you and Steve for going the extra distance to make this available. Good report!
December 5, 2007 at 7:27 am
I had to edit line 1036 and still get a incorrect syntax error near ''.
No time to try and fix it. Good try.
December 4, 2007 at 6:51 am
I don't think you can.
From 2000 BOL, "OPENQUERY does not accept variables for its arguments."
November 27, 2007 at 8:13 am
Openquery passes the query to the linked server and it runs on the linked server. With 4 part naming the query runs on the machine the query was started on...
November 27, 2007 at 8:01 am
Thanks for the reply. That's what BOL says but it worked at one time. Just luck I guess and I agree it's not a good procedure.
November 9, 2007 at 6:21 am
How do you call the CMD file? Do you use quotes or delimiters?
MoveSql2005SysDbs.CMD "MSSQLSERVER", "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\D1", "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\D2"
October 3, 2007 at 9:57 am
Here is something else about that system database. It has to be located in the same folder as the Master database.
We like to have the database and log files on...
September 28, 2007 at 10:48 am
you might want to look at this thread.
September 14, 2007 at 8:01 am
Thanks for the answer but that was not the question.
Here is what I needed to know, but how do you configure SQL Server for one processor or two and does...
September 10, 2007 at 8:16 am
August 17, 2007 at 6:40 am
Great article. This is a tedious chore and any help is appreciated.
Two minor items.
1. A commented sample in the code showing how to run the procedure. I noticed someone used...
July 22, 2007 at 9:00 am
This is a issue that has been submitted to Microsoft connect.
The documentation states the resource database and the master database must be in the same folder.
What it does not say...
July 22, 2007 at 8:50 am
Viewing 15 posts - 16 through 30 (of 58 total)