Viewing 15 posts - 331 through 345 (of 575 total)
That all depends on what the bacth is doing!
How complex are the batches?
October 14, 2004 at 4:56 pm
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...
October 13, 2004 at 11:20 pm
David Burrows,
You are correct, you have to use fully qualified names. I forgot to mention that.
Cheers.
October 13, 2004 at 6:00 pm
Can you post the code so that we can have a look at least?
October 13, 2004 at 5:54 pm
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...
October 13, 2004 at 5:48 pm
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...
October 12, 2004 at 7:36 pm
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...
October 12, 2004 at 7:32 pm
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!
...
October 12, 2004 at 5:52 pm
This will not be what you want to hear but you will have to Reinstall SQL Server and restore Databases.
October 12, 2004 at 5:44 pm
The Replication Agents are Jobs. You could ensure that this job starts each time the server reboots.
October 11, 2004 at 5:49 pm
That is correct. When you enable awe, you have to configure the memory on SQL Server as a fixed amount.
October 11, 2004 at 5:37 pm
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...
October 11, 2004 at 5:32 pm
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...
October 10, 2004 at 6:13 pm
John,
I have answered your question in the T-SQL Forum. No need to post the question twice!
October 7, 2004 at 9:29 pm
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...
October 7, 2004 at 9:27 pm
Viewing 15 posts - 331 through 345 (of 575 total)