Reseller Hosting, Shared Hosting, Dedicated Hosting by Vortech Inc.

Go Back   Reseller Hosting, Shared Hosting, Dedicated Hosting by Vortech Inc. > >> General Public > H-Sphere Pre-Sales
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

H-Sphere Pre-Sales Post your questions about H-Sphere plans here.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 01-26-2005, 12:39 PM
baycom baycom is offline
Registered User
Junior Member
 
Database Issues

Well,

I am trying to import data from an existing database (local to my pc) to the one hosted by vortech. I can copy the structure and SPs, but when I try to copy the data, I get an error like: user does not have rights to alter database

does anybody have had a similar experience?
Reply With Quote
  #2  
Old 01-26-2005, 03:07 PM
Silverbug's Avatar
Silverbug Silverbug is offline
Custom Built Solutions
Vortech Inc. Customer
 
Location: AK, New Zealand
Send a message via ICQ to Silverbug Send a message via MSN to Silverbug Send a message via Skype to Silverbug
what sort of database is it?
__________________
Paul Foley
Sniper Systems Ltd

Reply With Quote
  #3  
Old 01-26-2005, 03:09 PM
baycom baycom is offline
Registered User
Junior Member
 
It's a SQL database. I finally saw that it does import the data. It just keeps giving me that error.
Reply With Quote
  #4  
Old 01-26-2005, 03:41 PM
Silverbug's Avatar
Silverbug Silverbug is offline
Custom Built Solutions
Vortech Inc. Customer
 
Location: AK, New Zealand
Send a message via ICQ to Silverbug Send a message via MSN to Silverbug Send a message via Skype to Silverbug
ok, good to hear you got it sorted.
__________________
Paul Foley
Sniper Systems Ltd

Reply With Quote
  #5  
Old 01-26-2005, 03:56 PM
Brangwyn Brangwyn is offline
T3CHN0 STUD
Vortech Inc. Customer
 
Location: New Zealand (Wellington)
Remove the Alter commands from your script if your running it from a generated script. At vortech you do not gt dbo rights so some commands are outside your security role context.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
2004-10-27 Network Issues, Windows Server Issues in Rack 2. FIXED alexc Network / Server Status 9 10-29-2004 03:19 AM
MS SQL Database Backups Brangwyn Chit Chat Public 40 12-25-2003 05:42 PM


All times are GMT -5. The time now is 05:59 AM.


Powered by vBulletin Version 3.5.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Vortech Inc. ©2005
Page generated in 0.47650 seconds with 17 queries
[Output: 54.06 Kb. compressed to 50.39 Kb. by saving 3.66 Kb. (6.77%)]