Click here to Skip to main content
15,901,426 members
Home / Discussions / Database
   

Database

 
GeneralRe: Access Query Pin
bgeroux14-Nov-03 3:43
bgeroux14-Nov-03 3:43 
GeneralRe: Access Query Pin
Roger Wright14-Nov-03 4:19
professionalRoger Wright14-Nov-03 4:19 
GeneralRe: Access Query Pin
Mike Dimmick15-Nov-03 1:52
Mike Dimmick15-Nov-03 1:52 
GeneralRe: Access Query Pin
bgeroux15-Nov-03 6:31
bgeroux15-Nov-03 6:31 
Generaldbms_pipe Pin
mhmoud rawas12-Nov-03 18:30
mhmoud rawas12-Nov-03 18:30 
GeneralRe: dbms_pipe Pin
Mike Dimmick13-Nov-03 23:22
Mike Dimmick13-Nov-03 23:22 
GeneralRe: dbms_pipe Pin
mhmoud rawas14-Nov-03 20:01
mhmoud rawas14-Nov-03 20:01 
GeneralRe: dbms_pipe Pin
Mike Dimmick15-Nov-03 1:30
Mike Dimmick15-Nov-03 1:30 
Ah, I see: you're trying to notify clients that some data has changed.

This can't be done in the current versions of SQL Server. The next version, codenamed 'Yukon', will support this feature.

At present, I would recommend periodically polling the table from the client. This technique will apparently be used by the ASP.NET cache management code in the next version of ASP.NET, codename 'Whidbey', due to be released next year (IIRC), for SQL Server 7.0 and 2000.

A PRINT statement is only received by the client whose commands caused the PRINT to be executed. In ADO.NET, this message is treated as an informational message of severity 0 and can be handled by handling the InfoMessage event of your SqlConnection. The same is true for classic ADO (the event is on the Connection object).

It looks like (and I'll admit I'm just trawling the documentation here) ODBC will return SQL_SUCCESS_WITH_INFO (as opposed to SQL_SUCCESS) if a PRINT or a warning RAISERROR (severity 10 or below) occurs - you can then retrieve the message from SQLError. See also KB article 280109[^].
GeneralRe: dbms_pipe Pin
mhmoud rawas15-Nov-03 18:36
mhmoud rawas15-Nov-03 18:36 
GeneralSQL get some ZERO's Pin
student()12-Nov-03 11:52
sussstudent()12-Nov-03 11:52 
GeneralRe: SQL get some ZERO's Pin
Jeff Varszegi12-Nov-03 13:25
professionalJeff Varszegi12-Nov-03 13:25 
GeneralRe: SQL get some ZERO's Pin
student()12-Nov-03 13:55
sussstudent()12-Nov-03 13:55 
GeneralRe: SQL get some ZERO's Pin
student()12-Nov-03 14:27
sussstudent()12-Nov-03 14:27 
GeneralRe: SQL get some ZERO's Pin
Edbert P12-Nov-03 14:58
Edbert P12-Nov-03 14:58 
GeneralRe: SQL get some ZERO's Pin
Jeff Varszegi12-Nov-03 16:01
professionalJeff Varszegi12-Nov-03 16:01 
GeneralRe: SQL get some ZERO's Pin
student()13-Nov-03 3:35
sussstudent()13-Nov-03 3:35 
GeneralRe: SQL get some ZERO's Pin
Matt Gullett12-Nov-03 17:05
Matt Gullett12-Nov-03 17:05 
GeneralADO and DAO Pin
Anonymous12-Nov-03 4:41
Anonymous12-Nov-03 4:41 
GeneralRe: ADO and DAO Pin
Hesham Amin12-Nov-03 7:00
Hesham Amin12-Nov-03 7:00 
GeneralRe: ADO and DAO Pin
Tom Archer14-Nov-03 17:02
Tom Archer14-Nov-03 17:02 
GeneralIs Oracle really so much faster than MS Sql Pin
CillyMe11-Nov-03 22:21
CillyMe11-Nov-03 22:21 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
Mike Dimmick11-Nov-03 23:49
Mike Dimmick11-Nov-03 23:49 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
CillyMe12-Nov-03 3:09
CillyMe12-Nov-03 3:09 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
Bill Priess12-Nov-03 8:36
Bill Priess12-Nov-03 8:36 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
Matt Gullett12-Nov-03 17:15
Matt Gullett12-Nov-03 17:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.