Viewing 15 posts - 331 through 345 (of 1,166 total)
You removed the subscriptions and publication but db is still enable for replication...
Run the script Corlos suggested or you can use EM to disable replication...
February 8, 2007 at 6:03 pm
Upgrade from 32bit 64 bit is not a problem... you can do backup restore or detach attach...
I have not seen any problem but it always better testing specially applications.....
test..test..test... move...
February 8, 2007 at 6:00 pm
February 8, 2007 at 5:54 pm
I will not worry who controls the backup ... I will be more interested how eficient and reliable they are....
I believ most of these backup solutions are pretty good for...
February 8, 2007 at 5:06 pm
You can't accomplish with one MP configured for all...
You have to create diffent MPs one for each process (backup, checkdb, reindex...)...
OR
You can create a job using tsql without using MP...
I...
February 8, 2007 at 4:55 pm
I don't have the URL handy but you can go to microsoft.com and register for updates...
February 8, 2007 at 4:52 pm
The following articles will help you to do what you want...
http://www.devx.com/dbzone/Article/31648
http://www.databasejournal.com/features/mssql/article.php/3611426
February 8, 2007 at 4:50 pm
Yes and table should not have LOB columns (text, ntext, image...)...
February 8, 2007 at 4:45 pm
What edition of sql server 2005 you are trying to connect?
By default remote connections are disabled in Express/developer editions...
Open Surface Area Configuration and check for remote connections option is enabled...
February 7, 2007 at 11:49 pm
Again some one else in the db...
When you rename the database, sql will try to get the exclusive on the db so that it can rename it..
You can use my...
February 7, 2007 at 11:35 pm
For some reason they removed...no idea why... you may try exporting into excel and convert excel into dbase/faxpro...
Just google for "excel to dbase convertion"
February 7, 2007 at 11:29 pm
You suppose to add it in merge agent job not in profile... if I am not mistaken...
Did you change the configuration in merge agent job?
February 7, 2007 at 5:41 pm
Try after disabling the publication property on the "subscription options".. Under Schema replication...Replication schema chanes.. make this option to FALSE and then create the trigger...by default this property is TRUE...
February 7, 2007 at 5:30 pm
I don't think that is the case...
Try creating the linked server before configuring replication..
February 7, 2007 at 5:04 pm
You can rollover the files when it reaches certain size then read all files except the one in use...
If you make rollover size is smaller ...
Note: You configure the profiler...
February 7, 2007 at 4:48 pm
Viewing 15 posts - 331 through 345 (of 1,166 total)