Home » SQL Errors (Page 2)
Category Archives: SQL Errors
What’s new in SQL Server 2016 installation?
1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules it will automatically moves to Next window. 2) On Server Configuration page, MS specifically ask to GRANT PERFORM VOLUME MAINTENANCE TASK permission to service account. SQL Services needs this access to perform instant file initialization … Continue reading
SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE
Error : Database backup is getting fail with below reason. The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is not online. Check errorlog file for the reason that full-text catalog becomes offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection … Continue reading
Thanks to Toadworld.com team for recognition !
Thanks to Toadworld.com team for recognition ! Toadworld.com Profile : http://www.toadworld.com/members/rohit-garg/blogs/default.aspx If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun Reference : Rohit Garg (http://mssqlfun.com/)
SQL Server 2000 || Disable sa login
Question : How to disable sa user in SQL Server 2000? Reason : Due to Security requirement of audit, We have to disable sa user for all SQL instances in environment having SQL 2000 \2005\2008 & 2008 R2. Answer : We can disable sa user from SQL Server 2005 onwards but this is not possible … Continue reading
ERROR || The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled.
Table with clustered index is totally depended on index accessibility. ERROR : The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled. REASON : We find that some disable the cluster index due to which issue occur. Clustered index physically sort & save data in … Continue reading