Please read my little article regarding the use of logon triggers for this purpose !

There may be some considerable down sides !!

Scope: The drastic caveat with Logon Triggers.

http://www.sqlservercentral.com/articles/Administration/64974/

Hey... you have compare 8 !

Just script your full db.

Edit the sqltext and alter all current filegroup to NEWfilegroup.

Save the file

Use compare8 to generate your migration script comparing the db...

how about using a staging table to prepare all your new data and only at the very last merge the data into your target table ?

maybe even start with this script that can help you with your inventory and scripts.

Just add that part to use the new location.

http://www.sqlservercentral.com/Forums/FindPost368929.aspx

DMV sys.dm_db_index_usage_stats contains the usage info you need.

BIG REMARK from BOL:

The counters are initialized to empty whenever the SQL Server (MSSQLSERVER) service is started. In addition, whenever a database...

If that occurs with our backup jobs, it's always an xcopy still trying to copy the file to a safe zone.

We examine why that copy is taking that...

I would first run :

dbcc updateusage ('yourdb') with count_rows

and re-inspect the figures after that.

Congratulations for the 10K barrier.

Thank you for your support, 10000...

euhm, no ... still on 32 bit xp :blush:

Does msdtc have a 64-bit version too, and is that the version you configured.

Did you configure both versions ?

as you know, the value null is not NULL !

declare @var varchar(128)

set @var = 'NULL'

if @var is null

begin

select @var, ' it is indeed null 1'

end

else

begin

select @var, ' it is...

It works on my laptops sql2000 (SP4) instance ..

begin tran

SELECT *

FROM [ws20098002\SQL2000PE].pubs.dbo.employee

commit tran

must be a config issue.

Can you doublecheck your dtc configuration and firewall...

is tcp\ip enabled for the instance ?

If you have ssms on that server, can you just start it.

Do not connect to the server yet!

so cancel the connect popup.

Then click "new query" and then connect using the...

- please provide sql2005 version info ( @@version )

- is this an upgraded db (from 7 or 2000) ?

(and did you perform post migration maintenance ?)

- can you run dbcc...

1) why are you using 4-part naming ?

You should just connect to the correct sql-instance and db and use two part naming.

2) did you enable and configure msdtc at the...