GilaMonster (8/27/2009)

---

Lynn Pettis (8/27/2009)

---

Personally, looks like a good reseearch topic for some one. I'd...

I'm just curious, but have you even tried looking some of this stuff up in BOL (Books Online, the SQL Server Help System) that you can easily access from SSMS...

Personally, looks like a good reseearch topic for some one. I'd just leave your...

Could you post your code and the name(s) of your linked server(s).

As does BOL (Books Online).

You need to rename the logical name after completing the restore.

Well, to really help we will also need the DDL (create table statements) for the tables in the query, sample data for the tables that reflect the problem you are...

dun (8/27/2009)

---

Yes, the MCTS 70-431 on p605 does say "You cannot create Database Snapshots against system databases." The MSKB at http://support.microsoft.com/kb/920926 does not have any errata for this page to...

Lynn Pettis (8/27/2009)

---

Well, if he's like the OP who basically called me...

Well, if he's like the OP who basically called me a "liar"...

David. (8/27/2009)

---

This demonstrates that the datediff solution does not change the age at the time of the birthdate. All the age results are the same:

declare @BirthDate DATETIME

set...

I'm curious how this would be done considering the metadata for the table(s) or table partitions is contained in the system tables in the primary file group in the .mdf...

Okay, it has to be something in the air. It seems that some of the OP's here don't like our answers and will argue it.

This time an OP took...

FredS (8/27/2009)

---

I was able to make it work, but I have no idea if it is stable or a good idea.

ALTER PROCEDURE [dbo].[IH_GetRecords]

@Area char(15)

,@AreaKey Int

AS

BEGIN

-- SET NOCOUNT ON added...

If you need help with performance tuning a query, please read the second article in my signature block regarding "tips to get better help with Performance Problems." Following the...