This post is second part of my previous post about SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days
SQL SERVER – 2005 – List All The Column With Specific Data Types
Since we upgraded to SQL Server 2005 from SQL Server 2000, we have used following script to find out columns with specific datatypes many times. It is very handy small script. SQL Server 2005 has new datatype of VARCHAR(MAX), we decided to change all our TEXT datatype columns to VARCHAR(MAX).…
Read MoreSQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property
We can use SSMS to Enable Autogrowth property of the Database. Right-click on Database click on Properties and click on Files. There will be column of Autogrowth, click on small box with three (…) dots. Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – 2005 – List Tables in Database Without Primary Key
This is very simple but effective script. It list all the table without primary keys. USE DatabaseName; GO SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName FROM sys.tables WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 0 ORDER BY SchemaName, TableName; GO Reference : Pinal Dave (https://blog.sqlauthority.com), BOL
Read More
SQL SERVER – Fix: Error 2596 The repair statement was not processed. The database cannot be in read-only mode
ERROR 2596 : The repair statement was not processed. The database cannot be in read-only mode.
SQL SERVER – Stop SQL Server Immediately Using T-SQL
This question has came up many quite a few times with our development team as well as emails I have received about how to stop SQL Server immediately (due to accidentally ran t-sql, business logic or just need of to stop SQL Server using T-SQL). Answer is very simple, run…
Read MoreSQL SERVER – One Thing All DBA Must Know
FULLY BACKUP DATABASE. Update : I posted this post with only line. However I received many comments and questions asking different questions related to it. I have compiled all of them and modified this post. Most asked Question : What is the best time when database should be backed up?…
Read More
SQLAuthority News – Download SQL Server 2005 Samples and Sample Databases
Microsoft has purchased GitHub, the world’s leading software development platform where more than 28 million developers learn, share and collaborate to create the future for 7.5 Billion dollars.Â
SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey
I will be traveling for next two days to New York and New Jersey for Database Architecture and Implementation Discussion with one of the largest software technology company. The major focus of this firm is environmental product analysis. I will be not able to answer any questions, comments and emails…
Read MoreSQLAuthority News – Microsoft SQL Server Compact 3.5 Server Tools Beta 2 Released
SQL Server Compact 3.5 Server Tools installs replication components on the IIS server enabling merge replication and remote data access (RDA) between SQL Server Compact 3.5 database on a Windows Desktop & Mobile devices and database servers running SQL Server 2005 and later versions of SQL Server 2005. Download SQL…
Read More