The four part syntax is only supported for SQL Server linked server and not for other providers. You have to use the 2 part conventions for others. Regarding the EM...

With proper planning there will be no problems with replication. But if you estimate the database will grow for 20GB think twice before implementing snapshot replication. Once you upgrade to...

You can find the information using the query given below.

select serverproperty('LicenseType') as Type,serverproperty('NumLicenses') as NumberofLicencse

I hope the link that you are using is for installing sql server in clustered environment. When you have to rebuild the sql serve you will have to start the...

The first time that you use xp_cmdshell do you use your windows and succedd. If so bulk insert should go without any problem. If not the id that you use...

If you expect the new database wil be of large volume and will be used heavily than the existing database. plan to deploy that in a new server than doing...

It can be removed by specifying the properties in the transformation task. The you can specify the row/column delimiters and the behaviour.

We jsut deployed a report in RS 2000 and accessed the same in EXCEL 2007 and i did have no problem with it. it works prefectly as usual.

Restore the full database backup with norecovery mode. Then restore the first and second transaction log with the norecovery clause and atlast restore the last transactional backup file with recovery...

The best way if you don't have a domain is to place all the servers in the workgroup so that they can have network accesses. What you said is possible...

The ouput of DBCC commands will be availabel in the error log file too. You can read them also to find what the errors that the checkdb has reported for.

Chris,

Define all the steps, process and lead times and everything in the DR document. I wrote a DR document that had everything and was very much useful for the DBA...

That is the most safest way i mean. You can perform role changes with the help of stored procedures and revert back to primary again but even a slightest mistake...

ROW_NUMBER() function is available only with SQL 2005 and not with 2000.

With read uncommited isolation level there is a possibility to read dirty reads which can be avoided with read commited level. But the more the level you use the higher...