I'd say that your SQL Server account does not have permissions to start services.  Under what account are you running the MSSQLSERVER (or similar) service?

It's probably best if you explain what you want the queries to do.  From what I can see,

Query 1 returns, for each age, the number of children with that age

Query...

I did say it wasn't a smart thing to do but was possible   If it is done then it should be very...

I'm not sure, although there's a tool (might be from RedGate) that lets you compare databases.  This tool can do a comparison from a DB that isn't even attached to...

I'm not 100% familiar with DTS but I believe that if you run using dtsrun then your package will execute using your permissions.  When run from SQLAGENT it will use...

Can PowerBuilder access ActiveX/COM objects? (I think it can)  If so, try using ADO for your export.

I share the same opinion as many of the others who have already commented - this is an excellent site, you've chosen a responsible new owner and we're all very...

Couple of things.

1. Could you post all of your code so we can see where the BEGIN TRANSACTION, etc statements are?

2. What if you have just a single row in...

Look at the front page of this very website today (http://www.sqlservercentral.com).  There's an article called "Making SA Work" which describes EXACTLY what you want

The long, ugly and wrong way would be to use the SP_OAxxx procedures in a SQL stored proc to start MS Excel on your SERVER, somehow get that Excel to...

I'm not 100% on replication but I believe you can script it from Enterprise Manager...  Failing that, look in Google for

"Sql Server" script replication

I quickly found in the first...

See http://msdn2.microsoft.com/en-us/library/ms174385.aspx

Some potential problems you might be having...

1. Is the DB read only?

2. Did you have multiple files in the DB (ie more than just an mdf + log pair)?

3....

Perhaps winzip is displaying a hidden window?

I'm not familiar with winzip's command line abilities (it may well be suitable) but you could go for a dedicated command-line archiving app such...

I haven't got as much experience with 2005, but with 2000 (although this is naughty you still can do it) you can script out the stored procs in your master...

Kathi's probably right.  Note that you don't need to create foreign key constraints on tables to join them together.  Your reporting tool may make use of existing ref integrity constraints...