Not tested, but something like this should work.

John

UPDATE t

SET t.lst_upd_ts = c.lst_upd_ts

FROM Tbl_Dates_Convert c JOIN Table_Dates2 t

ON t.TS = c.TS

Rob

I agree that it does seem a daft way of doing, but you don't need to have everybody having sysadmin access.  Just delete the BUILTIN\ADMINISTRATORS user (or whatever it's called...

Kathleen

OK, so you can either copy the model database files to the default location before you start SQL Server, or you can start SQL Server with the -T3608 flag and...

SQL Server implicitly converts the string into a datetime value.

If you are trying to plug in the values in the way you show in your "Test it out" section, then...

Would this work, then?

INSERT INTO #temp_Metrics_asp( Start_Time,End_Time)

SELECT CAST (mt.New_idle_Time AS datetime), -- datatype is decimal

 CAST (mt.New_idle_duration AS datetime) -- datatype is decimal

FROM tbl_metrics_asp_test mt

John

What sort of information is in the idle_time and idle_duration columns?  Is it a number of seconds, or is it a decimal number that represents the number of days... or...

Francis

You don't say what you want to do with the data when you get it, so I have assumed you want to add the number of seconds in each half-hour...

Kathleen

Are you not able to start SQL Server from a command prompt, either?  Look up the sqlservr syntax and try using the -c, -m or -f parameters.  Using trace flag...

Jan

Is there an event immediately before the Missing Join Predicate event with the same SPID that might give you a clue?

John

Look up the topic "dtsrun Utility" in Books Online for details of how to encrypt the parameter string, and much more.

You can still schedule through SQL Server - make sure...

I know you can't detach a user database that's involved in replication, but I don't know whether that's true of the distribution database.  I have a feeling it is.  If...

Kathleen

Not that I've ever done this before, but I think you need to use the sp_addserver stored procedure to change the name of your server.  See if you can start...

Richard

COALESCE is more concise when you're testing for nulls:

SELECT COALESCE (test1, test2, test3, test4) AS sample1

John

Vidhya

Can you not use a stored procedure instead of a function?

John

Chris

MSDTC is configured differently on a cluster server, using the comclust utility.  You should be able to find plenty of information on this on the Microsoft website and elsewhere.

John