Welcome to MSDN Blogs Sign in | Join | Help

April 2006 - Posts

SQL 2005 and Editions on 32-bit/64-bit

Posted Friday, April 28, 2006 1:33 PM by Sanchan
SQL Server 2005 has 32-bit and IA64bit versions (just like SQL 2000), but it also has a specific x64-bit version that runs natively on x64-bit hardware. Read on to lean more about the versions, hardware and OS requirements. - SQL Server 2005 32-bit o Read More...
0 Comments

ENHANCEMENT - Maintenance Cleanup Task and SP1

Posted Sunday, April 23, 2006 11:27 AM by Sanchan
Maintenance Cleanup Task is a new feature available in SQL 2005 which can be used to remove files related to Maintenance Plans. You can learn more about it at this article - http://msdn2.microsoft.com/en-us/library/ms345177(SQL.90).aspx SQL 2005 RTM (32bit Read More...
5 Comments

ENHANCEMENT - Database Mail in SQL 2005 64 bit and SP1

Posted Sunday, April 23, 2006 11:13 AM by Sanchan
Database Mail is a new feature in SQL 2005 that provides enterprise class mailing functionality in SQL 2005 32 bit and 64 bit versions. SQL Server 2005 RTM x64/IA64 In SQL 2005 RTM x64 and IA64 bit versions, you can use Database Mail features just as Read More...
7 Comments

SQL 2005 Service Pack 1 is launched!

Posted Wednesday, April 19, 2006 11:35 AM by Sanchan
Yesterday, Microsoft officially launched Service Pack 1 for SQL 2005. - Learn about the new features and improvements included in SP1 A ton of new features have been added and a lot of improvements have been made in SP1 for SQL Server 2005. You can learn Read More...
5 Comments

TIP - Permissions required to run SQL Server setup?

Posted Tuesday, April 18, 2006 11:13 PM by Sanchan
When you try to install SQL Server 2005, the setup wizard runs under setup.exe. This service then adds registry keys, creates folders, grant privileges to the startup account etc. All this can only be done is the setup is run under an administrator account. Read More...
0 Comments
Filed under:

How to change the dump directory for SQL Server, Agent and FTS?

Posted Tuesday, April 18, 2006 10:51 PM by Sanchan
SQL Server creates dump files (files with a .mdmp extension) by default under the LOG folder. These dump files are generally created when SQL Server encounters an exception or access violation. A dump file can also be forced manually. If you see these Read More...
0 Comments
Filed under:

How to identify the build and edition of SQL 2005?

Posted Tuesday, April 18, 2006 10:08 PM by Sanchan
If you want to know the edition and build versions of SQL Server 2005 programmatically, you can use the following commands: - SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') OR - SELECT @@VERSION You Read More...
3 Comments
Filed under:

Installing SQL 2005 from CDs

Posted Tuesday, April 18, 2006 7:16 PM by Sanchan
When you order SQL 2005, you get either a DVD or 2 CDs. CD 1 contains server components and CD 2 has the tools components. To launch setup from CD 1, you can double click on setup.exe and walk through the setup. However, in case you don't want to run Read More...
6 Comments
Filed under:
 
Page view tracker