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

Keep in mind filegroup-files are balanced within a group, so your maxcapacity is the size of the smallest file * the number of files in the filegroup.

Is this what you're looking for ?

this query uses native sqlserver systemtables . 

SELECT  FG.groupid AS GroupID

, SUBSTRING(FG.groupname,1,30) AS FilegroupName

, SUBSTRING(O.name,1,30) AS ObjectName

,...

select dateadd(mm,yoursum,getdate()  - getdate()) as yourTime_1900_01_01

check out dateadd in BOL

this example may help out :