One of the scenario where you can achieve automatic failover is Clustering. You can set up clustering between two servers but there would be only one copy of data. If your...

I don't think you can change the templates in the formatting tab of Generate SQL Script. Alternately, you can use SQL-DMO to generate a script.

From above, it is taking @tab as the object name. Don't put @tab in quotes.

Below are some links.

http://www.xpcrypt.com/

http://www.activecrypt.com/

Is the registration on the primary server under local or servername ? Make sure it is the servername and not local.

You can do a remote installation of the client tools.

SQL doesn't provide any encryption facility. You will have to rely on third party product for that. There is a function called pwd_encrypt() but this only provides one side encryption....

http://support.microsoft.com/default.aspx?scid=kb;EN-US;316898

http://support.microsoft.com/default.aspx?scid=276553

Are you going to have two installations on the server at the same time i.e. Windows 2000 on C drive and 2000 Advanced server on D drive ? If yes...

Below is the syntax for sp_addmessage. Specify us_english for the parameter @lang and add the message. After this you should be able to add the british version of the same message.

sp_addmessage [ @msgnum...

When the developer creates the table, he/she would be the owner of the table. The owner of the table has full control over the table. If you want to restrict...

Below is from a Microsoft Professional.

Hi,

Generally we do not support executing remote stored procedures if linked

server is non-SQL Server. I assume that you are using DB2. You may check...

Try replacing all the hardware parts and hope that helps.

We had issues where the server would reboot because of a bad raid controller card but the Dell diagnostics ran fine.

Below is from BOL.

sp_addlogin [ @loginame = ] 'login'

    [ , [ @passwd = ] 'password' ]

    [ , [ @defdb = ] 'database' ]

    [ , [ @deflanguage =...

Excellent Article.

Also something which turned out to be very handy for us during the power outage last year was radios. With cell phones running out of signals/battery in the data center,...