SQL, .NET and everything Microsoft

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...

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...

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...

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...

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...

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...

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...

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...