Viewing 7 posts - 31 through 38 (of 38 total)
Actually, version 9.0.3042 is the original SP2 version that has a few issues that you really don't want to encounter. There is a post-fix available (as mentioned above) that...
SQL Server Database Administrator
July 31, 2008 at 5:59 pm
In addition to what have been provided here:
http://www.exforsys.com/tutorials/sql-server-2005.html
You can also visit my blog
-Marlon Ribunal
SQL Server Database Administrator
July 31, 2008 at 4:42 pm
I created a similar scenario maintenance plan.
I posted part of my solution in my blog:
http://dbalink.wordpress.com/2008/07/12/how-to-create-dynamic-file-system-directory-in-tsql/
Hope that helps.
-Marlon Ribunal
SQL Server Database Administrator
July 31, 2008 at 3:47 pm
Download SQL Server 2005 SP2 Version 9.00.3042. You don't need to reinstall everything. Just install the Client Components and Notification Services, and you will be fine.
Download here: http://www.microsoft.com/downloads/details.aspx?FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en
-Marlon Ribunal
SQL Server Database Administrator
July 31, 2008 at 3:37 pm
Hey,
You start from here: http://dbalink.wordpress.com/2008/06/15/find-user-tables-and-their-columns-info-in-sql-server/
-Marlon Ribunal
SQL Server Database Administrator
June 18, 2008 at 10:54 am
Dude, you need to Install IIS. SQL Server 2005 have some components that need the IIS.
If you don't know how to install IIS, here is where you can find...
SQL Server Database Administrator
June 2, 2008 at 8:05 am
You can always set the idle time to a desired time-limit. Usually this is done for security reasons and not really for performance-related issue. SQL Server 2005 can handle that.
Regards,
SQL Server Database Administrator
December 11, 2007 at 10:32 am
Viewing 7 posts - 31 through 38 (of 38 total)