You are correct, Jeff. My script will be useful for the database objects which are created in older SQL versions and left unmodified and these objects throw error when the...

But right people will concentrate on the question and not on the title.

It is nice question...

+1

Very intelligent question...

I selected "0" and got wrong.

I think it is because 1 row in the system table is being affected and that is the reason the messages tab shows "(1 row(s)...

Yes, my question is different from the one posted on the site. I think it is Steve who changed the question.

Transaction log is a critical component of the database system, if there is a system failure, the transaction log might be required to bring back the database to a consistent...

Taking full backup once in a day is not enough, you need to take backup of transaction log as well to truncate the log file. Once the transaction log backup...

Good question...

SQL Kiwi (9/11/2012)

---

The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick and...

Hi,

SQL Server allows any character in the current code page to be used in a delimited identifier. For example, you can create a table with the name Employee], where the...

Hi,

Please look at the modified SQL below:

DECLARE @item_id VARCHAR(MAX)

SET @item_id = (SELECT metric_template_id FROM view_metric_template WHERE item_name = N'Hard Savings' AND template_name = N'Savings / Controller Validation')

SELECT vh.parent_work_id...

Hi,

"Other" is the wait category with all the miscellaneous wait types are categorized as 'unknown'. These waits occur for internal operations and no tuning is necessary to avoid such waits....

There are two ways you can add a column to the table:

1. Table design (GUI)

2. ALTER TABLE statement

Using the table design you can add a column at any place and...

Hi,

Create a linked server with "SomeLinkedServerName" on the Source SQL Server instance.

and execute the below statement (on the same instance):

INSERT INTO SomeLinkedServerName.DatabaseName.SchemaName.TableName

SELECT * FROM SchemaName.TableName

nice one...