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 ?

I guess EM is still collecting informationschema-data. this may take a while. (we have setup a couple of dts-trials with db2 OS/390, there also it takes a while befor it...

maybe http://www.sqldts.com contains a solution for you ?

check out sqldmo ?

adding to phillcart 's reply :

and implement as backupsolution Full (weekly?) / diff ? (perf.impact) / and log (hourly) backups. according to a sla.

I'm having the same problem, but I'm using a workaround.

Open the VPN, use mstsc (remote desktop connection) to logon to a (sql)server and then open sqlEM and work from there...

start SQL Server in minimal mode from the command line (-f)

use Query Analyser :

use master

go

exec sp_helpsort

go

didn't run it over here 

euhm ... just slipped into my attention ...

... keep in mind your model-mdf/ldf have to be with the same charset as the old one or you can have some nasty things coming...

-- how to determin SQLServer Uptime

--  Tracking Uptime by Brian Moran http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html

--

SELECT @@servername as ServerName, datediff(mi, login_time, getdate()) as SQLServer_UpTime_Minutes

FROM master..sysprocesses WHERE spid = 1

go

-- my own...

did you take a look at DTS to export to file ?

- take a look at SQLDMO

- maybe this can help you out ...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=107508

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1

"C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade\scptxfr.exe" /s yourserver /d yourdb /I /F filepath