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 :

I guess not. Maybe it only comes available if the log is rolledover

I've tested this small sample, and the restore to the new...

couldn't deduct that from the example

in that case , Helen 's response will work.

how about

--update A

--set reference =  B.ContId

--, principal = B.Principal

--, book = B.book

--, strategy = B.strategy

select *

from TableA A

, TableB B

where B.reference = substring(A.trad_type,1,6)

is the connection working ?

Welcome !

What's the problem's errormessage ?