Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). The off-row data node at page (1:38606), slot 0, text ID 812187648...

I deal with smaller databases and SQL express so performance may not be as much of an issue, but I use option 3.

Regardless, you will need to insert all the...

I have done this and have written a script to do so.

My situation is when customers of mine leave their merge subscribers disconnected longer than the retention period and I...

In management studio, right click on the SQL server and select disconnect.

The Object Explorer is a separate connection to the query window.

Run a DBCC CHECKDB on the database.

I've seen this happen when there is a corrupt hard drive sector in the middle of the database.

Also Stop the SQL server and try...

And following on from my last post, if you do want to start the server in single user mode, drop the Dev\ from the

instance name:

sqlservr.exe -m -s "Express2008"

http://msdn.microsoft.com/en-AU/library/ms180965(v=sql.100).aspx

If...

"SqlServr.exe -m" is server single user maintenance mode and you only need it in limited cases.

Restoring the master database is one that comes to mind.

If you goal is to start...

All I am saying is that if you shrink a database and reindex you may end up with just as much free space as you started with. That was my...

Never tried it - I have given up trying to get around the backwards US date format and just use ISO dates.

http://support.microsoft.com/KB/173907

I think I read it right - You did a shrink database and then a re-index.

I found doing in doing that, the shrink would compact the database pages putting them...

You should also do explicit database log backups (as well as normal backups) or make sure your recovery model is set to "simple" or your log file will grow out...

If anyone is wondering, you can use a global temporary table

##Employee

to get a file with the 7 records.

I have used this as a quick way to dump the results of...

I have never been able to find a definitive answer from Microsoft in their licencing documents regarding replication.

After chasing them up one time, the answer I got was that this...

You will find what you want somewhere in the distribution database tables.

http://technet.microsoft.com/en-us/library/ms179855(v=sql.100).aspx