HanShi (5/7/2013)

---

If you create a new AUDIT from SSMS the first window gives you the option to select the destination. The available options are "File", "Security Log" or "Application Log"....

Actually it was more embarrising then...

SOLVED.

The proper connection string was:

Data Source=SQL04\SS2008R2;Initial Catalog=MYTESTDB

Thanks to those who replied.

Lynn,

The user name & password both go in seperate fields form the Connection string box. Yeah I thought that was odd to but thats the way its setup.

Thanks

Lynn Pettis (4/15/2013)

---

The best I can provide is based on when I was setting up database mirroring. First, iirc, you need to select a port number above 1024, and...

Jack Corbett (4/9/2013)

---

charlesd (4/2/2013)

---

The script is very useful. I know it was designed for SQL 2005, however it also seems to work on SQL 2008. I...

Thanks for replying but that just over rides the from...

Thanks Lowell.

I ran the script you provioded aginast both SQL Servers, saved them each to a file and then using UltraCompare I compared the 2 and theyr are indetical with...

I actually...

opc.three (1/12/2013)

---

AD Groups as SQL Logins and Database Users work great unless you need the User to have a default schema. In SQL 2012 the loop has been closed, but...

ScottPletcher (1/13/2013)

---

The person's login id is often some combination of last name and first name, so you need to change the name there.

However, internally you should assign each person/user a...

Vedran Kesegic (1/11/2013)

---

If that are windows logins, why granting them individually? You could create windows (AD) groups, and sql login for that group.

Managing rights will be much easier on the...

markodonovan (12/17/2012)

---

Hi YSLGuru,

You should be able to do this with QlikView.

In the past I have created dashboards on the SSRS reportserver database in QlikView to check the performance on the...

GilaMonster (1/10/2013)

---

YSLGuru (1/10/2013)

---

Is it possible duing the restore to restore the DB so that it have a small amount of room to grow and not the full amount that the...

I was afraid of that. A 200GB+ DB can take a very long time (on a test/dev server) to shrink.

How about during the restore...