Yea, you never know when you are going to pick up a useful nugget of information in the least likely place in the threads.

Personally, I think it's worth joining sqlservercentral.com...

Thanks for the input (this turned into a neat discussion!).

I just switched everything over to use backup compression for my full and differential backups, and it seems to be chugging...

Alright...I'll give it a shot.

I'm just doing simple backups now, and then zipping them. The speed of native compression is really impressive compared to my current process....

Hard to say if it's "wrong" based on what...

Kansas City, KS

Lynn Pettis (3/23/2010)

---

John Rowan (3/23/2010)

---

It's in Keystone, SD. The nearest 'big' town is Rapid City, SD, which is about 1/2 hour away. I was born just outside of...

MTY-1082557 (3/25/2010)

---

Hi all,

I have a database called DB and I need to restore it on the same Box with different name. Can anybody tell me if this instruction is...

Does this apply?

http://support.microsoft.com/kb/933265

The name change is probably your issue as Wayne said (or at least it's one issue you need to deal with if you haven't already).

If it doesn't match when you...

GSquared (3/19/2010)

---

Jason Shadonix (3/19/2010)

---

Stupid question - If you've already paid for Enterprise licenses, and have it installed everywhere, are you really going to get money back by switching to Standard...

Stupid question - If you've already paid for Enterprise licenses, and have it installed everywhere, are you really going to get money back by switching to Standard edition?

So you're in a development position and not in a DBA position? If that's the case, I (personally) wouldn't be spending much time figuring it out and make the...

And then you're also moving those backups you make onto the SAN to tape or some external/offsite place, right?

srikantzs (3/17/2010)

---

To just check the Permission set on that table,

I used a Table valued function,but it didn't return any rows.

SELECT *

FROM fn_my_permissions('tablename', 'OBJECT')

0 rows returned

which tells me the permissions...

Does any of the data it gets live on a different server than the procedure is running on?

If so, sounds like it's losing it's connection to a remote...