Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Alter the table structure if there is difference

Author  Topic 

NamrataC
Starting Member

5 Posts

Posted - 2010-11-29 : 08:34:48
Hi All,
With the help of post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=136699
I was able to find the difference between table structures from my development server and production server.
But yet I'm unable to alter the table structure of production server on finding the difference.
Please help me to do so.
Thanking you in anticipation.

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-11-29 : 08:39:36
How are you trying to alter the table structure and what is going wrong?


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-12-01 : 13:36:03
may be you dont have ALTER rights on production objects

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -