How did you change the settings? In SSMS and the current settings are not shown?

If you check sys.database_files, what do you see in there? zeros?

AFAIK, no other benefits. both use the log, write transactions in two steps. The only benefit is to handle recovery with something other than a full backup.

If you run SQL 2000 and SQL 2008 as separate instances, it's like they are on separate computers. There is no integration between instances.

you can upgrade your SQL 2000 databases...

Be careful of the functions in your queries as they might cause performance issues.

If you only want certain tables, replication is the only choice. Other options will move all data/tables.

Be sure that you are not moving information that might be a security issue....

By creating the user, you give them access to the database. However that does not give them access to any objects (tables/views/stored procedures).

For that you need to give rights to...

Then I would script something. You can use the Windows Scheduled task to run a VBScript as

cscript.exe myscript.vbs

as the command. You can set up loops to run through all...

That does sound like an issue with the blocks or files. I would definitely have the SAN guys double check and be sure that all firmware/drivers are up to...

That seems like a lot of VLFs, but I'd like to know what Gail and others think.

Are you planning on letting that run to finish? (the restore)

Yes, Bru is correct.

If you are installing the core engine, database services, these are completely separate. Separate folder for files, dbs, separate registry and services. You can apply SPs to...

There might be a better way, but I'd actually use a HAVING clause and a union.

select count(1) as Total, Category

from manager

group by Category

...

good luck. Not sure what to do here. I lean towards calling MS since everything else might cause more issues. That at least provides some CYA to you if things...

nope, downtime required, but you could script this and do it relatively quickly during off hours.

I'd script it from the command line using osql, detach the db, then copy the...

Can you start the instance in single user mode?

Also, any chance you can script out logins and rebuild master, then add them back? It sounds almost like a master database...

It sounds like something is messed up. The MSDE isn't a default as well by any chance, is it?

I know SP4 was quick, but not that quick. Does SP4 ask...