getting sql server to work - help
I've just setup an account with hostmysite.com to use sql server 2000
using the login name and password they have given me I can connect to the sql server database from enterprise manager but once there I can't do zip, all the commands normally available in enterprise manager to create tables etc just ain't there anymore, I also tried to copy some tables to the database but wasn't allowed to create any new tables so was rejected and when I tried to create a table from query analyser the same happened.
The weird thing is that just before webexpose went wrong I tried the same with them using sql 7 and had exactly the same experience, since then I've totally rebuilt my machines but am now getting the same problem with sql server 2000. The real pain is that it works fine at home on my test server/client
Has anyone got any ideas please
Cheers
Brian
