Viewing 15 posts - 331 through 345 (of 576 total)
You need to,
(A) Use sp_repladdcolumn to add columns to a Table that is marked for replication.
(B) configure the snapshot properties to either drop the table or truncate it etc etc....
October 14, 2004 at 5:02 pm
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
Viewing 15 posts - 331 through 345 (of 576 total)