Different SQL mail

my config is SQL2000, outlook xp
now i use xp_sendmail to see email from SQL2k
how can i use different mail profiles for different database?
or i can control it at script level?
i have searched google for this and seems it is feasible.
grateful if you could give me some hints.
by the way, i am going to upgrade SQL2000 to SQL2005.
Thanks a lot.
tonyHi
xp_startmail will take a different MAPI profile. You may want to use XPSMTP
instead where the source can be specified http://www.sqldev.net/xp/xpsmtp.htm
John
"Tony WONG" wrote:
> my config is SQL2000, outlook xp
> now i use xp_sendmail to see email from SQL2k
> how can i use different mail profiles for different database?
> or i can control it at script level?
> i have searched google for this and seems it is feasible.
> grateful if you could give me some hints.
> by the way, i am going to upgrade SQL2000 to SQL2005.
> Thanks a lot.
> tony
>
>

Different SQL mail

my config is SQL2000, outlook xp
now i use xp_sendmail to see email from SQL2k
how can i use different mail profiles for different database?
or i can control it at script level?
i have searched google for this and seems it is feasible.
grateful if you could give me some hints.
by the way, i am going to upgrade SQL2000 to SQL2005.
Thanks a lot.
tonyIf you upgrade to 2005, consider using Database Mail instead. See sp_send_dbmail in the 2005
documentation.
As for 2000, I believe that you optionally can use different profiles, although I've never tried it.
See the documentation for xp_startmail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tony WONG" <x34@.hknet.com> wrote in message news:enyZScRwGHA.1272@.TK2MSFTNGP05.phx.gbl...
> my config is SQL2000, outlook xp
> now i use xp_sendmail to see email from SQL2k
> how can i use different mail profiles for different database?
> or i can control it at script level?
> i have searched google for this and seems it is feasible.
> grateful if you could give me some hints.
> by the way, i am going to upgrade SQL2000 to SQL2005.
> Thanks a lot.
> tony
>

Different SQL mail

my config is SQL2000, outlook xp
now i use xp_sendmail to see email from SQL2k
how can i use different mail profiles for different database?
or i can control it at script level?
i have searched google for this and seems it is feasible.
grateful if you could give me some hints.
by the way, i am going to upgrade SQL2000 to SQL2005.
Thanks a lot.
tonyHi
xp_startmail will take a different MAPI profile. You may want to use XPSMTP
instead where the source can be specified [url]http://www.sqldev.net/xp/xpsmtp.htm[/url
]
John
"Tony WONG" wrote:

> my config is SQL2000, outlook xp
> now i use xp_sendmail to see email from SQL2k
> how can i use different mail profiles for different database?
> or i can control it at script level?
> i have searched google for this and seems it is feasible.
> grateful if you could give me some hints.
> by the way, i am going to upgrade SQL2000 to SQL2005.
> Thanks a lot.
> tony
>
>

Differences in MS SQL7 and MS SQL2000

I am having difficulty convincing my management to upgrade from our existing MS SQL7 Database to MS SQL2K. I know that SQL2K offers enhanced performance and ease of use but am unable to find any white paper or documentation online that shows me the advantage of SQL2K over our current older version. Is anyone here facing the same problem as me? If any one has any documentation or hyperlinks to point me in the correct place, just post here or drop me an e-mail at chanmunyew@.msn.com to help...any help at all is greatly appreciated!! thanks guys!More links than you can shake a stick at, hope these help:

http://www.microsoft.com/catalog/display.asp?site=10145&subid=22&pg=4#167937

http://www.microsoft.com/sql/evaluation/overview/whatsnew.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;323049

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part1/c0261.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/whatsnew/wn_whatnew_7im0.asp

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/sql/sq092700.asp|||Thanks!!!!!

Differences between SQL2000 Dev. Edition & SQL2005 Dev. Edition

Hello all,

Can anyone tell me or suggest links about differences of SQL Server
2000 Developer Edition & SQL Server 2005 Developer Edition?
Specifically, I need to know about the licencing policy.

