I'm running this but I'm getting

(0 row(s) affected)

Msg 102, Level 15, State 1, Line 11

Incorrect syntax near ')'.

I'm trying to track it down but it's a little complicated, and it's...

AAAH.....Sorry I was confused 😛

Updated it to use our Utilities db and modified name to match our naming standards....

It's so big going through it to make sure I understand...

It says it supports SQL 2005 or greater but we don't have a DBMonitor database. After searching it looks like this is a 3rd party tool from Devart?

Perhaps this...

Any one have any ideas on what I should do? I'd hate to have to rebuild my machine over this.

We have run traces, but I'm a self taught developer with virtually no admin training or experience, so I don't really know what I'm looking for. Do you have...

Can you disable connection pooling just for your instance of the ssms connections? It doesn't seem to be happening when anyone else is connecting to the box.

I've pored over...

Since the server is SQL Server 2008 and my version of SSMS is SSRS 2008 R2, the SQL Server 2005 fixes do not apply.

If you want to increase your profienciency I would also suggest using a clipboard manager. I've been using arsClip for more years than I can remember now and it...

ErrorNumberErrorMessage

1712Online index operations can only be performed in Enterprise edition of SQL Server.

:exclamation: 🙁

Celko

Some version of this mis-use of SQL gets invented again every few months. It is a slow, dangerous mess. Are you familar with the long parameters list idiom? SQL is...

Why bother with the temp table? Why not just imbed the select into your where clause?

SELECT

SO.SalesPersonID, C.FirstName + ' ' + C.LastName AS SalesPerson

, COUNT(*)...

We are in the midst of upgrading from SSRS 2005 to SSRS 2008 R2, so I took note when you mentioned shared datasets. It seems like this is just...

Nice example. One thing I would do to make this even cooler would be to add tags on the input parameters so you could just hit Ctrl-Shift-M to input...

Yes, I read a large part of it, until I got to the point of "this makes no sense to do this when I would've already accomplished the objective before...

This is a reinvention of the wheel. There are a number of products that can do file comparisons and would've taken a lot less time to aquire and use...