Have you actually done 1 of these? I've tried a couple variations of @svrproduct and @provider without luck. I can of course connect to this 2008 server from another 2008...

The package migration wizard will ask you to make sure you have a backup of your 2005 packages; not a bad idea since once they're migrated to 2008 they can't...

TravisDBA (4/23/2010)

---

Absolutely yes! We just completed a production archival of over 150 million records we no longer needed on our daily production boxes. It's not really complex to do, but...

Thanks for the speedy response. Good to know. I also agree with the posts that say their DBs are growing by more than they asked for. I've gotten 20%+ growth...

Lynn Pettis (4/16/2010)

---

mark.pleasance (4/16/2010)

---

I work for a SMB beverage alcohol import agency . . .

As compensation we receive . . .

Competitive pay (reviewed ad-hoc,) flex time, work from home,...

Robert.Smith-1001156 (4/16/2010)

---

I think employers underestimate the value of giving geeks paid time to play with new technology. There's not a lot of cost there, especially if you can work...

My company has to keurig coffee machines, an expresso machine and about 50 different types of coffee and tea. All free of charge.:w00t: It doesn't cost them a...

Yes, your sp_who3 returns the same info as sp_who2 using the login param. I see. You retained existing code for this param while adding your own for the DB param.

Ken

I can get it to compile on SQL 2005 and 2008 on a couple IA64's and it runs ok using the DB param. If there's no DB matching the name...

Grant Fritchey (4/8/2010)

---

Ha! I did office clean-up for a while too. I agree, it teaches lots of lessons. And, it provides excellent perspective. I'll always remember just how sweet I've...

majorbloodnock (3/19/2010)

---

Like Phil, my company has a healthy attitude to training; indeed it's an integral section of our regular formal performance reviews. That means, of course, that if either manager...

GSquared (2/12/2010)

---

For me, it depends on the data loss policies of the company, and the ability to recover data.

For example, I used to manage a database that was just a...

A year or 2 ago we though we had this very issue licked. The other night, out of the blue, our Oracle --> SQL Server job stops working with this...

Wow! Your boss lets you spend working hours answering questions on forums like this and you get paid for this as well? Man! Where do I sign up for that...

Ours is intranet with NT authentication but it's a vary large #...