It's print too. Freebie if you're certified.

Andy

I think you can just update the name column in sysxlogins in master. Haven't tried. Not sure if you'd have to change anything in the user db or not. Use...

Maybe someone else will have better ideas. Two comments to add though. First, I've used a treeview control on a couple projects recently and it is fairly fast. I did...

http://www.mcpmag.com, down near the bottom. 44,506 when I looked this morning.

Andy

We have a script library posted here on the site. Have you tried writing the script yet? Post what you have so far!

Andy

So you'd load everything initially, then after that only load the ones they selected? Depending on the volume XML isn't the worst idea. Shaped recordsets work pretty well, I find...

If you code post some code we can probably give you a better answer. DTS supports Excel, so you could just import the file into a table and then do...

Is it possible that the login is misaligned? Have you run sp_change_users_login to see if there are orphaned SQL logins? Or are you using NT login? Have you run sp_changedbowner...

No ideas so far. This from BOL:

SQL2K:

ALTER DATABASE permissions default to members of the sysadmin and dbcreator fixed server roles, and to members of the db_owner fixed database roles. These...

Could you post the alter? Maybe a difference in the compatibility mode?

Andy

You sure that the login you're using is in the dbowner role?

Andy

Hey Mark,

Before we tackle how, could you expound on why? Just curious!

Andy

Every little bit happens to distinguish you from the next candidate. If you're a SQL Pro managing the two SQL exams isn't that bad. Even if you never fulfill all...

Thats an interesting bit of info Robert. Will have to do some more testing of my own. I'd use caution doing it though. Not because undocumented - who cares! But...

If you're using SQL logins you will need to add them to the new server and then run sp_change_users_login in the new db to sync the login entries (articles here...