Viewing 15 posts - 766 through 780 (of 1,098 total)
To avoind stoping and then restarting the log reader to keep sincronization, sql has the option 'sync with backup' , that you can specify it with the sp sp_replicationdboption.
This option...
March 28, 2003 at 6:54 am
strange...run DBCC CheckTable on that table and tell us if it shows any errors.
March 27, 2003 at 2:32 pm
also if you have replication set on the server, remember to backup the published db, before applying the Service pack 3 for SQL2000.
And read carefully the read me file of...
March 27, 2003 at 10:19 am
I would try increasing it, not reducing it.
March 27, 2003 at 10:15 am
If you used the select of a text field in the trigger, then the lenght of the text values should be not too big.
Execute SELECT @@TEXTSIZE to know the lenght...
March 27, 2003 at 9:34 am
What you should to use the left outer join is on the "on" part use the pkeys
and the use where b.col1 is null, like this:
select distinct col2, count(*)
from table1 a...
March 27, 2003 at 9:25 am
You can't erase only one backup set from the backup device. You can overwrite all the backup sets with a new backup or append all the backups to the existing.
What...
March 27, 2003 at 9:20 am
Yes!!, backup all the system database on schedulle and after making changes to them. If you also have replication, you should backup the distribution db frecuently too.
March 27, 2003 at 8:24 am
what type of authentication are you using to connect with the distribution agent?
You can check that in the job of the distribution agent, in the second step, check the -DistributorSecurityMode...
March 27, 2003 at 8:11 am
What agent are you talking about, distribution agent, snapshot agent, SQL Server Agent?.
And when does this error shows up? Do you already have the publication created?
March 27, 2003 at 5:39 am
You are right guys, my apologize for the mistake and the confusion.
Siempre es bueno reconocer los errores.
March 26, 2003 at 1:38 pm
If you are going to use only one db for all app, how many concurrent connections do you espect?
March 26, 2003 at 1:31 pm
Check here :
Because some one just asked a very similar question and was answered right.
March 26, 2003 at 1:27 pm
Do you know if there is any chance that anyone changed the DLL on the client, or the DTS package on the Server?
March 26, 2003 at 10:07 am
Viewing 15 posts - 766 through 780 (of 1,098 total)