I don't think I have ever seen anything that allows you to determine that..

CEWII

What is your goal, a port change or an IP addr change? Is it clustered or not? Changing the cluster IP address is not terribly hard, you can...

It doesn't matter, have "console" access to the machine running the database server makes things easier. I have yet to have someone give a valid reason to prevent RDP...

That question is not specific enough to answer.

There are several high availability features to consider

1. Mirroring

2. Log Shipping

3. Fail-over clustering

4. Always on (which takes a modified form of #1 and...

It can be queried from WMI I believe.

CEWII

It can't, two reasons, SSIS is not available in Express and maintenance plans are SSIS packages, and there is no SQL Agent in Express. There are some workarounds but...

I have worked in highly secure environments where ONLY RDP access was allowed. RDP access does make it much simpler and the real question is "do you trust the...

Very welcome, have gotten dinged by firewalls more than twice myself..

CEWII

So when you disabled NOTHING changed, BUT you got a difference after you re-enabled the firewall?

CEWII

From the Control Panel, Network and Sharing Center, at the bottom on the left is windows firewall, the simplest to TEST is to turn the firewall off completely, if you...

Keep in mind there is ALWAYS a date in the datetime datatype, you can't get rid of it, you can chose to not display it but it is and always...

Once the definition is set I don't believe you can change it at run-time. So if two columns are reversed for example it will probably break. And if...

You should push back to the business unit, table level security should be the EXCEPTION and rare. In short they can have it but just for a few tables...

Between loops you might add like a second or two delay, I've seen some locking of the file resolve itself this way..

CEWII

I can think of several potential issues:

1. TCP/IP may not be enabled for the SQL instance, this is the default behavior for SQL Express, no need to allow external connections.

2....