Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can i modify the structureof a table in an sql server database remotely?

Status
Not open for further replies.
nujdonfoe11

nujdonfoe11

Programmer
Oct 14, 2014
3
PH
When developing applications, sometimes there are times when i have to add some fields or rename some fields in a table stored in the sql server which is located on the first floor of our building while i am on the third floor. Is there a way i can do this remotely. Thanks!
 
Sort by date Sort by votes
Sure.


Network both the server and the machine you are working in.
give permissions to your user to connect to that server and database
give permissions to alter tables in that database

issue the correct SQL Server command to change the table.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
341
Volvere
V
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
140
Chris Miller
Chris Miller
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
321
pjw001
pjw001
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
315
BobSuruncle
BobSuruncle
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
211
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top