SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 creating a scriptp
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gongxia649
So Suave

Azores
344 Posts

Posted - 04/11/2007 :  11:30:33  Show Profile  Visit gongxia649's Homepage  Reply with Quote
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

USA
37129 Posts

Posted - 04/11/2007 :  13:09:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
As always, you haven't provided enough details for us to help you. What exactly do you want to do?

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

gongxia649
So Suave

Azores
344 Posts

Posted - 04/11/2007 :  13:51:05  Show Profile  Visit gongxia649's Homepage  Reply with Quote
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
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/11/2007 :  13:56:17  Show Profile  Reply with Quote
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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 04/11/2007 :  14:01:00  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000