try manually installing the backward compatibilty tools from the CD.

the query optimiser will add an entry if it finds...

disable any constraints,etc and rename the table. Create the new table with the column order and then pump the data across. But why, as pointed out already it doesnt matter...

wow, as big as that 😀

not advisable

use the generate scripts option to script of the indexes, constraints, triggers,etc

ah see it now.

is BUILDSERVER the correct instance name?

restart the instance and login through SSMS and open a new query window then run

select @@servername

it should be possible to dump the RESTORE FILELISTONLY to a temp table and then build a restore command from the data in that temp table

yeah, you'd expect a named instance to have a unique servicename

Ahmad Osama (12/21/2008)

---

I am using these batch commands to restore master database......

Net Stop MSSQLSERVER

cdset path=C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn

sqlservr -m

sqlcmd -Usa -Psql2005 -Q "restore database master from disk='D:\SystemDatabaseBackups\MasterDatabaseBackup' with replace

Net...

yes, use

NET STOP servicename

or just issue a

restore database [mydatabase] with recovery

GilaMonster (12/19/2008)

---

Sure, but the chances of the OS coming under sudden , extreme memory pressure on a dedicated SQL server machine are slim,...

assuming it is released quick enough

this link explains the pros and cons

http://support.microsoft.com/kb/918483

no, in the DNS snap in right click and add server. You should then see both DNS servers, expand and look at the zone setups