Dont think so either. BII is installed under SQL\Tools\Dev Tools\Utils\Bii. Only idea I had was maybe you could UUencode or something along those lines?

Andy

Really...thats what I get for not double checking.

Andy

I'll give it a shot later tonight.

Andy

Possibly the packag is corrupt. Have you tried doing Save as, then opening the new copy?

Andy

Well that explains a few things. Actually "I" am Steve Jones, I just like to argue between my two split personalties.

Andy

So Steve Jones isn't really your name? Reveal your secret identity!

Andy

Gotta say thats ugly. Who wants to open 200 packages? Maybe a small app or proc that will do this for you. Other options, can you bcp the data, or...

Be interesting to dig a little deeper, prove or disprove the theory! Of course another part of it is that the query planner wont use the index if you're searching...

I use aliases for table names a lot too - even if shown a performance hit it would have to be pretty bad to get me to change!

Andy

Just look at step 2 of the distribution agent and add -continuous. Run the job and it will continue running until shutdown.

If you do a standard snapshot it is at...

Probably easier to make a table that contains login name and password along with a date stamp, then run an update once a day that joins on name/password to identify...

So far there is not, best you can do is use a naming convention, from within EM or ISQW anyway. Might be 3rd party tools that would do it, have...

I think it defaults to starting the distribution agent. If it's got the -continuous flag set it will continue to run, if not will run again later based on whatever...

Can you ping the server name? IP address? Sounds like a connectivity issue. I've even seen times where SQL would not accept connections - look for errors relating to listening...

Almost. You're treating the login as if it were a new one, to get it work you need to reference the one that already exists, like this:

Set oLogin = oServer.Logins("SA")

Then...