DataBase – Page 21

May 12, 2012August 12, 2014DataBase, Server

Hardware and Software Requirements for Installing SQL Server 2008

Hardware and Software Requirements for Installing SQL Server 2008 The following sections list the minimum hardware and software requirements to install and run SQL Server 2008. For both 32-bit and 64-bit editions of SQL Server 2008, the following apply: SQL Server 2008 Enterprise is available for evaluation during a 180-day trial period. For more information, see the SQL Server: How to Buy Web site. Microsoft recommends that you run SQL Server 2008 on computers with the NTFS file format. For upgrades to SQL Server 2008, FAT32 file systems will not be blocked. SQL Server Setup will block installations on read-only […]

March 21, 2012DataBase

Find Processes causing Locks on MS SQL DBs

MS SQL provides a Stored Procedure (SP) named sp_who2 which will show up all the actions going on on the MS SQL DB server as shown below: You can have a temporary DB created with data from sp_who2 for your further processing as shown below — check if there is a table already existing with the name — you have choosen for your temp DB, if exists delete it if OBJECT_ID(‘tempdb..#temp_spwho’) > 0 drop table #temp_spwho go — create new table with required fields of sp_who2 create table #temp_spwho ( SPID int not null, Status […]

February 27, 2012DataBase

How to attach/detach a database without Enterprise Manager?

Introduction: Due to various reasons it can be possible that the Enterprise Manager cannot be used to attach/detach a database in SQL. For example when the MSDE version of SQL is used, the Enterprise Manager is not available. In this case MS-Dos can be used to attach/detach the database. Explanation: In order to attach/detach a database via MS-Dos follow the steps below: Go to [Start] [Run] and type CMD followed by [Enter] type cd [Enter] to go to the root C: type osql -E [Enter] now, 1> will appear. The commandline can now be entered. Attach a database: In the […]