Viewing 15 posts - 181 through 195 (of 361 total)
Nice summary - perhaps I could suggest a follow on article for Embarrassing Hazards Involved in Staged Migration to 2005?
Eg)
Logshipping not working from 2000 to 2005 or vv.
Reporting Services...
May 15, 2007 at 5:21 am
ok, what you need to do if you want each one to be a file in its own right is to a) read books online where it talks about BACKUP...
May 14, 2007 at 4:41 am
For what its work my SQLCMD -L is picking up all sorts of things - a lot of which I think are Office Vista installs which seem to use 2k5...
May 4, 2007 at 5:28 am
I really have to take exception to that statement.
May 4, 2007 at 5:24 am
mind you, you could probably query the active directory to get that.
May 2, 2007 at 8:41 am
'That's right - when I know my servers.'
If your servers are broadcasting their details - someone can tell us the technical term I hope! you can call "sqlcmd.exe -L" ...
April 30, 2007 at 3:43 am
Processes do not really block themselves as such. In Sp4 they made a change so things look like they do ...
April 27, 2007 at 10:06 am
usually when I get this kind of error its because I misspelled something...
April 27, 2007 at 4:07 am
Inventory of the DBs can be acheived using sp_helpdb. Use sqlcmd.exe to connect to a list using trusted connections. Also look at sp_MSForeachdb. Pipe it out to a textfile. This...
April 27, 2007 at 4:06 am
Do you need to write to these tables?
April 26, 2007 at 6:14 am
well, looking at the reference provided in the error:
http://msdn2.microsoft.com/en-us/library/ms151782.aspx
looks like it might help?
April 25, 2007 at 4:58 am
I have recently installed 2000 as a named instance on a box with 2005 as default. Seems to be ok.
April 25, 2007 at 3:57 am
Viewing 15 posts - 181 through 195 (of 361 total)