Could you explain a bit more what you want? I'm not sure I understand your question.

Is the SQL service running on that machine?

Have a look in the server's error log, see if there's anything in there of interest.

MySQL or MS SQL Server?

The total scores page will answer some of those for you

Have you enabled remote connections?

On the machine you can't connect to, run the surface area config and check that remote connections have been enabled.

When you run the Surface area...

TempDB is completely recreated every time SQL starts. What you're seeing is normal and expected.

If you want permission changes to persist through a restart, you'll have to set them on...

Hmmm....

Has the slow execution reoccured? Is it happening regularly?

As more general comments:

Why are you using dynamic SQL in one place? I can't see anything in there that would need...

There are some values in that column that cannot be converted to numeric. You're going to have to find those values and either remove them or exclude them from the...

Don't shrink your database. It causes massive index fragmentation and the DB will quite likely just grow again, possibly causing file-level fragmentation.

See - shrinking databases[/url]

Why do you want to shrink?

That's a compile time of 16 sec! That's a little extreme.

Do you have contention for your procedure cache? (Are you seeing blocking with a [compile] description)

If you check perfmon, what...

Parameterise all queries in your front end app. Do not concatenated together SQL statements and execute them.

Preferably, use stored procedures for data access only and do not allow the application...

The error message is getting cut off. You'll need the entire message before you can find a the cause

Go into the job step. On the advanced tab there will ba...

Have you looked at database snapshots? It seems to me that creating a snapshot may solve your problem.

They do have an IO load impact though.

That's a...

I already did.

You can rename...