I tend to use ndx_somethingdescriptive, usually col names, or maybe 'nodupes' if specifically to prevent duplicate entries (not on a key, but some other value). Dont really care though!

Andy

Lets try the easy way first! Instead of working directly with replication an easy way to do this is to just run the associated job(s) (logreader and distribution agent). Log...

Dont know if anything bad would happen, but in general why would you? Either set stats to update automatically (usually ok) or run a job to update periodically.

Andy

You might also check the Sybase site, also the newsgroups at groups.google.com (my favorite for research).

Andy

So far I've heard no one voting for any 3rd party backup, regardless of situation. General recommendation is to backup to disk and keep several days worth on disk if...

Forgive the short reply - have a deadline at work that is keeping me busy! If you've identified where it's happening, just override/comment out the code for now - not...

Leading wildcard always sucks! Does the query run ok if you just use a trailing wildcard? I know that doesnt meet your goal, but would confirm/deny we're looking in the...

Anyone know why? Pretty common for a _ to be used to hide a method that you dont normally want called (right click in VB6 object browser to see the...

Could you post your code?

Andy

Problems in what way?

Andy

I have no experience with Sybase - perhaps other readers do? Steve will be back next week, he might have some ideas too. In the interim I'd suggest double checking...

No problem!

Andy

No, the agent runs under a separate account. No need to change the SQL main account.

Andy

It's really two ways of doing the same thing. One way or another to open a connection (a connection object in ADO) you have to have the server name, the...

There is an option to copy sql objects as well. Or you can script them out/in if you're more comfortable with that method.

Andy