Category Archives: Sql Server

Windows 7 64bit ODBC Data sources

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

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

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