Totally agree, our sites are identical... as much as they can be.  I am at a loss why the production site didn't go as smoothly.  At least with production I...

Yes, I opened the error log last night and I didn't see anything obvious... we are migrating off this server in 3-4 months, so I am not sure if I...

So, its been installing on my production server now for over an hour and its just sitting at this one place saying updating MSSQLSERVER: DowntimeTimingConfigAction ...

I can't believe...

I do a lot of DB redesigns, reverse engineering and process reengineering.  I'm amazed at how many databases in enterprise level environments are created by someone who just woke up...

Ok, I got the Fix to work and wow I had over 70 missing/mismatched files.  Once I got that fixed, the patch installed.

Course now it won't install on...

UGH!!!!  After all this and all the time it took - the darned installation failed..... GRRRR!

Ok, nevermind... I think I fixed my own issue.  I went to our production server and found another version of the file and gave it that file and that seemed...

Wow!  Holy old post batman.... I did that 8 years ago...so I honestly can't tell you what we did.  🙁  I really don't remember.  I hope there are better solutions...

Thank you, wow!  I thought I was pretty good at SQL... guess not. 😉

So I can learn, what is the tally table doing exactly?

Groovy, thank you for clarifying!

Right ok - exactly what I thought. How do I know what port my connection is going out on? Does it matter?

My network admins are trying to...

Thank you!!!  Yup, its encrypted.... awesomesauce!

No, they are official certificates from our .mil people.

How do I verify if a connection is encrypted on sql server?