You can't save it directly to VB code in SQL7, there is a tool that comes on the CD that will do it, name escapes me at the moment.

Andy

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

Rdijk,

You might want to read (or re-read) the earlier posts.

Andy

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

Replication is probably less work to maintain than DTS.

Andy

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

ADO doesn't. ADO is just another abstraction between you and the SQL engine. It asks for the data, SQL decides if it's authorized or not. Only way it will work...

Not sure if the delimiters are intrinsic or they just built a UI for the common ones. Quickest way to tell is to save it out as VB code, then...

Certainly could be, or something trashing the process on one side or the other. Have your admin check routers/switches involved to see if a high number of errors, collisions, etc,...

I'd suggest looking to see how the change affects AD and how long it takes to replicate to other controllers, what effect it has. Hope you dig out the answer!

Andy

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

I teach our developers to use the temp table initially, helps them visualize and check the results as they go. Once everything works, pretty easy to replace the reference to...

Possibly the login is just a member of the datareader role and nothing else?

Andy

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

32 to 48 is probably minimum, not a bad idea to allocate more if you can. I've had no problems with letting SQL have it all and releasing it as...

Have them reboot. Seems to work, dont know the why of it though.

Andy

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

By two sets I mean two full backups and all log backups done since the earlier backup. One point I left out earlier is that another reason I keep two...

Putting them in the denyreader role doesn't mean they cant connect, just that they can't read from your tables.

Andy

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

I typically try to do a full backup every night to a new disk file, then have that copied to tape shortly afterward. I try to keep two sets on...

You'd run the scripts to create the publications in the appropriate database. Before you could do that you would need a script that enabled replication on the server, created Distribution...