Hi all,
What is the best way to see all the objects (indexes,PK,constraint,triggers) that related to my table "LARGETable" by a sql query?

exactly

I don'r have many experience with partitioning.
and also the instance Edition is Standard 🙁

Yes.

but i want to keep the data on table that will be call "LARGETable_OLD" (truncate is not an option).

Hi RVSC48,
Thank you very much for your quick answer!
It's help me very much!!!
I just added a filter:

and prin.type_desc != ''DATABASE_ROLE''

because i dont need...

Thanks for the quick response and this great article.

For a restore of multiple use the dynamic script below.
Please run the script on the Source server and than run the output on the Target server.

set nocount...

Hi all,
I found script that can dynamically made a backup for all DBs (run the script on the Source server and also execute the output):

/*    Created By:        AJAY DWIVEDI

Hello Debasis,
Thank you very much for your quick response!
i got this dynamic SQL query to retrieve a script that generate all the table that have a dependency to...

Hi Ed,

This is a great link!

This paragraph in the article helped me a lot:

"

Typically columns that appear only in the select clause of a query and not within the WHERE,...

Hi,
Recources, security etc

Hello all,

Thank you for your quite response.

I didn't know that TABLERESULTS is an option.

I will create a table with the proper column and use the TABLERESULTS option.

Again thanks a lot!!!

Hello all

Thank you very much fir your quick response!