No, you can't access the Active Directory list of logins and users via T-SQL.

pm.praveen.mehta89 (4/17/2013)

---

Hi,

For restoring a db from transactional backup first u need to restore latest full backup with 'RESTORE WITH RECOVERY' option then transactional log backups(except latest transactional backup) in sequence...

Speak to your AD team, ask them to set the account to not allow interactive logins (users should not be using the service account) and ask them if they can...

sqlfriends (4/16/2013)

---

I have a view, if we runs it individually in SSMS, it runs ok, but we have a batch process at night that uses it for each individual. so...

Recovery model has nothing to do with it, the log is used almost the same (baring only minimally logged operations) in all three recovery models.

Maybe. Depends whether those are separate IO paths or not, whether the DB is IO bottlenecked or not.

I'll pass thanks, petrol's fine.

Oh,...

Nosferatu? Don't think the car has energy vamps fitted. Will have to check the manual.

Or wrong game slang?

If you need specific advice, please start a new thread in the appropriate forum (based on SQL version) and post the output of the CheckDB.

Lynn Pettis (4/16/2013)

---

Either nobody has had any complaints, nor needed someone to jump into an issue, or else everyone is just to darn busy...

http://sqlinthewild.co.za/index.php/2009/02/19/estimated-and-actual-execution-plan-revisited/

http://sqlinthewild.co.za/index.php/2011/05/17/on-transactions-errors-and-rollbacks/

If you want SQL to automatically roll back transactions in case of an error. Personally it's a setting...

Exactly the same answer.

The only limit is the size of your storage, or the maximum database size (524,272 TB, which is beyond any storage you're likely to have)