Well no doubt this will a good one.

But when i'm trying to execute this script all the time it's giving the following error. Have rectified few of them. Is there...

script is ok. But it's not able to generate script for schema specific SP's.

Example:

Exec sp_Generate_Script 'Schema1.StoredProcedure,'Schema2.StoredProcedure,dbo.usp_xx';

It's not giving any result set.

Regards,

Karnatakapu. Mallikarjuna

Hello Vinay,

Simply awesome.

It's working for SP's.

I have tried (changed a bit) using this script for creating table of one schema to multiple schemas.

But not worked. Can we achieve above functionality...

Hello Vinay,

It's a nice script. Quite useful to me.

How to achieve this functionality from your script.?

Rather than copying one object from one schema can we copy multiple objects from the...

Hi,

I have initialized the variables and when tried to execute it results in following errors.

Msg 102, Level 15, State 1, Line 142

Incorrect syntax near '?'.

Msg 102, Level 15, State 1,...

Hi

I'm using sp_send_dbmail in below given format. If i execute first two lines it's showing "Mail Queued" and executing fine then i'm able to receive mail.

...

Sorry hope i have not explained my problem clearly.

i want to check the status of the server(at OS level). i dont want to check either SQL or any other....

Right click on the required table on the source server -- > all taks -->Export data - > follow the wizard steps --> set the source and destination tables --...

Hi,

Thank you for the clarification given. It helps me to give a report to my superiors...

Could any one please tell me how to track the DML operations occuring on SQL...