SQLKnowItAll (1/31/2012)

---

So basically... The question on page 21 (for anyone using the book) which reads "Which edition of SQL Server supports installing more than one instance of SQL Server on...

All editions other than Enterprise Edition supports up to 16 instances and Ent Edition supports upto 50 instances. This is on a stand alone Server, on a failover cluster Ent...

I wrote an article on this. It can be tweaked to your choice (in terms of how frequent you want to get alerts).

http://www.mssqltips.com/sqlservertip/2307/automate-monitoring-sql-server-error-logs-with-email-alerts/%5B/url%5D

You might want to register in the online launch event to know more..

Microsoft would be launching SQL Server 2012 on March 7th in an online event, more information can be...

You can read about BIDS replacement SSDT in one of my previous blogs..

Getting started with SSDT-SQL Server Data Tools[/url]

Thank you very much, I appreciate your help.. I will explore this method..

It should be ..

SELECT Team_Name FROM tbl_teams WHERE Manager_ID IS NULL

ERIC CRUDELI (1/26/2012)

---

Another thing, after to implement this solution, I have to run a full backup because if I don't do that my diff backup doesn't work. Is it correct...

Marios Philippopoulos (1/26/2012)

---

Thank you all for your replies.

Anyone else? I would be interested in a few more replies, just to get a better feel of what people are doing out...

Tennis.. Aussie Open Semifinals..

I second Lowell's view, the database backup might have been taken before those users existed in the database..

Good to see someone coming back and say thanks..

Have a happy holidays and wish you good luck learning...

Do you see any sessions running against that database ? May be look at activity Monitor and filter by the database and see if there is any session connected...

Good Question...

Cookies...