Yes its true practically as you are de allocating

cursor in the end of first cursor.

So the cursor can be used once again.

Can You please specify the error message you receive .

You can also try to defragment indexes as fragmentation may have increased for indexes

Rebuild or Reorganize indexes to improve their performance.

I Think you should learn about the temporary tables created for

#inserted

#deleted so as to maximize their utilization for your task.

these are part of auditing triggers.

hey this is how it works.

what are your issues with this type of script generation as it is works well

for the object creation.

As per my Findings no cause constraints are related to one another

if created earlier will cause the script to fail.

If you are using an identity column on your SQL Server tables, you can set the next insert value to whatever value you want. An example is if you wanted...

DDL statements are logged in Server Log

beside this you can also refer this link for additional information

http://msdn.microsoft.com/en-us/library/ms180892(v=sql.105).aspx

YOu can either come up with a procedure for this

where you pass database name as a parameter

or you can

modify the query

SELECT 'USE Serv DROP TABLE [' + SCHEMA_NAME(schema_id)...

See your error shows that user donot have permission to execute FULLTEXT

so you can give permission for the same.

refer to this link for further reference

http://msdn.microsoft.com/en-us/library/ms190502.aspx

Two ways to do this are

1. to use exec MS_FOReachDB

http://www.mssqltips.com/sqlservertip/1414/run-same-command-on-all-sql-server-databases-without-cursors/

2. to use cetnral management server.

http://msdn.microsoft.com/en-us/library/bb934126.aspx

CTE can be modified to select non duplicate values .

Please Refer,

http://msdn.microsoft.com/en-us/library/ms190766(v=sql.105).aspx

WITH CTE (

[ColumnName]

,[DuplicateCount]

)

AS(

SELECT

[ColumnName]

,[DuplicateCount]

,ROW_NUMBER() OVER(PARTITION BY [ColumnName]

ORDER BY [ColumnName]

AS DuplicateCount

FROM sample_table

)

DELETE

FROMCTE

WHERE (DuplicateCount > 1)

I think this an efficient way.

See you can also try to give access permission on master and grant on sp_executesql..

you all people are right at your points.