Can you run this in VBSCript from a command prompt and have it work? Or maybe using a scheduled task and the account that IIS is using? I would almost...

You'd have to provide more information about the code here if you want help.

There are performance problems with functions at times, so you want to minimize them in large data...

My guess that some of the items Enterprise Manager users are locked to your account. I assume this application is published, correct?

Do any of the EM items work?

Moved to 2005 forums.

The only way I've seen to synchronize these is manually. You need to script them out and move them as they change.

I think that query is a little broken at times. Not sure why, and it's a low priority. Sorry.

Please check the forum before posting. Moving to t-SQL

Sorry, slip of the finger. They are supposed to be hidden until that date, but I checked the wrong box. I'll clean it up.

Well, I'm one of the people running the public speaking merit badge for the local Boy Scouts, so hopefully I've learned a few things I can pass on.

I think part...

MCA - Technical

MVP - community

the MVP can include technical work, but there are people that just support the Microsoft community in some area, like me, that don't necessarily do...

Not to mention she might trip you or toss you off the track if you get too close!:w00t:

Here, here, be polite.

Ignorance != lack of intelligence.

I voted MVP, because I think it has more recognition, and it's more likely you can attain it. Both require hard work, but...

Working my way though college (and later) as a bartender/waiter, got to try lots of things I might not otherwise have done so.

Now I like to relax with a nice...

IF you are using something like a maintenance plan, and that's a good idea as you get started, be sure you enable logging. When something fails, check the log file,...

The order of the SELECTs shouldn't matter, AFAIK. The query optimizer is supposed to know what is where in a partitioned view and not query those sets that don't apply.

Not...

Couple things, is the type of job an OS job?

Also, you might need to give the entire path to cscript to get it to run. I'd run a dir *.*...