Thanks much!

soo... what I'm seeing as the Index Name is what has to be unique in the Database?

Thanks much!!

Thank you!!!

awesome! Thank you so much for your help!

Well, It turns out that the growth spurt in the transaction log filesize seems to have happened after 'Reorganize Data and Index Pages' ran in a maintenance plan....

Thanks for the article. Hope it will help!

Also, I changed the account that starts my SQL Server and SQL Agent Services to a Domain account in the new...

I know the job runs when I set the user to be a a SQL account and with an account from the old Domain. So.... I...

On almost all of my SQL Instances, I start my Services with a Domain Account that has local admin priviledges on the Server. This way I can take advantage...

More information.. LOL Sorry about that .. this post has gotten out of Hand!!!

When they migrated the Server, all the Users with NT authenticated logins in 'old' domain...

Please excuse my ignorance.. but I'm not sure what you mean by checking the 'path'? and I don't see anywhere that I can 'copy' a user.

In our environment,...

I hope some will respond as well. I'm sure someone else has been through this.

Also, I have used exec sp_change_users_login with the 'auto_fix' option to fix my NT...

Since no one has replied, I wanted to take this opportunity to do a little clarifying..

The job I spoke of earlier that won't run.. runs if I...

Thanks for the reply!! The reason I use Backup and restore is because a lot of the time I am refreshing from production (7.0 instance) to a pre-production...

I have had good results using the instructions in this article for transferring logins between Servers.

http://support.microsoft.com/default.aspx?kbid=246133