unable to Access complete database features
-
hello, i am usin sql server 2008.I have database which has been hosted on server i want to know whether they are given full access permission or not. bcoz when i work with local database it works fine. when i connect my server it will not works. like when i right click >> show top 1000 rows menu item will be displayed.it will not in when i connect to server. even i can't view tables listed in database.
-
hello, i am usin sql server 2008.I have database which has been hosted on server i want to know whether they are given full access permission or not. bcoz when i work with local database it works fine. when i connect my server it will not works. like when i right click >> show top 1000 rows menu item will be displayed.it will not in when i connect to server. even i can't view tables listed in database.
You need to contact the hosting provider to ascertain whether or not you can have full access - although this sounds like the server instance is not properly set up to accept remote connections to the SQL instance.
I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be
Forgive your enemies - it messes with their heads