Take a look at:

SELECT j.name,

js.step_id,

js.step_name,

js.command

FROM msdb.dbo.sysjobs...

It depends.. Sorry..

But I am uncomfortable with this as well, even copying one of these tables probably won't really solve the problem. Remote queries are complex to run (for...

Map it twice, but it is mapped ordinally..

CEWII

I agree with Jason. And you are right, 512K isn't much..

CEWII

How much data? How often?

CEWII

I haven't done that but what does your select statement look like in the WMI reader?

CEWII

Not to "plug" a certain provider but ClickATell (www.clickatell.com) offers an SMTP to SMS bridge which I have actually used successfully. It aint free but it works well.. ...

These servers are not local to each other? Also how do you not guarantee that they don't loop back to each other until there are issues? Also, does...

I am definitely going to defer to Gift Peddie on this, I have not dealt specifically with Chinese or Cyrillic alphabets. But it sounds good to me..

CEWII

Still true..

CEWII

This was compiled with VB 2008 Express. It is EXTREMELY rough but will enumerate connections (as well as a lot of other things)..

Hope this helps.

CEWII

Define the properties you might like to see..

CEWII

I just put my headphones on and act like they don't exist..

CEWII

Yes. That is the short answer.

CEWII

I'm sure there are more but be sure to define any character fields that will give display text to the front-end are defined as nchar or nvarchar and not char...