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

Souvik

It looks as if the backoffice database is taking about 6 minutes to start.  Perhaps there are a lot of transactions to roll forwards and back in that database.  Does...

Michelle

I'm sure Rudy will chip in with his performance tuning shortlist (if he doesn't then search for it on this site) but in the meantime, how often do you update...

Vladimir

Without knowing more about your application, it's impossible for me to offer any specific advice.  For example, I can't think of any reason why you would want users to be...

Darren

That's because you haven't addressed the original problem of needing dynamic SQL or a table-value function.  Although I suggested a way of doing the former, it doesn't scale up very...