Hi Gail,

>> You're connecting to the default instance, not the new one. When you specify a port number, you connect to the SQL instance that's listening on that port. If...

Hi,

>> either you're connecting to the wrong instance or the databases were created in the wrong instance

The name at the top of the treeview in ssms shows DAS\AlphaOne,1xxx. The...

>> If you are having trouble with your mentor stealing your ideas

I have always trusted my people, until they prove otherwise... Sometimes it was too late before we found...

On second thought, the CodeNames can only help moving forward and can do nothing for us on our existing databases, without rewriting a lot of code.

tempBD was mentioned... Does...

Thanks for the CodeNames idea, as that can serve us well and its simple..

Stanley

>> I am curious, though, who's idea is it to lock down the databases? Yours or a boss's?

Well, you can say both, as I am the boss and sys...

Hi Gail,

It would matter greatly if the server was hosting highly sought after data, as 1st, it would reveal/advertise that it is hosting such data which makes it a target...

>> When you say the user shouldn't see the other databases i assume you don't want them to have the databases listed in the tree view on SSMS

Yes, that is...

Hi Lynn,

Disregard my prev message. Looks like its sql server's inability to give accurate feedback in real time. Your process completed with the expected results and once...

Hi Lynn,

I'm running your script now and it now been 30 minutes since it started. I expect it to take 10-14 hours to complete. I've been refreshing the...

Hi Lynn,

I have dropped the image_pdf field as there was not any data in it. I modified your code and am getting this error:

Msg 156, Level 15, State 1,...

Hi Jason,

I was able to resolve the issues without deleting any of the main log files. I still do not have a step by step on how to do...

Hi Scott,

Running your script, it returns:

Which begs the question on why the Page table has 3 PK_Page_Identity indexes, as it should have only one. That's the only thing I...

Hi Jason,

Running your script returns:

The deedroom db should consist of 2 filegroups "primary" and "FG_Images". The script output shows that.

As stated elsewhere in this thread, the deedroom db has...

Gail,

>> Also, I suggest maybe not taking DBA advice from developers without double checking it (Stack overflow is a developer site)

That is what I'm doing here right now. ...