you get only problems if you don't install them!

Hi Daya,

What kind of user account are you using to register the SQL server?

As it is a MSDE version of SQL maybe you need to have admin rights to register...

If you want to shrink them you can use dbcc shrinkdatabase or shrinkfile from QA.

It is a bit strange that you can not see the system databases in EM. What...

What are you using Enterprise manager or Query analyser?

regards,

Holger

Hi Chris,

What compatibility mode do you have on that database? Make sure to set it on mode 80.

regards,

Holger

It can also be that a restart of the SQL Server service solve the problem.

But it is always a good idea to try it on a test machine first. I've...

not if you stop the sql server service. Then just copy them over. But as I said before make a copy of the original ones before doing that.

After that you...

The fastest way is stop SQL server service and copy out the system db's and then stop the service on the new server and copy the files over the existing...

there is still the brutal force way of doing it:

sp_configure 'allow updates',1

go

reconfigure with override

go

use (your database)

delete from sysfilegroups where groupname ='(your filegroup)

go

sp_configure 'allow updates',0

go

reconfigure with override

go

but before doing that make...

Best thing is to create a specific user account and set the right permissions.

regards,

Holger

Hi Joel,

First think you need to check if you have still some open transactions and close them.

If the situation gets really critical consider to restart the SQL Server service, that...

Hi,

Has the startup account of SQL Server the right to write on the other server?

If you do this from Dos prompt you're using your user account and not the one...

Hi,

Are both server in the same domain?

Holger

Hi,

Sometimes I had the problem that indexdefrag and so one didn't had the disered result.

As the problem is only with a few tables why you don't consider to make...