here's a quick and dirty method that i've used on occasion,

where date >= left(dateadd(d, 1, getdate(), 11)

I don't see why that wouldn't work; if a sp4 attaches to sp3 then the opposite should still apply.

He said waiting to be shot down in flames

Yes it's called a DBA, but please don't call them a tool

To answer your question a little more seriously, you can always use...

You are more than welcome, and happy birthday too

If it makes you feel better you came out 192nd out of around 20,000 people,...

Well, as promised the results are in and the winner of the furthest Santa Toss is .....

drum roll please...

sushila

I was a bit disappointed at the take up but what...

is the .net application on the same PC as the one you can connect to or a different one, it sounds to me as if you have an MDAC issue...

I'd just go for the reboot followed by the sp_drop/sp_add method, that generally clears this sort of issue.

Did you reboot the server after you installed SP1?

It would help if we understoof what do you mean by mini-projects?

Do you mean the sort of tasks that need to be carried out on a server to keep them...

You'll need to amend the last SP to use the STMP mail version of your choice, we use this one but I'm sure the others will be fine

--- mental note,...

then create these 2 SP's in the same DB as the table

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS OFF

GO

CREATE PROCEDURE dbo.spAuditBlockedEvents

@BlockingProcessID int,

@BlockingEventID int

AS

DECLARE @ProcessID int

DECLARE @UTCNow datetime

DECLARE @strSQL nvarchar(4000)

DECLARE @EventID...

then create the following 2 tables in a DB

CREATE TABLE [dbo].[BlockedEvent] (

[UID] [int] IDENTITY (1, 1) NOT NULL ,

[BlockedByID] [int] NOT NULL ,

[EventType] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Parameters]...

Hi Carl, no doubt there are loads of different versions of this floating around but this is the one we use.

Create the 1st SP in the master database

-------------------------------------------------------

SET QUOTED_IDENTIFIER...

Sorry it took me a day to get back to you, my scripts won't do you any good for what you are trying to do.

I think it would probably be...

bounce...

Come on people, show a bit of holiday spirit and enter this competition, so far there's only 2 of you signed up

You have...

It sounds like you need to tell server A which login account to use for accessing server B.