Creating a Table on a Live DB

[RobHat]

Hi guys,
I realise this is probably a really simple question by a pretty new to SQL Server.

I am using SQL Server Management Studio Express on my local machine to connect to the live db on my hosting companys Full SQL 2005 server. All I want to do is create a new table in the db and set up columns and so on. Is this ok to do in the Live DB or do I have to do it another way?

Again sorry for simpleton question but I don't want to do something that is going to cause me more problems than need be.

Thanks for the help in advance

Rob

 

[bborissov]

Sure it is OK.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[RobHat]

Hi thanks for the confirmation. I thought it would be fine but wanted to check.

Regards

Rob

 

[JackVam]

I would recommend you keep all scripts in case you need to go back and see when changes occured , for troubleshooting

All the IT jobs in one place -

http://www.ITjobfeed.com

 

[RobHat]

Thanks for the Tip.

Rob