Nice catch Jack. I just hadn't been aware of that. It's good to know because it's the kind of thing that can lead to a lot of confusion. Just to...

No, you can't pass the table name as a variable. You're close though. Instead of this:

UPDATE @TableName

SET @ColumnName = NEWID()

Create a variable of type nvarchar(max) and try this:

SET @sql =...

Nice job Scott. I'm looking forward to seeing the code coming out of this effort.

I'm just unsure at this point. I tried with a larger query, 178 lines, not insane or stupid, but surely not trivial. The first time I ran it, I got...

We're using DB Pro for all our new development and quite a few of our older systems. This is in SQL Server 2005 and 2000. We use the tool to...

The only way I know to do something like this is with a table that contains key values. You can then use IDENTITY. But, short some pretty intense triggers or...

I'm sure it has been mentioned before, but be sure you're qualifying the procedure name and using proper case on the schema, proc, and all parameters.

That said. I'm running tests...

The added value of having the perfmon files is that you can then link them up with Profiler files for some serious troubleshooting & tuning fun.

I just got an email, we're getting our kit next week. I'll look for the sample code then. That is unless someone else posts it for you.

Is this a plant? Are you looking to start a fight?

Well, I'll answer anyway.

My .00001 cents on this issue is, yes, use stored procedures as a standard method of development....

I wasn't, but our local user group (SNESSUG) is hosting one of those in a couple of weeks. If no one else hooks you up, I'll get the script from...

Adam Bean (3/20/2008)

---

Grant Fritchey (3/20/2008)

---

Sorry, left out a bit of detail.

Instead of looking at the System Monitor, go to the Performance Logs and Alerts and set up a new Counter...

Terry (3/20/2008)

---

Hello

I have a PRODUCTS table which contains 2 fields: old product code and new product code.

I also have a clients table, where the old code is stored.

I would...

Sorry, left out a bit of detail.

Instead of looking at the System Monitor, go to the Performance Logs and Alerts and set up a new Counter Logs using the "New...

I would not recommend it, but you can log directly into a SQL Server database.

Instead, I've logged out the CSV's and imported them directly to a table inside the database...