Sounds like incorrect linked server setup. The 4 part naming in server.database.schema.object and I'm guessing it is looking for a linked server that either is not setup or is...

This is just a guess, but the 2 main standards for column names is to do camel case like LastName or underscores between words like last_name and the designers of...

Here is 1 way:

DECLARE @time TABLE (theDate SMALLDATETIME, theTime VARCHAR(20));

INSERT INTO @time (

theDate,

theTime

) VALUES (

'2009-08-03 00:00:00.000',

'12:00:00' )

SELECT

theDate,

theTime,

CONVERT(SMALLDATETIME,(CONVERT(VARCHAR(20), theDate, 101) + ' ' + theTime)) theDateTime

FROM

@time

I have successfully inserted into a temporary table from a linked server. What is the code you are using?

A couple of suggestions,

1. In the example you are using you are not specifying a format in the second convert, so you are not getting the same string returned....

Did you set up the trace in Profiler and then export the definition or are you trying to create the trace by hand?

Anyone want to take a look at this one? It's about statistics aging and query performance. I gave an answer, but I'm not sure that I'm on the...

Will do. Will update this thread with whatever happens.

It sounds like you have done it the right way.

Yes, you could create a windows group either on the SQL Server Server or on the domain and use the windows...

Can't open the image. Can you re-attach maybe as a jpeg?

Duplicate post. Please post answers here

Nope not this time, of course, I had it in SIMPLE Recovery. I will be changing the recovery model back and re-starting this trace again this afternoon for another...

I think you are more likely seeing an issue with cached execution plans not being the best plan for the query than an issue with statistics. What is a...

I'm not sure that there is a simple or elegant way to do this. Is there a fixed number of rows returned by the report. Like top 50...

Just a quick follow up. Ran a server-side trace for 24 hours filtering on database name. And not one event found. I might have missed some events...