Ray Mond (12/29/2010)

---

Agree with Grant re. the need to actually restore from a database backup to ensure it's recoverable.

RESTORE VERIFYONLY is fairly useless (with regards to data integrity in the...

gmamata7 (12/29/2010)

---

Perhaps you want to explain what you are trying to do in the database from a logical perspective, rather than saying you want a login to own a schema....

Jack Corbett (12/29/2010)

---

in addition to Gail's and Grant's advice I'd suggest getting Adam Machanic's sp_WhoIsActive which will also give you the query text.

You can get the query text yourself...

Craig Farrell (12/29/2010)

---

Hey guys. Blogging/articles and the like are relatively new to me, so I'd like your educated opinions on how I should look at this:

http://balapalani.blogspot.com/2010_12_01_archive.html

It's roughly a copy/paste...

What's the deal. You guys can't keep your girl friend satisfied? She sent me four messages last night. She's begging for attention. Come on on gentlemen. Do your duty.

There is no completely reliable method for retrieving this information. Almost any method you use can be spoofed because a given table is only accessed once a month/quarter/year and if...

GRANT CREATE TABLE ON SCHEMA::MySchema TO MyUser

You'd need to do that for PROCEDURE, VIEW, etc.

Koen (da-zero) (12/29/2010)

---

Grant Fritchey (12/29/2010)

---

Hi Ankur,

Yes a full backup every night means that you should be able to recover up to the last full backup. And, yes, you're right, without...

No big deal. Like I said, for future reference.

It can just lead to confusion when people...

Jack Corbett (12/29/2010)

---

Hey, did you know that SSC is now a dating site? Here's a PM I got from lord.god90:

Hello My New Friend.

Good Day and How are you today.

Please...

ankur_libra (12/29/2010)

---

Hi All,

The similar case is with one of our clients which are using the Symantec Backup Exec 12.5. They have also purchased SQL Agent license from MS. Now...

Since SQL Server is turned off, yes, those backup files are useful. They can be used to reattach a database in the event of a disaster. Now, you won't have...

check sys.dm_exec_sessions to be sure you're seeing all connections. sys.dm_exec_requests only shows active connections.

Ha! You'd get a few, for...

Brandie Tarvin (12/29/2010)

---

Okay. WIT 24 hours of PASS is accepting abstracts for March. I'm assuming this is Pre-Rally 24 hours of PASS (haven't had a chance to double-check the dates)....