http://support.microsoft.com/?id=309182

In particular, this:

quote:

---

• The query must be a simple UPDATE/DELETE against a single remote table.
• All selection criteria (in other words, predicates in the...

You should be able to back up your tran log and then apply it to a restore (WITH NORECOVERY) of the earlier full backup using WITH STOPAT.

The "Remove inactive log"...

Perhaps something like this:

UPDATE Price SET AvgPrice =

(SELECT AVG(x.Price)

 FROM

 (SELECT TOP 4 Price

  FROM Price g

  WHERE Period > ISNULL(

  (SELECT MAX(Period)

...

No.

use tempdb

create table p(

pid int identity primary key)

create table f(

fid int identity primary key nonclustered,

pid int constraint fk_f_pid foreign key references p on delete...

DECLARE @sql varchar(8000)

SELECT @sql = ISNULL(@sql,'') + 'DROP CONSTRAINT ' + Constraint_Schema + '.' + Constraint_Name + '

' FROM Information_Schema.Referential_Constraints

EXEC(@sql)

--Jonathan

Perhaps you just need to put SET NOCOUNT ON at the beginning of the SP. This works for me:

USE Northwind

CREATE PROC p_Rank @EmpId int AS

SET...

quote:

---

Jonathan, regarding your last statement.....

>> This is also incorrect, as it will return rows with NULL values even when the

>> parameter is...

quote:

---

Hi Jonathon,

Thanks for your post. Regarding your code:

WHERE (AreaDesignatorID = ISNULL(@areaDesignatorID, AreaDesignatorID) OR ISNULL(AreaDesignatorID, @areaDesignatorID) IS NULL)

Why...

quote:

---

I am wondering how large is very large? What is the rule of thumb to go to multiple files? Should...

quote:

---

The way I always do optional filters in queries is thusly:

CREATE PROCEDURE query

(

   @filter1 ...

quote:

---

Jonathan....I'm not sure if your solution will work. For example:

@areaDesignatorID will only be NULL if the user doesn't want to search...

quote:

---

Sorry to barge in without any deep knowledge. But doesn't the log get truncated when you perform a backup?

---

quote:

---

From other tech sites that I use. I'll test it again the next time I test my backups. I've just never been...

quote:

---

You are correct....but what if both @areaDesignatorID and AreaDesignatorID are NULLs? The statement won't evaluate to TRUE. That is my problem....

quote:

---

Have you ever done this and had it work? I haven't had it work yet and the answer I keep getting is...