Viewing 15 posts - 2,836 through 2,850 (of 2,900 total)
Thanks for all the great replies. Our "WhatsUp" product does monitor free space, so I've asked my network admin to set it up a few specific instances. I'm going to...
August 5, 2005 at 10:13 am
The reason I ask is that I was copying data from a bunch of tables in one DB to another DB. Some of the tables had relationships to each other, so...
August 5, 2005 at 8:58 am
Well that looks pretty simple in comparison, but is it only for Merge Replication ? BOL says: "Changes some merge filter properties. The merge filter properties that can be changed...
August 3, 2005 at 2:51 pm
I think that if you change the filter through Enterprise Manager, then it will flag your publication to genereate a new snapshot, and you'll lose your original data at the...
August 2, 2005 at 1:01 pm
You could put XP_SENDMAIL after your query and send yourself an email ...
July 27, 2005 at 10:30 am
And if you modify it slightly, adding a qty field, then you'll get a count of how many duplicate records there are for each group.
select
fld1,
fld2,
fld3, count(*)...
July 27, 2005 at 10:28 am
At the subscriber, you should just be able to right click & delete the subscription
July 27, 2005 at 8:18 am
We have "WhatsUp" ...... I should be able to get our network guy to implement that for me.
July 26, 2005 at 3:21 pm
We verified with our software vendors that they didn't have any issues, and have installed it on 2 servers so far. No problems to report .... very easy.
July 26, 2005 at 12:33 pm
We just bought Idera's Diagnostic Manager. I like it for it's ability to send alerts for all manner of server thresholds. It also logs quite a few performance statistics and...
July 26, 2005 at 12:30 pm
If you go the the EM server Properties, there's an Active Directory tab, where you can:
"Add this instance of SQL Server to Active Directory"
I'm not sure if this will...
July 25, 2005 at 12:29 pm
There are some 3rd party tools that can do it. We use Lumigent Log Explorer, but there are others too.
July 25, 2005 at 11:46 am
Does User1 have read permissions for the database ?
July 25, 2005 at 11:40 am
I do the same as Ford Fairlane mentions ..... works great.
You can either temporarily disable your transaction log backup (and remember to enable it later) or just let the tranaction...
July 25, 2005 at 11:04 am
You were right on the money .... Thanks !
I'm still puzzled by the error, but I guess I won't worry about that until I really need to.
July 22, 2005 at 2:26 pm
Viewing 15 posts - 2,836 through 2,850 (of 2,900 total)