Great article.

Thanks for writing this article. I was in need of one such article.

~ IM.

Steve Jones - Editor (5/22/2009)

---

Cost isn't necessarily an issue. If you install Standard edition (or workgroup) twice on a server, you need two licenses. You don't get unlimited licenses in...

This issue could be related to IP address,

From reporting server (Server A) you are trying to connect to database on Server B. Server A is on local system. You...

You said you have an alert to notify DBA's when log file grows beyond 95%, you can add response to that alert.

Response would to execute a job.

First Step...

Start Browser Service.

Create exception on Windows Firewall or/and Anti Virus

Enable Allow remote access from Surface Area Configuration (SAC)

~ IM.

I believe, Named Pipes has nothing to do with Database Mirroring.

Database Mirroring is done...

I had a case when We had to clean database nearly 45 GB. It was a vendor's product. Vendor gave a simple delete script to purge/delete unwanted historical data. DBA...

Just to add Mohit's comment also Check SQL Server Browser service has been started.

~ IM

Make sure you do not use same port numbers for different instances on the same box.

You mentioned you have Mirror and Witness on the same box. Do not use...

Looks like there is some problem with your Machine. You should be able to ping smtp.gmail.com

Is it a server (Company Machine) or just a test box at home ?

If...

http://wtv.watchtechvideos.com/forum36.html

Vampire (4/7/2009)

---

Hello @sayfrend,

I used those instructions and configured Gmail...however, when i tried sending a test mail,it failed.

Below is the DBMail log entry:

Message:

The mail could not be sent to...

Vampire (4/7/2009)

---

Hello @sayfrend,

I used those instructions and configured Gmail...however, when i tried sending a test mail,it failed.

Below is the DBMail log entry:

Message:

The mail could not be sent to...

Usage :

This will give you when was database last accessed , selected, inserted, updated, deleted all information.

Compatibility :

This works in SQL Server 2005

Note :

Also. Information returned from...

Actually SET IDENTITY_INSERT ON would let you insert values into column...