[toc] Problem: A few days ago, while migrating data from one database to another, I encountered an interesting problem which user faced a lot. “I… Read More »How to Copy Table Schema and Data from One Database to another Database in SQL Server
In this post we will discuss about how we can generate SQL Server scripts of our database with existing data, once we generate the script,… Read More »Generate Database Scripts With Data In SQL Server
Introduction Hi All, How are you today? In this article we will see a solution for a fix that we usually encounter when you work… Read More »Solution for saving changes not permitted error in SQL
Introduction Hi All, I hope you are fine. We all are using SQL parameter in our application right?Yeah it is a good way to restrict… Read More »SqlDateTime Overflow, Must be between Error
This code helps you to find out the missing Indexes in SQL [sql] SELECT d.[object_id], s = OBJECT_SCHEMA_NAME(d.[object_id]), o = OBJECT_NAME(d.[object_id]), d.equality_columns, d.inequality_columns, d.included_columns, s.unique_compiles,… Read More »Find Out the Missing Indexes in SQL
Find the relationship difference between two DB. [sql] SELECT f.name AS ForeignKey FROM sys.foreign_keys AS f where f.name not in (SELECT f.name AS ForeignKey FROM… Read More »Find the Relationship Difference Between Two DB
find the relationships between tables in SQL Server 2008 [sql] SELECT f.name AS ForeignKey, SCHEMA_NAME(f.SCHEMA_ID) SchemaName, OBJECT_NAME(f.parent_object_id) AS TableName, COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName, SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName, OBJECT_NAME… Read More »Find Relationships Between Tables in SQL Server 2008
Find which are all table has set identity. [sql] select COLUMN_NAME, TABLE_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA = ‘dbo’ and COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, ‘IsIdentity’) = 1 order… Read More »Find Which Are All Table has Set Identity
Hi All, This code will helps you to get the count of entries in each table in a DB in SQL: [sql] SELECT sysobjects.Name ,… Read More »Get the Count of Entries in Each Table in a DB in SQL
Get the table count in a DB in SQL. [sql] select * from sys.tables where is_ms_shipped=’0′ [/sql]