SQL Archives - Page 488 of 519 - SQL Authority with Pinal Dave

SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property

August 8, 2007

SQL Data Storage, SQL Server Management Studio, SQL Utility

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)

SQL SERVER – 2005 – List Tables in Database Without Primary Key

August 7, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Constraint and Keys, SQL Scripts, SQL System Table

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

SQL SERVER – Fix: Error 2596 The repair statement was not processed. The database cannot be in read-only mode

August 6, 2007

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server, SQL Server DBCC

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

August 5, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

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…

SQL SERVER – One Thing All DBA Must Know

August 4, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Backup and Restore, SQLAuthority Book Review

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?…

SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey

August 4, 2007

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQLAuthority Author Visit

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…

SQLAuthority News – Microsoft SQL Server Compact 3.5 Server Tools Beta 2 Released

August 3, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download

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…