See url http://technet.microsoft.com/en-us/library/ms190763(v=sql.110).aspx for more explanation on this setting.

You can use the following code to reset the value to the default 0:

exec sp_configure 'user options', 0

reconfigure

Grant Fritchey (8/20/2013)

---

But, by snapshotting to a seperate set of disks and then performing DBCC there, you won't be seeing the physical layout checks run against the original set of...

You need to join the output of the function with a selection of the variables. Keep in mind that the variables will be the same for every row returned by...

- Start SQL Server Management Studio and connect to your instance

- Navigate to the database and expand the tables tree

- Right click on the table...

You should add something like this to your WHERE clause:

"AND DATEPART(wd, [date])=1"

You should probably put different statements within the WHERE between brackets, because of the use OR statements.

I can't give...

I've used WMIC to read the status of services on remote servers. But that was written a while ago. If I had to do it all over again, I would...

You can determine the day of a week for a specific date with the DATEPART function (sample: "datepart(dw, [date])"). Add this function to your WHERE clause.

If I understand correctly, you want the complete results without the lines "Prcessed Files count=0".

This query will give you these results:

SELECT DateTime, TextColumn

FROM Table_name

WHERE TextColumn <> 'Prcessed Files count=0'

ORDER BY...

Below is the code to restore your database [A] to a database with name [A_SB] using the FULL and two LOG backups of database [A]. You can query the standby...

You can connect to the server(s) and run services.msc to see which services are installed. When SSAS is installed, service "MSSQLServerOLAPService" will be available. When SSRS is installed, service "ReportServer"...

The (b)locking in SQL is a standard mechanism to ensure data integrity. This isn't a problem as long these blocking actions are short. Depending on the isolation level different actions...

Yes, the DBCC CHECKDB will create a (hidden) snapshot from the database. Because this is a clompletely automated process, you are not in control about the placement of the files....

Execute the code below to get a list of all backups taken on the specific database.

You need to restore the backups in sequence, starting with the full backup that has...

You need to RESTORE the LOG backup and not attach a log file. Include the...

Can you check and see if the commands are being blocked by other (long-)running queries?