Viewing 15 posts - 4,981 through 4,995 (of 7,499 total)
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.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 4, 2008 at 7:28 am
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.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 4, 2008 at 6:40 am
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 4, 2008 at 3:30 am
How about ...
SELECT -- DISTINCT not needed because you use GROUP BY on these 3 columns
R.EntryOperatorUserID,
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 4, 2008 at 3:22 am
In addition to Gail's advise:
- Did someone enable PARAMETERIZATION FORCED for some or all databases (maybe even model db)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 4, 2008 at 3:01 am
- 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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 4, 2008 at 12:09 am
adekunle (4/3/2008)
I am sorry but it is not working.
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 4, 2008 at 12:03 am
Kenena Klosson (4/3/2008)
declare mycsr or the rest listed as myscr...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 3, 2008 at 11:53 pm
Matt Miller (4/3/2008)
...By the way - the relevant reply seems to be on page 17....
(that was a dirty trick there, Johan!)
...
Dynamic paging ... :Whistling:
In my SSC-forum-profile I've set "Posts...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 3, 2008 at 11:47 pm
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
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 3, 2008 at 8:37 am
must have been a moment of weakness :w00t:
For once it is ok :hehe: :laugh:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 3, 2008 at 6:10 am
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 3, 2008 at 6:05 am
- 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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 3, 2008 at 5:45 am
use bulk insert in combination with bulk logged recovery model
Keep in mind changing the recovery model will affect your DRP !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 3, 2008 at 4:14 am
Your update trigger needs to be firred !
Then you can check the update content.
CREATE TRIGGER tr_CallDetail ON CallDetail
AFTER UPDATE
as
Begin
if UPDATE (callnumber)
begin
-- this means the callnumber column...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 3, 2008 at 3:55 am
Viewing 15 posts - 4,981 through 4,995 (of 7,499 total)