Viewing 15 posts - 376 through 390 (of 1,098 total)
You can run:
exec sp_helpreplicationdboption [DBname]
the value 1, mean yes.
December 4, 2003 at 10:02 am
Check that the account that runs the SQL agent service has access to that file.
December 4, 2003 at 9:48 am
Check http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql
there you will find an sp that will script the creation of the logins with the same id and password.
but the result will be T-SQL code, wich you won't...
December 4, 2003 at 9:22 am
Did you check if the agent process was locked by any other process when it seems to hang?
December 3, 2003 at 2:05 pm
Can you ping the server nyc-sql-bkp from the sql server?
Is the share available?
Does the sql Agent account has permissions to access that share?
December 3, 2003 at 1:14 pm
You won0t be able to add a table to the publication so easily.
First you will need to drop all subscription, then recreate the publication with the new table and...
December 3, 2003 at 11:44 am
Try:
SELECT SERVERPROPERTY('LicenseType')
December 3, 2003 at 11:07 am
If you mean "Hot Backups" then, with SQL server it is possible to backups running databases, without stoping the server.
Users won't notice that you are backing up the Db, except...
December 3, 2003 at 11:01 am
Those are tables created but the sp sp_link_publication and also sp_MScreate_sub_tables.
It means that the size of columns is bigger then permited.
The tables still were created, so you shoudn't have any...
December 3, 2003 at 10:56 am
It will depend on the tipe of publication.
What kind of Publication do you created?
To find the answer, you can run profiler to trace what sql is doing ...
December 2, 2003 at 2:22 pm
Como me pediste por mail te mande la explicacion, pero me reboto porque tenes la casilla llena.
Avisame cuando te pueda mandar el mail ya que es largo.
Saludos.
December 2, 2003 at 2:16 pm
Also you can manage versions with Stored procedure, but it is not so confortable.
December 2, 2003 at 6:10 am
When creating the publication with the wizards, in the first screen select to see advanced options. (The litle check below).
Then you will be asked if you want to transfor the...
December 2, 2003 at 6:02 am
For some big tables it would be faster to get that number from the row column of the sysindexes table.
December 1, 2003 at 2:36 pm
Wich SQLNet Alias do you have installed in the clients and in the server?
Check:
http://support.microsoft.com/default.aspx?scid=kb;en-us;277002&Product=sql
December 1, 2003 at 2:33 pm
Viewing 15 posts - 376 through 390 (of 1,098 total)