I'm embarassed to admit that I wasn't running a nightly sp_delete_backuphistory

job. Dumping the old histories solved the problem I was having.

The next question is this: what parameter do...

Another finding: under "EM > Management> Jobs> (right-click on the job of interest)>View Job History" seems to draw from a table other than sysdbmainplan_history.

Anyone know where?

TIA,

Bill

quote:

---

Exactly... CHECKDB should be able to fix minor errors....

---

Ya know ... I didn't try CHECKDB!...

When I ran "sp_droprolemember" in sql2k,

sp_droprolemember 'public', '\Alic'

I got the error : "Msg 15081. Membership of the public role cannot be changed."

Bill

quote:

---

I...

ngolovin,

I will certainly check into your remark regarding SP3! Thanks for the heads up.

Bill

Andy, Brian,

Thanks for your help. While I don't think it's a sql server error per se I think it is more likely a software problem than a hardware one. (I...

Yes, I rebooted the server and reinstalled Sql Sp3 and got the same error message.

The box I'm installing Sql SP3 on is a new box with a clean install of...

Brian,

Initially I am looking for a failover solution in one location. The "some distance" solution comes later!

Bill

Thanks for the help!

According to a note I saw on Technet you can also find the MDAC version installed using regedit:

HKLM\Software\Microsoft\DataAccess\FullInstallVer

"FullInstallVer" appears in the right pane

Question: I heard that MDAC...

Thanks for the help!

According to a note I saw on Technet you can also find the MDAC version installed using regedit:

HKLM\Software\Microsoft\DataAccess\FullInstallVer

"FullInstallVer" appears in the right pane

Question: I heard that MDAC...

Here's what it turned out to be in my case:

for various reasons I had to remove the computer from our NT domain. BUT the dbo for the databases was set...

Got this reply....

Bill - this is how the current tools work, the only workaround at the

moment is to roll your own UI and conceal the other databases 🙁

Microsoft SQL Server...

Found more info:

Upgrading in-place from sql 7 to sql 2k may fail (it did for me) with "error running script messages.sql(1). See link

http://support.microsoft.com/default.aspx?scid=kb;DE;q300676

Here's another link that comes clean on moving...

Andy,

Please clarify what you mean. While I can detach the msdb database from the sql7 server I can't attach it to the new sql2k server (for that matter, I don't...

Maybe the topic of this thread is what we are experiencing.

We have a SQL7 database that has a total data size of 2.2GB of which 1.0GB is used.

The transaction log,...