August 28, 2003 at 5:13 pm
We want to give certain users access to create and alter tables in a database but feel installing SQL Server Enterprise Manager on their PCs is too much. Can anyone suggest an alternative (we don't want them to have to create and alter tables via sql code).
September 1, 2003 at 12:00 pm
This was removed by the editor as SPAM
September 1, 2003 at 9:11 pm
There are many tools available to access some common machine which you can use for sql changes. User can connect to such machines and do their job....
Netmeeting is free...
like that terminal services and pcanywhere are some...
Cheers..
Prakash Heda
Sr Consultant DBA
Bangalore, India
Chat: hedafriends@yahoo.com
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
September 1, 2003 at 9:26 pm
Thanks for the response heda_p but that is not what I was looking for. I am wanting an application like a front-end with a graphical user interface that allows users to access databases on the SQL Server that they have rights to so they can alter or add new tables. It would be nice if it had the table design feature like Enterprise Manager.
September 1, 2003 at 9:40 pm
One alternative is to give them Access, at least version 2000. You can create an Access Data Project (ADP) that gives the user the same interface for table design, views and stored procedures that they would see in EM. You don't have to worry about secrurity either, the ADP takes it queue from SQL Server. Hope this helps...Mike
September 1, 2003 at 10:17 pm
Thanks Data-Man, that is just what I wanted. I was not familiar with the features of Access 2000.
September 1, 2003 at 10:33 pm
When you open access 2002, the task pane is open on the right, under the heading new, click 'Project (Existing Data)'. This will bring up a save dialog...Choose an appropriate location (this file will contain all the code, forms, report, bascially anything that isn't SQL Server. Once you click Create, the data link form will open asking you for a SQL Server, authentication method, database, etc. Once done, all the tables, views, diagrams and stored procedures will show up in the database window. Very cool stuff. Hope this helps again...Mike
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply