Well considering he needs to license 2 servers in an Active/active scenario, and only one in an Active/Passive (yes - even with Standard) - I'm not sure I follow how...

Query the system views to see if it exists.

SELECT *

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME = 'atest'

SELECT MIN(a.Start_dt), MAX(a.End_dt)

FROM(

SELECT

ROW_NUMBER() OVER(ORDER BY End_Dt DESC) AS [RowNbr],

Start_Dt [Start_dt],

End_Dt

FROM @t

WHERE End_Dt < GETDATE()

) AS a

WHERE a.RowNbr < 3

In addition to what was said above, by dropping/recreating you also loose all your changes history. Normally, you can use the query below to determine when a stored procedure...

Well no results usually means that you have any FTCs. Can you confirm that the text catalogs are in the questioned database. If you used the attach/detach method,...

Full text catalogs are backup up when you perform a full database backup. When restoring the database, the FTC should be pointing to the same place. If you...

Yep. I...

It is stored as a float. The portion left of the decimal is the date and the right portion is the time and seconds.

To further expand what Kent was saying. SQL server has explicit and implicit comversions. Explict conversions when you cast or convert a value to another data type. ...

This is a sample I came up with. It may not be 100%, but it should be enough to get you going. The logic is to get all...

Yep. It does but I still need more information. I take it that the WOID is what relates the work orders together. I need that piece of...

I am not sure what you mean by grouped? I do not see any aggregations, so I am guessing that you want the results ordered by parent/child. Is...

More info on searching for suspect pages.

http://msdn2.microsoft.com/en-us/library/ms191301.aspx

You can also query msdb for suspect pages.

SELECT * FROM msdb..suspect_pages

SP2 does not have a summary, it has Object Explorer Details. The reports are not listed on the Object Exploerer details, for SP2. You have to right-click the...