What I can think off:

try to dissect @ts_now to (hours), minutes, seconds and milliseconds

Then dateadd one by one

plase read this:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Welsh Corgi (1/20/2012)

---

I tried restoring the MSDB to another machine with the following code"

RESTORE DATABASE MSDB

FROM DISK = 'msdb_backup_201201181321.bak'

WITH REPLACE,

MOVE 'MSDB' TO 'D:\SQLServer\Data\MSDB.mdf',

MOVE 'MSDB_log' TO 'D:\SQLServer\Log\MSDB.ldf'

I get the following error:

Msg...

OK. Assuming you don't need to resolve 6/4 is the same as 3/2, this sort of, works:

feel free to add decimal places to get better precision if you have 1001/1000...

maybe (just maybe):

create table #numbers ( a tinyint)

go

insert into #numbers (a)

(

select 1 union all

select 2 union all

select 3 union all

select 4 union all

select 5 union all

select 6 union all

select 7...

googling your message:

https://www-304.ibm.com/support/docview.wss?uid=swg21433369

Mark Harr (10/14/2011)

---

Just curious as to why residents of Tennessee, Wyoming, Northern Ireland and Quebec are not eligible?

https://www.dbainspace.com/about/dbainspace

ELIGIBILITY CRITERIA

...Only residents of the USA*, UK*, Canada*, Australia, or Germany can...

I think you...

My friend uses some open source tool that locks the workstation if your bluetooth enabled cell phone moves out of (bluetooth) range!

I found some software that does the same thing...

what about this:

update table1

set table1.column1 = #table.column1, table1.column2 = #table.column2

from table1, #table

where table1.pk=#table.pk

dglane (3/3/2008)

---

I have been using the online backup service offered by Mozy (www.mozy.com). There have been some minor glitches but overall I have been satisfied. There are other...