Cache object is always null in SQLServer Cache Dependency

Posted by SheoNarayan under Error and Solution on 4/9/2011 | Points: 10 | Views : 1766 | Status : [Administrator] | Replies : 1

You might look at several other possibilities however just make sure that your table name into the SQL Statement is of two part. So in case your database table name is "PersonalDetail" your SQL statement should look like

SELECT AutoId, FirstName, LastName, Age, Active FROM [dbo]. PersonalDetail ORDER By AutoId


Not

SELECT AutoId, FirstName, LastName, Age, Active FROM PersonalDetail ORDER By AutoId


Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com



Responses

Posted by: Karthikanbarasan on: 4/11/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
Hi Sheo,

im not getting what exactly is that :(

Thanks
Karthik
www.f5Debug.net

SheoNarayan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response