AAKR (5/1/2013)

---

Hi All,

I am going to a move a server to production. The present production is 2005 enterprise, now i am going to move this production to 2008 r2 slandered.

Here...

ft55 (4/29/2013)

---

Hi,

Thanks for the response I was looking for a solution that could be used just at the transaction level rather than at the a database level. I'm slightly...

Status

I reported the...

See...

You can DENY ALTER on the table but in addition to preventing changes to the triggers on that table it also prevent them from adding columns to the table, modifying...

Another option:

WITH MyInputdata(ID, Val)

AS (

...

Just for fun, how would you rewrite the SSIS package using only T-SQL to "generate a couple of excel spreadsheets, and email them."?

Is there a weekend "index rebuild" job? That could cause a reduction in space if fragmentation was causing the bloat.

Jeff Moden (4/29/2013)

---

opc.three (4/26/2013)

---

A proper solution would be to get rid of the use of xp_cmdshell all together.

The recommended way using either a SQL Agent job or a web...

SSIS 2005 Script Tasks only support VB.net.

Open the package in BIDS, change the Connection Managers to point to the new server and database and then save it back to the original location where it is referred...

Start logging the "available MBs" counter, "page life expectancy" and the "page file % used" counter and see how they do over time. If you have memory pressure drops or...

This is most of what I use except I dropped the columns that use SQL 2008+ features. Hopefully some of it will help you:

-- memory overview

SELECT CAST((

...

vikingDBA (4/29/2013)

---

"You may as well keep the SP in cleartext"

While some people know how to decrypt encrypted stored procedures, I personally subscribe to bad guys the same way I subscribe...