It is very much possible. Read this.....

http://thetrainerph.spaces.live.com/blog/cns!9F717AF2A2401F0F!530.entry

http://technet.microsoft.com/en-us/library/ms345115.aspx

http://blogs.msdn.com/mrorke/archive/2005/07/21/441554.aspx

http://www.jasonfollas.com/wiki/SQLXML.ashx

🙂

Check this

http://www.sqlteam.com/article/sending-smtp-mail-using-a-stored-procedure

http://www.sql-server-performance.com/articles/dba/email_functionality_p1.aspx

http://qa.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/

http://www.databasejournal.com/features/mssql/article.php/3626056

Yes Matt is again bang on target.

XML Path is introduced only in 2005. You haven't specified the version you are using.

Remove Windows authorization and try to login. If it succeeds then go for Windows auth.

Like Microsoft tips check the basics, password is correct or not, password policy is ok...

Hi

It is an issue with your backup device (most likely). Check with the litespee customer support. They may give you some light on this.

Read these:

http://www.developer.com/db/article.php/3531196

http://www.15seconds.com/issue/050803.htm

http://blogs.msdn.com/mrorke/archive/2005/07/21/441554.aspx

http://www.devx.com/xml/Article/26766

http://msdn2.microsoft.com/en-us/library/ms345117.aspx

They may help you.

🙂

Read this:

http://www.mydigitallife.info/2007/10/31/error-has-occurred-while-establishing-a-connection-to-sql-server-2005-which-does-not-allow-local-and-remote-connections/

http://blogs.msdn.com/sql_protocols/archive/2006/04/28/585835.aspx

Read these links also

http://www.mssqltips.com/tip.asp?tip=1202

http://support.microsoft.com/kb/319951

SELECT U.uid,U.name,U.mail,R.name

FROM users U

INNER JOIN users_roles Ur

ON U.uid=Ur.uid

INNER JOIN role R

ON Ur.rid=R.rid

WHERE R.rid Not = 3;

Try this. This will also not display any data as you do not have any...

Gary

I totally agree with Jacob. You have to express fully your doubts. One more suggestion, I can give is try to go thru the archives of this site. It help...

There is no limition as such. Did you have any conditions within the triggers? If yes check whether the conditions are correct or not.

SP2 will make the life better no doubt but if microsoft release SP3 it would have been smooth. Guys go to connect and vote for SP3

🙂

Anirban

Hi

I am late to join this campaign. But definitely there is an requirement for SP3. Thanks the SQLServer community for doing lot of good work. A special thanks to...