Lynn Pettis (12/1/2009)

---

jdurandt (12/1/2009)

---

Oh the humanity....

@Lynne - I agree 100% : Set based processing is the answer in 99% of cases. What I was saying though is that, in...

Add the parameter, and then add that to the Where clause for the query. "Where name = @TableName", assuming "@TableName" is the name of the parameter.

jdurandt (12/1/2009)

---

Oh the humanity.... I had a good chuckle at the idea of Cursor Boy and his arch nemesis Loop Man

I have a full head of hair, but it is...

What are you getting with regards to IO stats? Specifically, does the new server end up with more physical reads than the old server, and less logical reads, on...

What it does is declare a cursor that select the table and column and size, from the system tables. It builds a command to alter the column into either...

john scott miller (12/1/2009)

---

you would hate me then. one of the first things i do is redesign all proc away from cursors. Perhaps i am you arch nemesis and u...

Instead of doing it with a parameter for the table name, if you really need to do a whole database all at once, try this:

declare Cmd cursor local fast_forward for

select...

Please don't double-post. You already posted this question in another forum on this same site.

Not sure what you mean by "what the issue is here".

You might be able to get data out of them with xp_readerrorlogs. It's an undocumented extended stored procedure that's included with SQL Server. Search for it online, you'll...

I recommend changing the trigger to fire on Update or Delete, and to use the deleted table (instead of inserted). That will save performance on inserts. It gives...

It will probably take a while to verify. That's a fair chunk of data.

On the other hand, the last thing you want is to go to restore the database,...

I'm assuming you're talking about a "one-true-lookup-table" solution. Your sample doesn't include any values, just column names, but the usual thing in this case is that you'd have one...

Just to add yet another drive-by-appreciation: Thanks for the site, Steve. May not be 100% your creation, may not be "your passion", may not be a lot of things,...

You'll love this site. ...