- as Jack stated, you cannot guarantee data will be kept in memory.

- Best you can do is check your proc that it is performing its queries in the most...

Thank you for the feedback.

Add it to the list of reasons NOT to use linked servers 😉

cfr http://www.sqlservercentral.com/articles/Linked+Servers/62246/

so the link should be

http://www.sqlservercentral.com/Forums/FindPost457289.aspx

(as stated when you click the left-bottom number)

If you specify:

http://www.sqlservercentral.com/Forums/Topic478505-386-1.aspx#bm457289

You only get directed to the page, bot not positioned at the reply itself.

Did you have a look at the samples ?

Samples\Engine\ServiceBroker\EventLogging\Scripts

IMO if you just add an sp_start_job to the queues procedure, It'll do what you want to.

Maybe you can do this from within SQL2005 using events :

I hope this gets you on track ...

CREATE QUEUE PoisonQueue

GO

CREATE SERVICE PoisonService

ON QUEUE PoisonQueue ([http://schemas.microsoft.com/SQL/Notifications/PostEventNotification])

GO

-- set up...

How about ...

SELECT -- DISTINCT not needed because you use GROUP BY on these 3 columns

R.EntryOperatorUserID,

...

In addition to Gail's advise:

- Did someone enable PARAMETERIZATION FORCED for some or all databases (maybe even model db)

- afaik you cannot directly query wich schedule started your current job.

- I've use a "flip/flop" mechanisme in a job I knew that runs one time starting from stepx, the...

Did the xp_sendmail work on this server before this issue ?

If yes: What's the difference with the working one(s).

Here's the proc we...

Kenena Klosson (4/3/2008)

---

Hi - this thread is interesting to me, but it may not work as there is a typo with either

declare mycsr or the rest listed as myscr...

Dynamic paging ... :Whistling:

In my SSC-forum-profile I've set "Posts...

well, let's use a cursor to work trough the loop.

If it worked before (on that sql instance) , it should also work now.

CREATE PROCEDURE dbo.proc_happyBirthday2

AS

BEGIN

...

must have been a moment of weakness :w00t:

For once it is ok :hehe: :laugh:

If you have a large usb-disk that could house the temporary restored db db-files, you could start your sqlserver with an extra parameter, perform your restore, copy your table, drop...

- Yes ... but not with the propriatary MS tools.

- you could restore the db using a new dbname (and file-set) and then copy the rows of the desired table...