Sql – Do I need to enable a Service Broker endpoint on SQL 2005 to use SQLCacheDependency

asp.netcachingnetsql server

My question really has three related parts which I hope you can help me clear up –

Do I need to enable a Service Broker endpoint on SQL 2005 to use the SQLCacheDependency mechanism?
If so, is there a specific port that needs to be used?
If neither of the web server machine and sql server are in a domain, what type of authentication is required, if at all? Certificates?

Best Answer

No you don't need enable a service broker endpoint to use the SQLCacheDependency. A Service Broker Endpoint is only used to send SQL Service Broker messages from one instance to another.

Related Solutions

Sql – Should I use != or <> for not equal in T-SQL

Most databases support != (popular programming languages) and <> (ANSI).

Databases that support both != and <>:

MySQL 5.1: != and <>
PostgreSQL 8.3: != and <>
SQLite: != and <>
Oracle 10g: != and <>
Microsoft SQL Server 2000/2005/2008/2012/2016: != and <>
IBM Informix Dynamic Server 10: != and <>
InterBase/Firebird: != and <>
Apache Derby 10.6: != and <>
Sybase Adaptive Server Enterprise 11.0: != and <>

Databases that support the ANSI standard operator, exclusively:

IBM DB2 UDB 9.5: <>
Microsoft Access 2010: <>

Sql – Get day of week in SQL Server 2005/2008

Use DATENAME or DATEPART:

SELECT DATENAME(dw,GETDATE()) -- Friday
SELECT DATEPART(dw,GETDATE()) -- 6

Best Answer

Related Solutions

Sql – Should I use != or <> for not equal in T-SQL

Sql – Get day of week in SQL Server 2005/2008

Related Topic