SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


WAITFOR


WAITFOR

Author
Message
bitbucket-25253
bitbucket-25253
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16117 Visits: 25280
Tom.Thomson (12/23/2010)
Mauve (6/17/2008)
I somewhat disagree that a TIMEOUT can be used to end a WAITFOR. It cannot be used independently and is only an optional modifier of the Service Broker message.

I agree with Mauve, you can wait for a message or you can wait for whichever comes first, a message of a timeout, but you can't wait for just a timeout.


Bored, not enough to do?

visiting these QODs almost a year and a half after they were original posted..

Suggestion .. put your vast knowledge of SQL to a useful purpose for the community ... write a couple of articles .... pass some of your vast knowledge to others.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26289 Visits: 12506
bitbucket-25253 (12/23/2010)
[Bored, not enough to do?

visiting these QODs almost a year and a half after they were original posted..

Just working backwards through all questions because it helps me learn about the new things that have happened since SQLServer 2000. I have a little experience playing with SQL 2008 (as that's where I decided out system would go) but not much as the transition was at the experiment and verify stage (experiment because I wanted to be sure any relevant and useful new features got used, the port would involve rework) but none of SQL 2005 (I decided we would skip it - platform upgrades were an absolute nightmare in our business, because our customer contracts didn't allow us to force customers to take new releases of third party software that would require new licenses - I could install service packs and bug-fixes and free upgrades to my heart's content and with pretty minimal notice to the customer, and of course push out new releases of our software provided the upgrade was seamless and I wasn't demanding extra money on top of our monthly fees, but not new versions of SQL Server or Win Server or the Win Clients unless we could find the license money ourselves - we had badly drawn up contracts).

Suggestion .. put your vast knowledge of SQL to a useful purpose for the community ... write a couple of articles .... pass some of your vast knowledge to others.


I doubt if articles about my views on normalisation or on how to build nearly secure systems with SQL 2000 (obsolete and not interesting), or deadlock detection algorithms (where I was state-of-the-art about 20 years ago, but decidedly past my sell-by date now) or relational theory would be much help to anyone, these things probably are relevant in short comments in response to material that turns up in various SQLC forums but aren't the right material for articles. I intend to put together some more QoTDs when I get around to it, and maybe some articles when I feel more competent on some form of SQL Server that's more relevant to the modern world (SQLS 2008 R2 Express, or SQL 2008 R2 generally and maybe Denali when I've upgraded my toys to Win 7 and had some time using them). Anyway, I'd probably feel absolutely stupid writing articles for a forum supported by people like Jeff and Paul and Gail and Barry and Gus and various others, who know vastly more than I do.

Tom

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search