That all depends on what the bacth is doing!

How complex are the batches?

Ok. I gave access to the "Domain Users" group to the "General Users Role" to 1 folder that contains 1 report.

When a user browses to the reportmanager home page, they...

David Burrows,

You are correct, you have to use fully qualified names. I forgot to mention that.

Cheers.

Can you post the code so that we can have a look at least?

You usually get this error when the SQL Server DataType & the .NET DataType do not match and a CONVERT needs to take place from the .NET Application before you...

Sorry, forgot to give you an example to get you started. The code below calls a stored procedure and returns a DataSet. Keep in mind that the example below is...

The best thing to do is get a book on ADO.Net & C#.Net or just search on the Microsoft website for some examples. I have found some good stuff at...

The only thing I know of that I read somewhere, can't remember where, was that sp_executesql

can take advantage of query plans where exec cannot.

Someone correct me if I'm wrong!

...

This will not be what you want to hear but you will have to Reinstall SQL Server and restore Databases.

The Replication Agents are Jobs. You could ensure that this job starts each time the server reboots.

That is correct. When you enable awe, you have to configure the memory on SQL Server as a fixed amount.

If you are using Excahnge Server, then one way is to use CDO to check for the existence of a mail box before you execute xp_sendmail.

CDO stands for Colaborative Data...

Sorry for taking so long to get back to you, I rarely look at the forums on weekends.

Just use the same query only this time select the TIME_STAMP Column as...

John,

I have answered your question in the T-SQL Forum. No need to post the question twice!

This is somewhat a very strange Design you have!

If you want to proceed with this unorthodox method, you will have to get MAX(RoleID) and MAX(MenuID) and incrmemnt it by 1...