Thats how I ran it at one of my previous places... The invisible tasking from the...

Can you please elaborate as to why Profiler is not appropriate?

Which version and edition of SQL? 2005 (since its in the 2005 section)? 🙂

Try this:

DECLARE @sql VARCHAR(MAX)

SELECT

@sql = CASE

WHEN x = 1 THEN 'update...'

WHEN x = 2 THEN 'update...'

END

FROM myTable

EXEC (@SQL)

interesting article...

And in true SSC fashion the answer is:

"it depends"

😛

Personally, I have yet to see SQL Server work properly in a virtual environment. It starts off well, but always ends up with too many shared resources and "SQL Server...

then the response is the same as that thread... no need for a second thread

I think you'd be...

whats the percentage of records returned by both selects (without the top) with regards to the total number of records in the table?

Good question, and I eagerly await the answer... got asked the same thing yesterday.

GilaMonster (1/12/2010)

---

Johannesburg, South Africa. For anyone who's geography a little weak, that's at the southern end of the African continent.

Yes, we have electricity and internet (most of the time), we...

I used to get this on my CITRIX client all the time... restart fixed, other than that try pressing the CTRL, ALT and windows shortcut key a couple of times...

The error sounds like a Kerbeos authentication issue, with regards to delegation and the setting up of correct SPNs.

Can you change the linked server to make the connection as...

you may need to tone the caffeine intake, who knows what else you will find :hehe:

ok, 2 options:

run profiler to capture everything thats happening as well as errors

or

specify an output file on SQLCMD using the -o flag Oh and the file location for the output...