You will naturally need to supply some of your own values, but here is what I use: You can get rid of the final if exists, if you have...

The usual suspects in this case are the connection properties (ansi_nulls, quoted_identifiers, etc.). Have a look at the connection properties for the connection in sys.dm_exec_sessions, or via profiler.

You should be able to set up a trigger for the CREATE LOGIN event. Look up create trigger in BOL This would be a server level DDL trigger.

I know that under transactional replication, you can filter rows, and/or columns from each article. I suspect this can be done with Merge replication as well, but I have...

Not necessarily. If you have 1000 people connected to a web server, there could be 1000 connections from the web server to the database server, or there could be...

You don't really have to bother. This is already in the msdb database. Have a look at the backupset and restorehistory tables there.

unfortunately, i think you are pretty much out of luck on this. If you know the time when it was removed, you may be able to go through the...

It might not be possible. The changing nature of the inconsistency bothers me, though. Is it possible that the corrupt pages are being replaced from a (good) mirror...

unfortunately, i think you are pretty much out of luck on this. If you know the time when it was removed, you may be able to go through the...

Have you tried SSIS instead? You may be able to right click on the database, go to all tasks->import data, and get the data from Access to SQL Server...

It might be OK. I remember in SQL 2000, if you ran DBCC checkdb against a database that was actively being updated, there was a chance you could get...

Typically, you use either shared storage in the form of a Direct Attached Storage device, or a SAN for disks. RAiD levels are up to them (and their budget).

The...

The database would be marked suspect, and no users would be able to access it.

I would expect no issues if you concentrate solely on IN_ROW_DATA. As I mentioned before, the only option for indexing BLOB type data is with full text indexing, so...

At a leaf level, a clustered index is the table. If you have a primary key defined on a column defined as nvarchar(32), and your table has a LOB...