I dont think so. Or at least running rebuildm to change the collation. One area where SQL2K is really nice!

Andy

Thanks for the feedback! Nothing wrong with breaking any rule as long as you know you're doing it and why...more or less anyway! We're looking over the Worst Practices idea...

Could you post the DDL for the table? Usually either a group by, or maybe the cube/rollup options will give you something quick and dirty. If you need something really...

Tried declaring it as a LOCAL cursor?

Andy

Yes, you can do it. Either bcp sysxlogins, use the transfer login task in DTS, or you can actually use sp_addlogin to do it without knowing the passwords. The 'gotcha'...

Distributed meaning use a linked server or openrowset. Do you have the text colummns full text indexed?

Andy

SP_grantdbaccess is the preferred method. If you look at sp_addlogin it just in turn calls sp_grantdbaccess.

Andy

Not in EM. You have to copy the info from/to sysusers and sysprotects. I think I've got a script somewhere to do it, will look.

Andy

Are you using text columns in the affected tables? Local query or distributed?

Andy

Access isn't always very efficient. Whenever possible replace Access queries with SQL stored procedures or views. For importing data, your best bet is to try DTS. Typically imports will go...

Fair point. I think the only issue with repair with prior to current service packs it would at times leave your db in single user mode. I believe SQL7 SP3...

You can profile to capture logins and profile does have the ability to filter as it executes. If the profile is complex it's usually better to simplify it and then...

Please ask questions any time. All we can ask is that you take a shot at figuring things out first!

Don't delete those extra tables. They are "system" tables and hold...

Better to fix the queries that have problems than give up parallelism altogether in my view. That's why we bought the big boxes to start with!

Andy

Why would you do that until you discover you have a problem? Better to tune the offending query than give up multi processor power altogether. Im using one 4 way...