Viewing 15 posts - 4,201 through 4,215 (of 9,643 total)
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...
September 22, 2009 at 1:49 pm
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...
September 22, 2009 at 1:46 pm
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
September 22, 2009 at 1:20 pm
I have successfully inserted into a temporary table from a linked server. What is the code you are using?
September 22, 2009 at 1:14 pm
Did you set up the trace in Profiler and then export the definition or are you trying to create the trace by hand?
September 22, 2009 at 12:16 pm
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...
September 22, 2009 at 11:56 am
Will do. Will update this thread with whatever happens.
September 22, 2009 at 11:54 am
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...
September 22, 2009 at 11:53 am
Can't open the image. Can you re-attach maybe as a jpeg?
September 22, 2009 at 11:49 am
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...
September 22, 2009 at 11:41 am
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...
September 22, 2009 at 11:32 am
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...
September 22, 2009 at 11:20 am
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...
September 22, 2009 at 11:11 am
Viewing 15 posts - 4,201 through 4,215 (of 9,643 total)