So far I know that SQL Server 2005 Developer Edition is licenced for
develpoment (what else), test and demo use. Each licence entitles only
one developer to use the software on as many systems as necessary and
additional developers can use the software by parchasing additional
licences (some sentences borrowed by microsoft's presentation of the
product).
Does 2000 Edition has more functions than the latest one? In other
words, what the advantages and disadvantages of these 2 Versions?

Thanks in advance?

PS: Shoul I post this here?x-rays wrote:
> Hello all,
> Can anyone tell me or suggest links about differences of SQL Server
> 2000 Developer Edition & SQL Server 2005 Developer Edition?
> Specifically, I need to know about the licencing policy.
> So far I know that SQL Server 2005 Developer Edition is licenced for
> develpoment (what else), test and demo use. Each licence entitles only
> one developer to use the software on as many systems as necessary and
> additional developers can use the software by parchasing additional
> licences (some sentences borrowed by microsoft's presentation of the
> product).

http://www.microsoft.com/sql/howtobuy/development.mspx

> Does 2000 Edition has more functions than the latest one?

No. SQL Server 2005 Dev Edition is feature equivalent to SQL Server
2005 Enterprise. Other than the licence the only difference I'm aware
of is that Dev works on the desktop Windows OS whereas Enterprise
doesn't

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--|||Hello David,

thanks for replying, my last question was a bit thick I suppose "Does
2000 Edition has more functions than the latest one?", a newer version
is always better. What was the licence policy of SQL Server 2000 Dev.
Edition? Do you remember?

And a 2nd one, did microsoft stop selling SQL Server 2000 Editions?

PS: Please excuse my english.

Thanks in advance!

David Portas wrote:
> x-rays wrote:
> > Hello all,
> > Can anyone tell me or suggest links about differences of SQL Server
> > 2000 Developer Edition & SQL Server 2005 Developer Edition?
> > Specifically, I need to know about the licencing policy.
> > So far I know that SQL Server 2005 Developer Edition is licenced for
> > develpoment (what else), test and demo use. Each licence entitles only
> > one developer to use the software on as many systems as necessary and
> > additional developers can use the software by parchasing additional
> > licences (some sentences borrowed by microsoft's presentation of the
> > product).
> http://www.microsoft.com/sql/howtobuy/development.mspx
> > Does 2000 Edition has more functions than the latest one?
> No. SQL Server 2005 Dev Edition is feature equivalent to SQL Server
> 2005 Enterprise. Other than the licence the only difference I'm aware
> of is that Dev works on the desktop Windows OS whereas Enterprise
> doesn't
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/...US,SQL.90).aspx
> --

Differences between SQL 7 and SQL 2000

Hi friends, Anyone can bring me a document describing the differences and new
features between SQL 7 and SQL2000?
Thanks all!Hi,
A lot of differences:-
1. Recovery models
2. Automated Logshipping
3. UDF
4. Multiple instances of SQL Server running in paralel
5. Instead of Triggers
6. Memory (64 GB) and 32 Processor support
The list goes on...
See the topic "Relational database enhancements" in Books online.
Thanks
hari
SQL Server MVP
"Tinchos" <Tinchos@.discussions.microsoft.com> wrote in message
news:9C4EF0D9-CB89-47B9-B9F5-CF208C04E0E9@.microsoft.com...
> Hi friends, Anyone can bring me a document describing the differences and
> new
> features between SQL 7 and SQL2000?
> Thanks all!|||If you are thinking about upgrading from 7.0 you might as well bypass 2000
and go straight to 2005. It will be out soon enough.
http://www.microsoft.com/sql/2005/default.mspx
--
Andrew J. Kelly SQL MVP
"Tinchos" <Tinchos@.discussions.microsoft.com> wrote in message
news:9C4EF0D9-CB89-47B9-B9F5-CF208C04E0E9@.microsoft.com...
> Hi friends, Anyone can bring me a document describing the differences and
> new
> features between SQL 7 and SQL2000?
> Thanks all!