On 9/14/00, avex penned:
>Just a few questions....
>I am using SQL on a shared hosting environment....and they say that under no
>circumstances can we have access to the Enterprise manager...no matter how
>locked down it is.
>Is this a common practice?
>Do people have access to this with hosters offering SQL Server?
Check out CFXHosting. I don't know about Enterprise Manager, but you
supposedly have Access to CF Administrator and all tags and the CEO
says if you want it, you'll get it, or your money back. :)
>Also....you mentioned upsizing access databases to SQL Server....
>
>what is the best way of doing it? You said you have had good success...
Hi Chad. I'm very wet behind the ears when it comes to SQL Server. I
just purchased my own server a few months ago and am still a little
too tight to afford SQL Server and a separate box for it. So for now,
I just installed MSDE. I've got a couple apps that are a little too
busy to rely on Access, plus I recently swore off session variables
so I created the Client Storage database in MSDE. Basically, it's a
piece of cake. Just choose Tools-Database Utilities-Upsizing Wizard.
Choose to create a New SQL Server database and go from there. It will
ask you a few questions and you're done. Then you can make changes to
the structure, add records, etc., through the .ADP file that's
created. Of course, I don't know what good it would do you if you
don't have physical access to the remote server.
Note, that although you can install an upsizing wizard the use with
Access 97, it was nowhere near as clean as the one that comes with
2000.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
