Viewing 15 posts - 241 through 255 (of 317 total)
Please review the following link to answer your question and good luck
November 8, 2010 at 1:56 pm
This is a really ugle subject in my opinion as Microsoft stopped asking for the license key at installation in version 2005 and higher, now you get a piece of...
November 8, 2010 at 1:50 pm
Great to hear, glad to help.
November 5, 2010 at 11:06 am
Since this is a dedicated SQL Server, the memory allocation is fine being set as default. Other things to look at are backups of the databases especially the transaction...
November 5, 2010 at 10:29 am
No worries, I am just glad homebrew01 caught the obvious oversight on my part. That has always been one of SQLs most annoying statements, @@version gives only the build...
November 4, 2010 at 1:53 pm
That's it, you are currently running SQL Server 2005 RTM - no service packs have been applied. If you would like to see all available versions, updater, service packs...
November 4, 2010 at 1:45 pm
Good catch - please run the following in SSMS
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Results need to be SQL Server 2005 Service Pack 2 2005.90.3042 or higher
November 4, 2010 at 1:32 pm
One more question than I will bow to the higher powers - is this happening on the actual server or when you are attempting to create a subplan via your...
November 4, 2010 at 11:22 am
May I ask what SP you are running, there was a bug on Maintenance Plans prior to SP2 on SQL 2005
November 4, 2010 at 11:19 am
I must be confused by what you are saying as I have multiple Maintenance Plans in SQL Server 2005 where I created multiple Subplans. If you are in the...
November 4, 2010 at 11:08 am
One more option, besides verify the TCP/IP enabled is to check the firewall and specificly port 1433
November 4, 2010 at 11:04 am
You need to delete a particluar file, which will remove all listed servers - "It turns out that you actually can clear the list, but it requires that you remove...
November 3, 2010 at 10:10 am
Is this happening at the server or on a local workstation? Check to see how much memory is allocated to your SQL Server instance and also take a look...
November 3, 2010 at 9:58 am
The following site lists all versions of SQL with a link to what exactly is in each update/release.
http://sqlserverbuilds.blogspot.com/
Hope this helps.
November 3, 2010 at 9:51 am
Viewing 15 posts - 241 through 255 (of 317 total)