There's no way a table with 3 rows will return 9 rows from running a query with only a SELECT * and no where clause or join to another table....

Have you tried dropping the index and re-creating it? I don't know if that will do it but it's something to try.

Regards,

Mark

Am I missing something, this article is titled:

INF: Analyzing and Avoiding Deadlocks in SQL Server

How does this article help with my scenario?

I'm confused, which is typically not that...

Steve either typed this really late at night or after one too many beers, LOL.

Mark

Pedro,

For the sp_MSforeachtable suggestion, use this:

exec sp_MSforeachtable 'exec sp_spaceused ''?'''

For the DBCC SHRINKFILE suggestion, it would be a good idea to do a ReIndex or IndexDefrag of your tables after your...

This might be kind of a "hokey" suggestion but what the heck.  For the process doing the read, would it be possible to do a WITH(NOLOCK) on the table to...

Go to the properties of the server where you did the restore, under the Security Tab and Authentication, try selecting the SQL Server and Windows radio button if it is...

Try sp_change_users_login again with the Update_One option for the login and database user you want to fix.

HTH,

Mark

Juanita,

Once you are in the PROPERTIES window, go to one of the other tabs, lets say OPTIONS, and then change something.  Your OK button should be highlighted so you can...

Karim,

This topic may be a little subjective so I'll tell how I would clarify the two.  Recovery is the process required to bring your production database back online.  Restoring a...

There is another work around that's been out there for a while; you can run a dummy update statement against a non-production table.  Here's an excerpt:

STEP1

Run:

Try running sp_repltrans to get the transactions that are not being marked as sent to the distributor.

HTH,

Mark

Sameer,

In the job schedule, is it configured to have two seperate schedules, one for the job run at 12:30am and one for the job run at 12:30pm or does it...

Thank you Brian for the suggestions. I thought for sure I would get more responses; oh well. I do appreciate the help.

Brandt,

Here's one of those times when the standard "the answer you're looking for is in BOL" is probably the best answer.  But I don't want you to think I'm not trying...