I don't like the idea of CLR code, but there have been a few people that have found it quite handy. I tend to side with those above and I'd...

Corruption errors are almost always hardware related, so I'd get the hardware checked.

You can try dropping and rebuilding the affected index, however that doesn't necessarily address the underlying cause.

REPAIR_DATA_LOSS should...

Second for Grant's advice.

You'd have to query information_schema.columns for the number of columns and then probably build a loop to sum up the values.

Note that storing an variable number of fees in the...

As stated above, the parser must be able to resolve the table at compile time. So variables must be declared table variables or a name given.

You can

exec(' select *...

Or write up a short article. It's always good to see how someone tests and their results.

COPY ONLY makes a regular backup, but doesn't reset the backup chain. Typically if I backup on Monday am, logs Mon pm, full backup Tues am, logs Tue PM, and...

It is localized, if that's available. If not US English is used.

The standard < should get replaced and work. Might need a space after it to prevent injection stuff.

Sorry I signed off last night. Had some family issues.

Are you connecting to SQL Server via a sysadmin/sa account? You will need those to move the resource database. Same for...

Also, if you shut down SQL Server before the NAS reboots, and bring it back up after the NAS reboot, you'll be OK.

Is that the Texas Memory Systems SSD? I've heard mixed things from it.

If it works, I'm sure the bottleneck will move around and our tuning advice would change quite a...

You can give them the database role for backup (db_backupadmin) for their database only.

For file system, you would need to limit the rights that their accounts have. As far as...

I wouldn't do that. Rebuilding is a serious step.

Did you see the server startup? Is this a remote server you are connecting to through RDP?

It sounds like media or hardware issues. Have you tried multiple tapes?

The surface utility does not need to connect.

SQLCMD should connect if the database is started. When you start it from the command line, do you see all databases recover in...