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.
Author |
Topic |
gongxia649
So Suave
344 Posts |
Posted - 2007-04-11 : 11:30:33
|
when creating a script to recreate a table using ENterprise manager. what do i have to look at before running the script.like it will affect my triggers, passwords, applications, things like that |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-11 : 13:09:35
|
As always, you haven't provided enough details for us to help you. What exactly do you want to do?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
gongxia649
So Suave
344 Posts |
Posted - 2007-04-11 : 13:51:05
|
i want to drop and recreate a table. I wanna generate a sql script from enterprise manager. i want to know what i have to be aware of before executing the script |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-11 : 13:56:17
|
If it's live db, will affect apps use the db but will not affect password. Triggers on the table need be recreated, you can include that in the script in fact. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-11 : 14:01:00
|
You need to script triggers, permissions, constraints, and indexes with the drop/create. But why not just truncate table or delete from table instead?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|