Nothing has happened as far as I can tell. Also if I create a new user and grant them the same roles, that new user is not able to connect...

Steve,

I have been using SQLServerCental.com for many years and recently rejoined when I moved to a new job. From the outset your site has impressed me with its content and quality...

To access SQL Server, you need to use the registry key for SQL Server 2000 and SQL Server 7.0 that determines the authentication mode of SQL Server.

• In SQL Server 7.0,...

You need to make sure that the accounts the sql server is starting under on both machines has domain admin then try and use the wizard.

What I do in a similar situation is I use schedualed jobs incorporating WINRAR (freeware)

"c:\program files\winrar\winrar.exe" a -m3 -o+ -rr8 z:\mssql\backup\History\sls_bwproduction_db_%1_prior.rar

then

xcopy "z:\mssql\backup\history\*prior.rar" "I:\QArchive\Quantum\Prod\"

all steps in a...

Silly question......

I know bit of the topic, but one of them at least has its place, for holding monitoring scripts for say Spotlight on SQL Server ....

Have a read here, I fount it very usefull when setting up sql mail.

http://support.microsoft.com/default.aspx?scid=kb;en-us;263556:

My 2c worth on this is, it all depends on cost and needs. I have a 30Gb database that needs to be backed up. We also need to keep at least...