Luis Cazares (6/4/2013)

---

I believe your results are being returned to text and not to grid.

To avoid that problem you could use nested REPLACE on the columns that are giving you...

Thanks for the suggesting Lowell. Thats what I've been working on as a work-a-round but I was hoping there might be a better answer. I must admit I...

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...