.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

T-SQL

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
 
Hi, I got a query from one of the books on SQL server 2005 to view the usage statistics of all the indexes on a particular table.the query is SELECT   * FROM sys.dm_db_index_physical_stats (DB_ID('Lstockhhwb'),NULL, NULL, NULL, NULL); Now when i execute this query it is generating an error as Incorrect syntax near ( However if i specify first parameter as NULL the query is running fine Please help Thanks, Rishabh


View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend