473,554 Members | 2,093 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2041
hi Mike,
"Mike N." <Ba****@thepoun d.com> ha scritto nel messaggio
news:r3******** *********@newss vr25.news.prodi gy.com...
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********@virg ilio.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3092
by: izzy | last post by:
I was wondering if any of you guys can kindly help me in finding all the different versions of MSDE 2000 that came out since it's first release. I expected to find something similar like Sun's archive (http://java.sun.com/products/archive/index.html) for MSDE 2000 too but failed to find after a few hours of browsing at the Microsoft Download...
1
1747
by: Steve Bishop | last post by:
Hope MSDE questions ok here. I would like to distribute a MSDE application on CD ROM. I don't have any of the packaging solutions i.e. Visual Studio, Office Developer or VB Pro. I'm using MS Web Matrix to build an ASP.Net front for MSDE. How distributable is MSDE without the additional distribution products? Would I need to load up MSDE...
1
1886
by: DB developer | last post by:
Hello friends I am trying to create a deployment project to distribute my VB.NET application with MSDE database. I am using VS.NET with MSDE 2000 deployment toolkit (release candidate) to achieve this. I am facing the following problems I am deploying the database by copying to .MDF and .LDF files in destination folders using deployment...
1
1490
by: David | last post by:
I have a database application running on my development machine and now want to distribute the application to a third party. Would someone mind please explaining how I can modify the Setup Solution to distribute MSDE with the application. And, doe sthe third party need to then manually install MSDE and create the same instance or will the...
1
1810
by: hplloyd | last post by:
I want to include MSDE 2000 as part of my setup project for a VB.NET app from withing VS.NET 2003. I am having trouble finding out how to do this in terms of changing the settings re instancename and targetname. Is there a simple guide for finding out how to do this for us mere mortals without having to go down the path of using the...
5
13527
by: Evgeny Gopengauz | last post by:
Please help me to clean a Windows 2000 Pro instance which is "dirty" with the MSDE 7.0 and/or/both MSDE 8.0 previously incorrect installed/removed. I have a software product installation containing MSDE 7.0. When I tried to install MSDE 7.0 I got an error "You have installed MSDE". *** Sent via Developersdex http://www.developersdex.com...
4
2688
by: ad | last post by:
I am using MSDE as the database of my program. At the begin of my program, it must display a form for user to enter the password After the user enters the password, I will check the password, if it is the correct password of a user of MSDE ..
2
1316
by: Brian Scott | last post by:
Hi, We are currently using MSDE as a local database for our customer focussed applications. Does anyone else deploy MSDE with their applications and if so what model do you use?
12
2298
by: Dan V. | last post by:
Since an ASP.NET/ADO.NET website is run on the server by a single "asp_net worker process", therefore doesn't that mean that even 50 simultaneous human users of the website would appear to the database backend as a single user. Therefore, wouldn't switching our Access (actually Jet 4.0 OLEDB) database backend on our ASP.NET/ADO.NET website to...
4
1284
by: Fred Nelson | last post by:
Help! I just upgraded MSDE to the latest version on my Windows 2000 server. Everything appears to work fine - the enterprise manager on both the server and on my computer are able to access the new database and I have loaded it with all of its data using the enterprise manager. (Actually I've completed the entire cycle three times!) The...
0
7530
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8047
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7893
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6156
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5441
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3570
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3556
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1141
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
845
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.