Yeah, I logged on to the server and ran the exact command that was created in the script because I was afraid maybe some kind of OS change might have...

No, I know how to script the jobs using Management Studio. I am trying to figure out a way to setup a nightly job that creates scripts of all...

Thanks but those are just reports of the jobs on the server and they don't work in 2008 anyway.

I'm trying to come up with a way to script out all...

Thanks, I'll look into that. I also had another idea of executing on procedure and using the EXECUTE AS function to change the context.

Either of these should work.

Yes, the max server memory is set at 7168. This has been confirmed both graphically and using sp_configure.

Yes, I agree, that is the way the query should be done but it is out of my hands at this point. They want the redundant data.

We're actually going...

I did what you said and everything worked like a charm!

I was able to add the server as a Linked Server and now I can query directly against the server.

At...

Thank you. I'll do what you said. It's development, so even if I mess something up, we can always get back to where we were.

My knowledge of replication...

Actually, "no value" does not mean 0.00 and NULL definitely does not mean 0.00.  NULL means unknown or no value.

I have worked with, and continue to work with, several databases with tables...

Thanks for the link.  That cleared it up.

Sorry, this is a little off the main topic here but, I have been away for a while so I'm behind.  What sale are you referring to?

My initial data is in a staging table and I am  having to write the data to a new table.

I have to truncate the new table every time and reload...

Oops, my bad.  I was trying to setup a sample of what I am doing because the actual tables and data has many fields and combinations.  I was trying to...

Thanks for the response.  I too am a programmer at heart so the procedural approach is the easiest but, and I forgot to mention this, the problem there is that...

If you want to get the accounts that are in those groups, you can use the xp_logininfo command.  Use it in the following manner:

EXEC master..xp_logininfo 'DOMAIN\Group', @option = 'members'

Good luck!