Francisco H Tapia
my.lists at verizon.net
Wed Feb 19 16:31:42 CST 2003
I'm not sure what you mean by connections to distant servers... if you mean managed via EM, then yeah that would be my preferred choice, because you can manage users and other mundane database tasks. Unless of course you mean Remote Server, as in a remote server link (as in Linked Server). My question is, if you are seperating tasks accross servers, then that makes sense, otherwise... ?huh? ;o) -Francisco http://rcm.netfirms.com ----- Original Message ----- From: "Arthur Fuller" <artful at rogers.com> To: <dba-sqlserver at databaseadvisors.com> Sent: Wednesday, February 19, 2003 2:24 PM Subject: RE: [dba-SQLServer]Re: MSDE and SQL Server WAS: (dba-SQL down?) : That's what I needed to know! Thanks. I have an available XP box that must : have MSDE installed, since it contains the .Net framework and Visio, both of : which (I think) install it. So I can start there and build everything I need : there. : On a somewhat related issue, what's the best way to go about setting : connections to distant servers? : a) set up a connection using an IP : b) set up a remote server in EM : c) some other way that hasn't occurred to me yet : : : -----Original Message----- : From: dba-sqlserver-admin at databaseadvisors.com : [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Francisco H : Tapia : Sent: February 19, 2003 5:07 PM : To: accessd at databaseadvisors.com; dba-SQLServer at databaseadvisors.com : Subject: [dba-SQLServer]Re: MSDE and SQL Server WAS: (dba-SQL down?) : : No. You can install a full blown version of SQL Server over an existing : copy of MSDE but then whenever you decide to uninstall you won't be able : to... hehehe thanks MS. If you want to test out the throttled connections : you'll have to install MSDE on another box. : : -Francisco : http://rcm.netfirms.com : ----- Original Message ----- : From: "Arthur Fuller" <artful at rogers.com> : To: <accessd at databaseadvisors.com> : Sent: Wednesday, February 19, 2003 1:43 PM : Subject: RE: [AccessD] dba-SQL down? : : : : Thanks for the heads-up. : : : : Let me post the questions here, then, since so many listers are doubled. : : : : Can you run MSDE on the same box as SQL Server? Simultaneously? If so, : : how can you determine which one you're connected to? If so, how can you : : specifically target, say, a database residing in MSDE rather than SQL : : 2000? : : : : For reasons I won't detail, I have to provide a package that lets end : : users run an MSDE copy on their boxes rather than hooking into the : : internet database that is normally used. It's running against my SQL : : 2000 install at the moment. I want to put MSDE on and DTS the data there : : and then reconnect the ADP to the MSDE database. : : : : Recipes? Advice? : : : : : : : : -----Original Message----- : : From: accessd-admin at databaseadvisors.com : : [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Wortz, Charles : : Sent: February 19, 2003 3:30 PM : : To: accessd at databaseadvisors.com : : Subject: RE: [AccessD] dba-SQL down? : : : : : : : : Arthur, : : : : : : : : I've seen messages on it today, but not yours. : : : : : : : : Charles Wortz : : Software Development Division : : Texas Education Agency : : 1701 N. Congress Ave : : Austin, TX 78701-1494 : : 512-463-9493 : : CWortz at tea.state.tx.us : : (SELECT * FROM users WHERE clue > 0) : : : : -----Original Message----- : : From: Arthur Fuller [mailto:artful at rogers.com] : : Sent: Wednesday 2003 Feb 19 14:24 : : To: 'AccessD' : : Subject: [AccessD] dba-SQL down? : : Importance: Low : : : : I sent a message to dba-SQL earlier today and still haven't seen it : : appear - but a couple of dozen messages have appeared in AccessD since : : then. Is it down? : : : : : : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com :