No, from within SQL Server Management Studio, when you try to connect so you see "SQL Server compact Edition?"

CEWII

Good catch Ian, I agree.

CEWII

you might try hostname in msdb.dbo.sysprocesses..

Or a little snippet from something I wrote:

SELECT @net_transport = net_transport,

...

I would ask the client for them. Seeing how they are ANCIENT versions it is not something they should expect you to just have lying around.. Since they...

Do you have the compact database option from the SS 2005 tools?

CEWII

Also as a side note, it really isn't that bad of a design.. It actually may make things easier, a common table that has stuff that both have and...

Insert trigger on each of the sub tables. Should have minimal performance impact because they only get fired on the initial insert. If a record already exists in...

You'll have to reinstall SQL.. Save a copy of everything in your data directory and you might be able to overlay the old databases. But you need to...

Is that user in the public role? If I remember correctly DENY is evaluated before GRANT. I would probably leave public alone.

CEWII

You are welcome.

CEWII

Then let me put it to you this way. It is behaving they way it is supposed to, the job will succeed in this case and only in the...

In the case of an active-active you have 4 SQL servers, (usually) 1 active on each host. they are entirely seperate SQL servers, you should only go through that...

There are lots of ways to accomplish things, but usually only a few good ways. Using it in code is a bad practice but not having it would be...

The job is a success is what should happen. If you want it to fail then change it to On Error: exit reporting failure or something along those lines....

Ah, this makes sense, as far as it is concerned your job succeeded.. I'm willing to bet (money no less), that step 3 is configured "On Error: to go...