I checked and the port for both test and prod in the configuration manager are using the default port 1433 in the properties for TCP/IP. These are the only...

Thanks for the reply, I did not take your comments as a Blast at all. I need all the help I can get! 😀

Mea Culpa, my bad for not doing more research! I ran this new code with the "alter user" but nothing was returned. I'm guessing I had already resolved...

I was following documentation from the web. Yes, I first created the logins and I should have just let it run but it was late and I was anxious....

THANK YOU! I followed opc's suggestion and reduced the database to 31G!

THANK YOU!! I was just now able to make the change you suggested and it now works like before!!!

Thanks for the reply. I guess I was wondering if there was a way to "alias" the named instance to avoid making programming changes to the migrated code? ...

After posting I found the fix in another Forum titled SYSTEM STORED PROCEDURE QUESTION. Many Thanks to Jason! My server also had the sp_configure 'allow updates' incorrectly set...

I am having the same issue as Bryan with this original post. Can anyone explain?

I just realized that any procedure I create is being stored in the...

Also must be SP2 or higher. That is when OBJECT_SCHEMA_NAME was introduced.

Thanks Steve, The reason is I forgot that the default is full when the database is created. We had a small crisis when the log disk got full over...

I am a definite newbie!

If a database is currently set to FULL recovery and no backup log is being performed but I wish to switch to SIMPLE, should...

Well, turns out I did still have an issue. We have Logins like Corp/Jsmith. If I run the latest procedure and enter Corp/Jsmith I get an error. ...

Sorry, I said I was new. Didn't see the additional pages with the latest version. Thanks. I have no errors.

I am a newbie as well! I had over 256 tables too so I tried this last modified version and I am getting the following errors?

Msg 207, Level 16,...