469,923 Members | 1,277 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,923 developers. It's quick & easy.

are there any MSDE T-SQL code limitations?

I am writing a database app which will run under MSDE on the user's systems.

Other than limitations as to the number of concurrent users, are there any
issues that I need to be aware of when programming the database using SQL
Server 2000? i.e., are there T-SQL programming statements that will run
under SQL Server 2000 as part of my development enviornemnt that won't run
under MSDE on the end users machines, or will MSDE handle anything that SQL
Server can from the database engine standpoint?

Thanks!
Jul 20 '05 #1
1 1868
hi Mike,
"Mike N." <Ba****@thepound.com> ha scritto nel messaggio
news:r3*****************@newssvr25.news.prodigy.co m...
I am writing a database app which will run under MSDE on the user's systems.
Other than limitations as to the number of concurrent users, are there any
issues that I need to be aware of when programming the database using SQL
Server 2000? i.e., are there T-SQL programming statements that will run
under SQL Server 2000 as part of my development enviornemnt that won't run
under MSDE on the end users machines, or will MSDE handle anything that SQL Server can from the database engine standpoint?


all T-SQL statements SQL Server 2000 supports are supported by MSDE...
you only (only...) have database limitation size, limited replication
support, no mail support...
for further info please visit
http://www.microsoft.com/sql/msde/pr...o/features.asp

hth
Andrea Montanari (Microsoft MVP - SQL Server)
an********@virgilio.it
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.4.0 - DbaMgr ver 0.50.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by izzy | last post: by
1 post views Thread by Steve Bishop | last post: by
1 post views Thread by DB developer | last post: by
5 posts views Thread by Evgeny Gopengauz | last post: by
4 posts views Thread by ad | last post: by
2 posts views Thread by Brian Scott | last post: by
4 posts views Thread by Fred Nelson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.