When I switch from office network to home wireless, my app using a MSDE
instance has got problem in finding the database. Obviously, the change in IP
Address is not liked by the MSDE server. I believed the XP Pro is more
friendlier in switching between adapters, or am I wrong?

Hey guys, I have the MSDE SQL Server 2003 running on my SBS 2003.
I am using my laptop to develop my website with Microsoft Visual Web
Developer.
I've been trying to create a connection to the SBS 2003 SQL server but I

I have just installed SQL Server 2005 Express Adv. which I expected to
have the Agent service.
How do I install the agent service and where can I get it from??
Thanks

Greetings, if anyone has advice or can point me in the right direction
it would be appreciated. Been a week now, and I just can not make
progress on this issue. Machine is windows xp sp2
UPS Application Error Message:

How do I import a db into MSDE2000?  Can it be done?  I backed a db up from
another server and now I want to import on to this new machine.  Not sure how
to go about doing that though...
Thanks.

I see that the max length of datatype text is some where abouts 2
million characters.
My question is, when I conenct the MSDE database to SQL Enterprise
administrator, and look at the table design, the length of the data

I am using the "Web Data Administrator" on the MS SQL Server (2000 I think)
database provided by my ISP.
I use the Export function every so often so that I can make a copy on my
local SQL server, (I have no access to DTS on the ISP server).

I am trying to resolve a problem with an SQL database for a known antivirus
application we use. Along the way someone has installed SQLExpress on the
application server and managed to upgrade the database using this.
Starting from the begining....I was resolving a problem with ...

Any problems installing the client tools from Sql2000 on an MSDE
instance to provide GUI management capability?

Trying to add more functionality to the following trigger. Need to insert
three field into another table using the ID from the first insert (i.id),
the ID from the Trigger Insert (??)  and a QTY value of .25? My question is
how do I get the ID from the trigger insert?

Trying to make a trigger - not sure of right syntax...
Table ITEM
ID
Description nvarchar(30)

To all SQL guru
I understand MS SQL Express can only "subscribe" which means u need Full
version of MS SQL to do the "publication" .
Is there any other way to do some sort of replication without the full MS

Several consecutive records have been deleted out of an MSDE database
and the program that uses the database doesn't like it.  I'm curious
if it's possible to... say... reset the primary key count so that the
records all shift to fill the "dead space" left by the deleted

I'm trying to connect to a MSDE database on a remote system.
I have no problems connecting locally.
I have changed the security to mixed mode, and i have made a NAT entry
that forwards port 1433 to the internal server with the MSDE database

Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
Thank you very much for help.
Best regards