Thanks for your reply. I will post it shortly

Thanks you for the query. Actually since I posted this I realized that these partition schemes and partition functions where created by Database Tuning Advisor, so, and there are not...

Thanks for the link. If I had a choice I would rather use log shipping but, because of the triggers and the fact that I'm trying to log ship from...

thanks to all of you for this confirmation. Your answers was what I was expecting.

Thanks for all of your hard work

Well kinda. This table has 75 columns in it and I have to show two values for one column: 1) count where the column is not null, 2) where the...

Thanks. Yes I have some sql that will tell me the last time a stored procedure was executed. That's a good practice to have only allow views in a stored...

I have checked the connection pools on web.config or whether the application is leaving open connections but this is something that we have not explored and will definately do so!...

Nothing pretaining to deadlocks or any other errors. I think the application is timing out the customer before sql takes a deadlock because I have a flag turned on to...

Thanks, I will try and used the computed column method.

The only reason why I would consider shrinking the db is to get it small enough to move to our test db server, but, that's not going to help is...

Thanks, what I mean is that normally when I move a database from one server to another I script out the logins. then I run the script after restoring the...

Thanks. I've used SSIS but not in that way. I will take a look out on the web.

thanks a million!

thanks for the info. I will check into these items that you brought forth. We are still running sql server 2005 same as the old environment.