Thank you all for the quick replies.

@sqlguru - Okay. I'd like to view that aggregate data if I can. Mostly I'm curious what the wait type...

For anyone who comes along later, I wanted to let you know that I was able to fix it.

Here's what I had to do.

1) I needed to add the Clustered...

kahmeal (9/28/2015)

---

I just went through this annoying issue and figured I would share my findings as none of the top hits in google, including this thread, were entirely correct.

The error...

I have a similar issue and it is rather odd.

SQL Browser is running (check)

TCP/IP is enabled (check)

Port is statically configured to 1433 (check)

This is SQL 2012 Express that I'm trying...

We don't really rename stuff. In the design phase the objects are named for what they are. This helps with references and joins later as well as knowing what the...

We use SQL Express for replicated databases used on a scaled out server platform. However, there has to be a "main" database in this architecture that has to be run...

Glad to hear you are refreshed.

The longest vacation that I have been blessed to take is 2 weeks. I can scarcely imagine what taking a 6 week break must be...

I'm just glad I could help!

Ah, the curse of the Firewall.

Nice job!

UAC is not likely to be the resolution.

Has this ever worked for you before today? I mean, you said it works from...

Perhaps you don't have partitions?

It looks to me that you can complete page level compression for the whole table by doing this:

ALTER TABLE T1 REBUILD WITH (DATA_COMPRESSION = PAGE)

It's worth...

This is a tough one. It would seem that your management team is looking for a tangible value on something that is intangible!

I would take the approach that your proposed...

Neeraj,

Thank you for the start, this has helped me a great deal.

So that anyone else can benefit, the code block that I am going to use looks like this:

SELECT databases.is_published,...

Interesting editorial.

I recall working someplace where physical security was thought to be an adequate means of hardening our servers to attack. That is, only authorized users could gain entry into...

See? It's the simple things! :pinch:

Compatibility Level was set to 80 (SQL 2000). Changed it...