Category Archives: Sql Server

Windows 7 64bit ODBC Data sources

Posted on September 26, 2012 by

Today I was trying to create and ODBC Data Source to a database using 32 bit database drivers. When I accessed ODBC Data Sources (32bit) from Control Panel, I could not create a data source using 32 bit drivers and … Continue reading →

Posted in Databases, Sql Server | Tagged , , , , , , | 1 Comment

SQL Server Select Table information

Posted on June 22, 2012 by

Today I am going to show you how do we obtain schema information in SQL Server 2005/2008. If you want to select all table names from a specific schema you need to use sys.tables and sys.schemas tables. For example I … Continue reading →

Posted in Databases, Sql Server | Tagged , , , , , | Leave a comment

SQL Server Truncate All Table Data

Posted on June 1, 2012 by

Today I want to truncate ( delete all table data) in a large SQL Server database instance. Plain delete statements are not going to work as there is a big number of constraints which do not allow that. After quering … Continue reading →

Posted in Databases, Sql Server | Tagged , , , , , , | Leave a comment