Having orphaned users is not a good thing, but luckily is not that big a deal; unless you are the user trying to access the application or database 😀

SQL has...

Can you post the script you are using to perform the restore?

The database should be fine. If you execute

RESTORE DATABASE [DATABASE_NAME] WITH RECOVERY

It will make the database come back online. As to why it is doing this to...

You have to use "With Recovery" to bring the db back online. Make sure you are not using "With No Recovery"

Your options are the create a SSIS package that dumps problem rows into an error file or you can use BCP to import and set the max errors to a...

Thanks for the feedback!! I am glad everything is working 😀

Marvin,

I have to agree with Jeff. This or no other query should be done with a loop unless you cannot avoid it. To put the performance impact into...

Like Amu said it depends on what you need. Really the only thing you will gain is login information.

The master db stores login information and a pointer to...

Have you tried DBCC Repair/Rebuild or DBCC repair with data loss?

More Info:

http://msdn2.microsoft.com/en-us/library/aa258278(SQL.80).aspx

You need to determine what level of data loss is acceptable and then design a backup strategy to...

If vendor software is not an option, then you pretty much have to restore from backup. The only free log reader I know of is RedGate's, Log Rescue, which...

Cool solution! Using xquery to parse the string is great. Good job, this code should be substantially faster.

Sweet. Thanks for letting me know everything worked out. 🙂

Forgot to mention that some of the notation is irrelevant. This is a cursor that I helped someone else on this forum with and forgot to delete my comments.

just...

It behaves just like a cte which also walk through a set of data one row at a time.

Please note that this particular solution uses a cursor, against my better judgement :w00t:

If you have a substantial amount of records this query could perform very poorly, as it goes...