Monthly Archives: May 2012

Passed Exam 70-448: MSSQL Server 2008, Business Intelligence Dev & Maintenance

Passed Exam 70-448: MS SQL Server 2008, Business Intelligence Dev & Maintenance this morning. Watch this space for my next step forward i.e., 70-452.

Posted in MCM, MCTS, SQL Server | Tagged , , , , , , , | Leave a comment

Attaching a database without log file

To attach a database without a log file is to use a simple T-SQL as below: I am taking an example of AdventureWorks 2008R2 database to attach without a log file; T-Sql as below: CREATE DATABASE AdventureWorks ON (FILENAME =’C:\Database\Data\AdventureWorks2008R2_Data.mdf’) … Continue reading

Posted in Attach database without log file, SQL Server | Tagged , | Leave a comment

Upgrading SQL Server Enterprise Evaluation Edition to Enterprise

Are you near to completing or have finished 180 trial period with your Sql server evaluation edition and would like to own the full corresponding edition of the product; If yes then you are probably concerned if there is going … Continue reading

Posted in Setup, SQL Server, upgrade | Tagged , , | Leave a comment