As much as I'd like to offer my own opinion on Ronald Reagan, I agree with the international community on this one.  There are plenty of political forums on the...

Why do you want to know?  What are you trying to solve / accomplish?  Identity values will be generated differently depending on the type of the identity column, e.g. a...

Nope, didn't have to register the DLL, copying it over did the trick.  I don't even know if it needs to be registered, actually.

Yup, just copied it over from another server and everything started up again ok.  I'm baffled.

Identity values are useful for uniquely identifying rows in a table, not really suited for tracking arbitrary incremental values, as it appears you are trying to do.  If you're looking...

Thanks for the replies, guys.  As for Jack's question on why use Citrix at all, we have network appliances deployed in the production environment that require serial port mapping.  Citrix has...

What error are you getting exactly?  Check the job history and click the View Details checkbox.

7gfhrwwwwrrrrrrrr...

You can synch database structures using SQL Compare: http://www.red-gate.com 

Well worth the $$$ & a real time saver.

If you need to do this automatically somehow, you may want to look...

Can you not run a SQL profiler trace with appropriate options to capture this information?

So do you need an up-to-date copy once or on an ongoing basis?  If you've got some downtime, you could take your local warm standby, restore with recovery to make...

I know what you're saying, though.  It would be nice to just grab hold of the standby database right there, so my above suggestion assumes that there is no easy way...

OK... maybe I didn't read your question closely enough...

But, and I ask this out of partial ignorance, why not set up another warm standby server, log ship to it as...

I've had a log shipping / warm standby setup operating successfully for a couple of years (apart from some minor network hiccups and a recent cranial vapour lock on my...

For anyone who cares, I solved my problem, here's the skinny: before I figured out the mode & status columns in sysdatabases I zapped the problem database and recreated it. ...