It's scriptable from DMO. Under the table object there is a collection of userdefineddatatype objects, you can iterate through those and call the script method of each individual object.

You can...

I dont think its your MMC version. Which line causes it to break? Nothing wrong with your code, I'd guess something junked up in the dmo libraries. One fix might...

Sorry, Im just catching up on posts from last week. Think you had one or two other questions posted I'm just about to look at.

Andy

http://www.sqlservercentral.com/columnists/awarren/

20 minutes to figure that one out! Snitz, gotta love it. You have to insert rows into the subscripion table. Why would it be an attribute of the category or...

You would have to pass the primarykey as well, right?

You could create one massive lookup table that consisted of tablename, column, primarykey, value. Create triggers on all tables to maintain...

Looks like you could use a cursor to break it up, then either loop through the rows to do the replace. First thought was a cross join if you trully...

Yes, recursion can be done. Doesn't mean it always a good idea! Before we dive into this, is there a reason not to put it all one table? The standard...

Access discussion area created:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15816&FORUM_ID=131&CAT_ID=11&Topic_Title=New+Discussion+Forum&Forum_Title=Microsoft+Access

Andy

http://www.sqlservercentral.com/columnists/awarren/

Not sure I understand, so bear with me if this doesnt answer it entirely. The location of the logs doesnt matter, as long as you have a full backup and...

The book is (and has been) at the printer, as of last Friday they were due to ship to me this coming Friday. They've had some equipment problems that set...

There is an option at the db level I think that configures the text limit, that might be it. The 16 bytes is a pointer to the real data.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Depends on whether you need to have the subscriber offline and whether you wil be updating the subscriber. In general I recommend transactional until you find that you need something...

There is a proc that will create the replication procs for you - I apologize for not having the name handy. If no posts it I will look for it...

I'll check on it tonight, I think something went wrong in the loading process. Bear with me!

Just guessing, I think scaling wouldnt be bad as long as the docs werent...

I keep meaning to try the product, keep getting sidetracked. Lockwood advertises with us, so all things being equal, give them bonus points for that!

Reporting is hard. You can use...