Generating Script 1

[SajidAttar]

Not sure anybody else is aware of this, but to those who dont aware of this tricky method of generating script of SQL object like Tables, Views, Procedures, Functions.

To generate the script for objects such as Procedures, tables and views I used to follow following steps . .
Right Click on Object > All Tasks > Generate SQL Script . . and follow the steps in script generator.

Here is the simple trick for this . .

Select objects in Enterprise Manager that you want to script > press Ctrl + C (Copy) > Goto Query Analyzer / Notepad or any other text editor > Press Ctrl + V (Paste)

Or

Siply Drag and Drop the object from Enterprise Manager to Query Analyzer or any text editor

You will find the script for selected object. This way you can save your lots of time.



Regards,


"There are no secrets to success. It is the result of preparation, hard work, and learning from failure." -- Colin Powell

 

[jbenson001]

SajidAttar.. great tip..

I just tried dragging some ojects From EM to QA.. Pretty cool stuff.. didn't even know or think that you could do that...

Jim