homebrew01 (9/9/2011)
Ivan, "Archive" is a simple word with many possible complexities.it might help if you could explain your goals. What is the current environment ? What do the users need ? What are you trying to accomplish ? What are the business needs ?
Then someone here might be able to guide you to a solution.
ok, thank you very much.
I inherited these databases so I'm very green but thank you.:-)
I will get back to you. Have a great day.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/