MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.
> Gary Fairchild
> >I HAD A PROBLEM WITH A HARD DISK ON A SERVER (BAD BLOCK).
> >THE FIRST THING I DID WAS BACKUP A DATABASE. THEN I CHANGED THE
> >HARD DISK, INSTALLED SQLSERVER AND WHEN I GO TO RESTORE
> >IT GIVES A SORT ORDER ID ERROR, SAYING THAT THE ORIGNINAL
> >SERVER HAD A SORT ORDER ID OF 52 ON THAT THIS ONE HAS ONE OF
> >82 AND IT DOESN'T LET ME RESTORE THE DATABASE.
> >PLEASE HELP, I AM VERY DESPERATE.
> >I AM USING SQLSERVER 6.5
Our DBA just recently left under negative circumstances, and I have
been tasked with securing our production servers.
We have a SQL Server 7 instance running on NT4.
I know that we are:
--Replicating data to another machine.
--Make a daily snapshot of the database and backing up the log files
--Have jobs running that monitor failures to properly call External
Stored Procedures, and attampt to recall them.
There are several users with DBA priviledges on the machine...SA, and
The question is, if I needed to change the password for these users (I
have permission levels), will the jobs and other processess
automatically accept the new password?
Are there any other caveats, I should be aware of?
I appreciate any feedback :)