I have Setup Database Mail through gmail. It works absolutely fine with no issue.

Like Ajay Said, we have to use port 587. In many websites this port is given wrong.

I...

If the XYZ/User1 user account is an Service Account, then SQL Server 2005 cannot detect and you cannot give access to SQL Server to this domain user Account.

In SQL Server...

It is because Guest Account is not diabled in master and tempdb.

Sql Server performs many actions internally and needs access to masterDB and tempdb.

So when a new user logs into...

Mayank Khatri (3/31/2009)

---

One thing in Mirroring is u have to set up your SQL server Agent and your SQL server under same account. Do it same thing with your Mirror...

Dude,

Please clarify what is your concern.

Your First question: You said you cannot install Client tools on a machine.

Above Problem Solved ?

Observation : I remember i use to install...

For SQL Server 2005, You can try this. This will give you any select, inserts, updates done on tables with datetime.

select

t.name

,user_seeks

,user_scans

,user_lookups

,user_updates

,last_user_seek

,last_user_scan

,last_user_lookup

,last_user_update

from...

One way to implement this would be to build an INSTEAD OF INSERT Trigger or check constraint that will check for uniqueness. While you build check constraint, you might be...

I Understand Partitioning Function is only available in Enterprise Edition, Then how come my application was able to use this feature when I had my database server on Work Group...

Please look at this link : http://msdn.microsoft.com/en-us/library/ms143504.aspx

For complete information about Database Mirroring, Check this link

http://www.sql-articles.com/index.php?page=articles/dbmrr.htm%5B/url%5D

Regards,

IM.

Nikhil,

I will repeat MG's words, You please try it once, post your query here. Definitely you will see comments from experts.

If you don't know how to write select statement using...

Another way to truncate logfile without taking backup is,

DBCC sqlperf ('logspace')

check for the %used column for your database

do the following,

Step1: Change your Recovery Model from Full to Simple

Step2...

I got reply from Microsoft, I asked them some thing, they answered me something else.

I asked them if Security update KB954606 is applicable to SQL Server Sp2 Express edition....

Thats what makes you...

Paresh,

High availability is very important I agree, but High performance is more important.

To be honest, what are the chances that you will ever use your DR server. (...