Viewing 15 posts - 301 through 315 (of 449 total)
Yes, that's one method of upgrading to SQL 2005. The other technique is to DETACH sql 2000 db and ATTACH to sql 2005. Keep in mind, you can't go backwards, restore...
October 12, 2006 at 4:56 am
use
distribution
go
select
* from dbo.MSpublications
October 11, 2006 at 8:24 am
Have you tried running the stored procedures for removing replication?
http://support.microsoft.com/kb/324401
this will be cleaner than deleting the entries from the
"dbo.MSpublications" table, since there are other...
October 11, 2006 at 8:03 am
You can rename the server, but not the SQL Server Instance. see KB
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257716
SCROLL TO #29
You may have omitted the sp_dropserver and sp_addserver.
October 11, 2006 at 5:31 am
Use snapshot replication. If they enter data, it will be replaced with the next snapshot.
or/and
change the permissions on the subscriber database to "datareader" only
October 11, 2006 at 5:19 am
What type of replication? For merge replication I could see that you might want the transaction logs backed up in case you need to restore to the point in time. ...
October 3, 2006 at 5:05 am
Most of the conversion will have to manually be done, especially if the Oracle db is using packages. The Microsoft conversion tool converts many of the stored procedures, but with...
September 27, 2006 at 5:19 am
You can also just add the article through management studio. Publication properties -- Articles.
It prompts you that a new snapshot must be generated, but only the change(s) will be applied...
September 26, 2006 at 5:14 am
Similiar to previous post.
The MS ERP database writes the data into a clone of the "SaleOrder" table. This can be done via a trigger. This "SalesOrder" table is then replicated.
July 27, 2006 at 10:40 am
Depends on the type of replication. Merge replication isn't supported from SQL 2000 to SQL 2005
SQL Server Versions Supported
Microsoft SQL Server version 7.0 service pack 4 (SP4) is...
June 28, 2006 at 11:50 am
On the publisher run
SELECT * FROM SYSSERVERS.
One of the rows returned should be the subscriber that you have registered in EnterpriseManager. The srvname should be the exact name...
June 23, 2006 at 5:22 am
Has it ever sent a notification through a job within the 10 minutes you're referring to?
Database mail is a 2 step process if you want it to be used to...
June 23, 2006 at 5:10 am
3)
Transaction Logs should be on their own drive and LUN
Multiple datafiles, should be on their own seperate LUN's.
TempDB should be on it's own LUN, or at least different from the...
June 20, 2006 at 9:40 am
We just have the maintenance plan email the results. It will indicate if there was a failure and from there we read the attached log file.
June 13, 2006 at 7:19 am
Viewing 15 posts - 301 through 315 (of 449 total)