Rewrite above...

It looks like simple UNION ALL operation. But still it is not clear, what exact requirement is?

What problem are you facing while designing this structure?

There is no such trigger. You can use Job instead.

See SQL server books Online

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

What are the relations among these tables? Describe more about expected result.

Check for temp table creation in your SPs. Temp database size also increase for some sorting/aggration operations.

You are welcome Praveen,

This is the very easy to do. But it may case security issue, if you don't want your user to have access of all object of database(s)....

In Object explorer,

- Explore Security Node

- Explore Logins

- Right click on your user and click on property

- Goto Server role tab and tic Sysadmin

-...

Give...

The user which you are using does not have permission to execute this SP.

Which user you are using to execute the SP? and what the role of that user?

You can use ALTER TABLE statment...

But why do you want to drop clustered index on PK? Is yous PK generaation not in order? Or want to created clustered index on...

Yes it is table access problem. Check access rights.

You can use different DB comparision tool

see this link http://www.sqlservercentral.com/articles/Tools/64908/

You might not have GRANT on this table. Check with your administrator about the access.