Lowell (6/25/2012)

---

well it's a syntax issue, i'd guess you are missing something compared to my working example. the leading N or a single quote, or something.

Can you post the EXACT...

I'm getting this error:

Incorrect syntax near 'T001371\ViewSSN'

sql.AB (6/18/2012)

---

If you have sysadmin access to the SQL Server database; you can simply issue the below command to check all the members of an AD group:

...

Thanks a lot guys.

Thanks Gail!

Is SNAC a.k.a SQL Server Native Client? If yes, can SNAC or SSNC be installed by itself or SQL Server RDBMS needs to be installed...

GilaMonster (3/1/2011)

---

Mirroring is predominantly a high availability/disaster recovery solution. Reporting is a secondary usage of it. If you have mirroring and the primary server fails (shuts down, destroyed, etc), the...

Thanks Gail. Great article!

Thank you.

Lynn Pettis (4/5/2012)

---

Restoring the master database is all you should have to do. Hopefully you back it up after all major changes, such as adding users, new databases, or...

Thank you.

GilaMonster (4/5/2012)

---

You could, just watch the IO impact.

Lots of database snapshots can have a serious impact on data modifications in the source DB. By lots, I don't mean hundreds,...

Gianluca Sartori (4/5/2012)

---

sunny.tjk (4/5/2012)

---

Can we detach a database snapshot?

The interface gives me the option to detach but when I click on detach, it gives an error saying "Cannot...

Lynn, I totally accept what you said "If you attempted to add a second null value to a column with a unique constraint, it would no longer be unique.". I...

Tried to google this and I found that Oracle allows multiple null values in a column with a unique constraint. So, I got curious if there's really a reason behind...

Thanks Steve, that answers all my questions.