Thanks, and well, they could be trending down across the last four hours. Maybe I need to check my pay stub 😉

I'd think about just using simple scripts. Write yourself, or use something like SQL Compare to generate the scripts.

You can then either build a system that looks for existing objects...

Hugo Kornelis (4/1/2013)

---

I was disappointed when the text of the editorial frankly admitted it being an April Fools prank. There goes the chance to read the comments of those who...

Export/import, not sure what you mean?

The only way you do this in SQL is with data, not objects. If you "export" an object, you script it.

What I'd look for is...

Glad you like it.

I was curious how many might actually read the whole thing and not skip over my disclaimer sentence.

Best of luck, Lynn, and be safe.

Simple way: Use the import wizard in SSMS to load the data into a temp table.

Then use a query to match up the data. If you temp table is...

Powershell will do this, and give you better error handling. However more development work.

The other thing to think about is using a product like SQLCompare to build your scripts. I...

This says .NET 3.5 (http://msdn.microsoft.com/en-us/library/ms143506%28v=sql.105%29.aspx)

However when you run setup, it will run a pre-check and let you know if you are missing anything. I've never had to enable anything in...

A desktop icon is a shortcut. Easy-peezy for me to add one back.

It's not a one click, and I certainly think not having a "create a shortcut" option from the...

TravisDBA (3/29/2013)

---

Another thing to remember here is that script injection is NOT just restricted to SQL. MSDOS commands can be injected in a string that is passed to an...

Jim,

You can dislike it, but that doesn't mean you're right or wrong. That was my point. There are hundreds of millions of office users. Lots of them like the changes,...

I don't love government intervention, but I do think it's needed in cases. Not here, but I do believe this is bad for baseball: http://espn.go.com/mlb/story/_/id/9109596/alex-rodriguez-make-more-houston-astros-combined-salary

The long, guaranteed contracts without limits,...

jfogel (3/29/2013)

---

I agree that if you are vigilant with security then xp_cmdshell is just fine and I've used it for years. However, over the last year or so I've started...

Jim P. (3/28/2013)

---

I have turned it off in everything MS, and 99.9% of...