just my 2ct :

- having NULLs for replacement - values ?

- or using case-expressions without an ELSE pitfall ?

like andrewkane17 specified, shrinkfile or shrinkdatabase will solve your problem.

You can also perform an alter database set AUTO_SHRINK on, but that is not...

did you also perform sp_updatestats, dbcc updateusage and dbcc freeproccache (so newly generate plans come in).

Maybe it's time to use profiler to capture load and analyze it to check if...

imo the only difference for the "dbo-login" is that (s)he does not have to qualify schema DBO when creating objects. Members of the db-owner db-group always have to specify the...

This is how I'd solve it : (be aware of collation conflicts !)

print 'Fillocations of DB'

print '------------------'

declare @SelStmt as varchar(7000)

declare @DbNaam as varchar(125)

declare...

yep, basic rule No 1 for programming is still : "learn copy/paste"

That should be no problem because the new domain will use the old sid from the users sid-history.

The only "issue" you'll have is...

... parameter-table and proc set to manage sequences ...

This way you could emulate identity

This is just a simple representation :

create table t_mySequenceParameters (

TableName...

you could add the old domain's user-SID to the new domain-user's sid-history.

As you can imagine, this is a windows-ad-operation, and not a sqlserver operation....

you may want to check out IDENTITY and scope_identity if you can live with gaps in your numberings.

we always set it to the max available blocksize and let sql handle it internaly.

Can't DTS help ?

(check out Enterprise manager, database, tables, rightclick and choose import data. The wizard will guide you )

In addition to sa24's advice, you can also use this delete-batch.It will take a while, but since transaction are kept small, interferance should...

CREATE TRIGGER Itr_T_Current
            ON T_Current
FOR INSERT
AS 

insert into T_History
select * from inserted

GO

maybe these resources can help :

- http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp

- http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;319942

- http://www.sql-server-performance.com/sql_server_performance_audit5.asp

- http://www.sql-server-performance.com/jc_sql_server_quantative_analysis7.asp

- http://www.sql-server-performance.com/awe_memory.asp