Home » Posts tagged 'SQL 2000'
Tag Archives: SQL 2000
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
Antivirus Exclusion Policy for SQL Server
Anti-virus & SQL Server on one system together are friends not enemies, if configured properly. Anti-virus are very useful programs from security, audit & venerability detection & removal point of view. But if team managing anti-virus server did not configure anti-virus policies properly then your SQL Server is going to face the problem. Here, we … Continue reading
Data Purity issue after upgrading SQL 2000 to later versions
In SQL Server versions prior to 2005, it was possible to have invalid data values into a database. That can lead to incorrect result or issue at time of query execution. SQL Server 2005 brings new option to the DBCC CHECKDB and DBCC CHECKTABLE commands to solve this issue. “DATA_PURITY”, The new option to check … Continue reading
SQL Server 2000 Extended Support ending soon………21 days left
· On April 9, 2013, Extended Support for SQL Server 2000 will come to an end, and SQL Server 2000 will no longer be supported. · What will change : · Self-Help Online Support will be available for a minimum of 12 months. Example: Microsoft online Knowledge Base articles, FAQs, troubleshooting tools, and other resources, … Continue reading
SQL Server Discovery Report
How can I check what all SQL server features and version are installed on my Machine ? It’s a frequently asked question. You need to study your environment, need to login each instance to check version & other details, to answer this question. Till SQL Server 2005, you have no direct solution. But Starting from … Continue reading