Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

what is the diffrence in DBMS and RDBMS?

ChipLee, Agreed and thank you for the post. In our scenario, we did not have spaces in the database or table names, but from a best practices perspective it is a good idea to address the issue just it case it does occur. Thank you, The MSSQLTips.com Team

SAinCA, I think this is the code you are referencing from this tip ( http://www.mssqltips.com/tip.asp?tip=1112 ): -- Table - The base table is stored with the -- clustered index, so moving the clustered -- index moves the base table CREATE CLUSTERED INDEX IDX_ProductID ON dbo.OrdersDetail(ProductID)...