I see Windows 2003  is in the mix.

Here's my experience:

I used the Database Copy Wizard to upgrade a Win NT, Sql 7 box to Win 2003, Sql 2000 and the upgrade...

Julie,

I saw that DTS option but when I set it to 1000, I noted the DTS error log started reporting errors on lines 3456, 3457, 3458, 3459.....4456. which was not the...

Thanks to everyone for their replies. Also, I had not heard of "Integra". I'll check it out.

Bill

Steve,

"I'd script out the permissions from the old db" ....

How would you do this?

Bill

Thanks Steve!

"ms" make a lot more sense to me than percent -- but I didn't know what the proper units of that column were.

Bill

Thanks to evetyone for their help.

For reasons I don't understan I beleive that the culprit was the "reorg" job we run nightly at 12am. I stopped that job and our...

You advice is good!

Despite the ominous error message I received when I re-ran our Integrity job those databases came out smelling like a rose!

Thanks.

There is a reg hack you can try (usual MS caveats about editing the registry apply)

To change the Licensing mode for SQL Server

2000 back to "per processor" by editing the...

Mimorr,

When I run

select c1, count(*)

from table

group by c1

having count(*) > 1

I get essentially what I want BUT only column 1 (c1) is returned in the resultset.

I want all fields...

Thanks, Brian.

Next question is that even though our user apps cannot access more than 2GB (because we use Win 2K\Sql 2K Standard edition) can the OS\SQL systems use this extra...

Thanks to everyone for their help.

Those bas****s have stripped the BUILTIN\Admins group form their database. Backup? They say Stop the Sql service and copy the mdf\ldf files. What a piece...

Frank,

I'm still investigating but I think you may have hit the nail on the head!

Bill

We had the identical problem at our place and it was highly intermittent. In our case it turned out that the sql server (backend to a web server) had two...

dgermundson,

Unfortunately, no one is giving out logins! The "sa" password is apparently hardcoded in the app and users are not expected to be added!

Bill

John,

Thanks for your helpful reply.

Bill Salkin