Viewing 15 posts - 3,031 through 3,045 (of 6,216 total)
Good question and Im interested to see what ideas readers have on this as well. Seems like in 10 years the media format may be junk so you'd have be...
October 24, 2002 at 4:36 am
October 24, 2002 at 4:34 am
That's not a bad idea. We'll wait to see what other feedback we get, but that sounds worth doing as well.
Good point - all the follow up replies will originate...
October 24, 2002 at 4:30 am
BOL (Books Online) has a decent explanation and if you use the wizards in EM doing a basic transactional pub is not bad. I do suggest doing it with something...
October 23, 2002 at 4:46 pm
SQL7 or 2k? What security setting did you choose for the linked server?
Andy
October 23, 2002 at 4:44 pm
October 23, 2002 at 4:43 pm
Hard coding isnt always a bad solution - the trick is to make it easy to find, change, and deploy. Im part way through building a solution that addresses all...
October 23, 2002 at 4:42 pm
Two ways I can think of. One is to do an outer join so you can identify and exclude the rows already present. The other is to set the index...
October 23, 2002 at 4:40 pm
October 23, 2002 at 4:37 pm
I've got a couple recent articles about sql logins you might want to look at, give you ideas anyway. Biggest benefit of app roles is that they override any other...
October 23, 2002 at 4:36 am
Any type should work. Depending on bandwidth you may have a hard time getting your snapshot to complete in a decent amount of time and it may affect your latency...
October 23, 2002 at 4:32 am
Why do you want to prevent them from using the mdf? Cant imagine you'd have much proprietary code/info in a marketing db. If they can use the mdf directly that...
October 22, 2002 at 5:11 pm
I think there is also an AD provider you can use with openrowset.
Andy
October 22, 2002 at 3:41 pm
Not fun. How about just dumping the app role and using a sql login? Not much of a change in your code, you can assign the same permissions to it...
October 22, 2002 at 3:39 pm
You dont normally want to create keys on the subscriber - how would you get these back into the publisher without having duplicate keys? Merge handles it by both adding...
October 22, 2002 at 3:37 pm
Viewing 15 posts - 3,031 through 3,045 (of 6,216 total)