Viewing 15 posts - 76 through 90 (of 1,097 total)
yes of course.
Even if I set up the same Windows account that I use to start SQL Server, it will still give me the same error.
I'm not sure that the...
August 13, 2004 at 12:22 pm
right, but still the same error.
August 13, 2004 at 12:15 pm
This is SQLDMO.
The SQLVerify method is part of the SQLDMO.Restore object.
Antares, I don't agree when saying that the verify doesn't return anything.
Even from QA, running a RESTORE VERIFYONLY with return...
August 13, 2004 at 7:40 am
Dependes of how the inserts where made.
If you executed three diferents inserts,
INSERT INTO ...
GO
INSERT INTO ...
GO
INSERT INTO ...
Then, they are three diferents transactions and should apply t he two...
August 10, 2004 at 8:24 am
In merge replication you can specify the -ExchangeType parameters to specify the direction of the replication.
A value of 1 is from the subscriber to the publisher, 2 from the publisher...
August 9, 2004 at 9:27 am
you won't be able to empty the primary file. (mdf extension)
Run sp_helpfile in the desire db to check wich is the primary file
August 9, 2004 at 9:22 am
You should read more about history, and I mean "Both sides of the story".
August 3, 2004 at 9:05 am
If you are using snapshot replication (there are 3 types: Snapshot, Transactional and Merge), then each time you sincro the subscribers then a new snapshot will be aplied.
If you are...
August 3, 2004 at 7:22 am
This is a US member's reply:
"... You people need to just accept that Ronald Reagon was a great man and a great President. He did so much for this country...
August 3, 2004 at 7:16 am
Not free but you could try a demo from Log explorer from Lumigent.
Beside, you could use profiler or trace sp, to actually check what is executing in your server,...
July 26, 2004 at 12:28 pm
To remove an Article(Table) from a publication you can't have subscriptions to that article.
First you need to remove all the subscriptions with sp_dropsubscription @Article = 'The table name'.
Once the article...
July 22, 2004 at 6:50 am
Yes, for me replication would do the work.
You could try merge replication wich can do anything you need.
July 22, 2004 at 6:46 am
You can try scm.exe. Check in BOL for parameters. You also have a Restart action and remote access.
July 22, 2004 at 6:43 am
Hi:
I have investigated a bit and I found the SQLNS_CmdID_WIZARD_CREATETRACE command in the SQLNS object.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlns/ns_ref_06y9.asp
Manage to open and show almost every EM wizard, but still coudn't manage to...
July 21, 2004 at 9:45 am
Viewing 15 posts - 76 through 90 (of 1,097 total)