Also, I've been working on disaster recovery and am looking at repopulating a different machine from my backups. I do not want to restore to the master database since...

Are you using sp_help_revlogin? That will script out all the logins for you and transfer the correct sid to the new machine.

http://support.microsoft.com/kb/246133/

Also, the whole subject of "How to move...

Are you regularly getting orphaned users? The main reason I know of for this happening is restoring a database from a different server. I'm not so sure I'd...

If I remember correctly, Clipper was originally straight dBase III files (dbf) with their own souped up indexes (idx? instead of ndx). There may have been a version of...

I too had a problem reading the posted script in the original article because I could not see the Vertical Scroll Bar and the right edge of the Horizontal Scroll...

Steve,

First, the newsletters are my window into SqlServerCentral. I always read the editorial, read the question of the day (I don't try to answer it) and the answer from...

Jeeva,

I noticed that you put a second message of "Please answer" for this message. Since you are fairly new to SSC, keep in mind that this is not...

By saying you are checking for mdb files, I assume that you are checking to see if it is a Microsoft Access database file. How do you know what...

When I upgraded from 7 to 2000, I detached the 7 database, copied it to the 2000 machine and re-attached it.  With the replication, it might not let you detach...

Loner,

I can tell from this post and others that you have had a lot of hurts and issues from your past.  This is hampering your ability to function fully in...

Check to see who the owner of the databases in question are.  If the owner is the BUILTIN\Adminstrator group, the ownership of the database may need to be transferred to...

Just curious, what practical application did you need this for.  The question sounded more like something you would use in an academic situation and therefore my suspicion that it was...

Must have been a homework assignment!

Steve

There used to be a limitation of memory of 2GB for standard edition, but that is no longer the case for 2005 as the chart indicates.

Steve

The more I think about it, all it takes is dropping a field that comes before the ordinal number used.  Then all the numbers after that field are shifted by...