Tuesday, October 22, 2013

Cannot create new folder in Windows 7

Unable to create a new folder in Windows 7. From within Windows Explorer if I select the "New Folder" option, nothing happens. Also, from the Desktop, the "Folder" option does not show when right-clicking and selecting "New".

Solution

Download Reg Fix

Wednesday, August 7, 2013

Changing the name of a SQL Server PC

1. Delete all maintenance plans before renaming the server
2. Go to Microsoft SQL Server Management Studio
3. Click new query
4. Run the following procedures without       "< ---------------------------------------------------------------------------------
sp_dropserver 'KUSERVER'                           <GO                                                                  
sp_addserver 'ANUSERVER', local               <GO

---------------------------------------------------------------------------------
5. Restart the PC
6. Go to Microsoft SQL Server Management Studio
7. Click new query
8. Change Database to "msdb "
9. Copy this Query to new query, change 2nd line (New Server Name) & execute query.
---------------------------------------------------------------------------------
DECLARE @oldservername as varchar(max)
SET @oldservername='
ANUSERVER'-- set the new server name to the current server name
declare @newservername as varchar(max)
set @newservername = @@servername
declare @xml as varchar(max)
declare @packagedata as varbinary(max)-- get all the plans that have the old server name in their connection string
DECLARE PlansToFix Cursor FOR
SELECT id
FROM sysssispackages
WHERE (CAST(CAST(packagedata AS varbinary(MAX)) AS varchar(MAX)) LIKE '%Data Source=' + @oldservername + '%')

OPEN PlansToFix
declare @planid uniqueidentifier
fetch next from PlansToFix into @planid
while (@@fetch_status<>-1) -- for each plan
begin
if (@@fetch_status<>-2)
begin
select @xml=cast(cast(packagedata as varbinary(max)) as varchar(max))
from sysssispackages where id= @planid -- get the plan's xml converted to an xml string
declare @planname varchar(max)select @planname=[name] from sysssispackages where id= @planid -- get the plan name
print 'Changing ' + @planname + ' server from ' + @oldservername + ' to ' + @newservername -- print out what change is happening
set @xml=replace(@xml,'Data Source=' + @oldservername,'Data Source=' + @newservername) -- replace the old server name with the new server name in the connection string
select @packagedata=cast(@xml as varbinary(max)) -- convert the xml back to binary
UPDATE sysssispackages SET packagedata = @packagedata WHERE (id= @planid) -- update the plan
end
fetch next from PlansToFix into @planid -- get the next plan
end
close PlansToFix
deallocate PlansToFix

------------------------------------------------------------------------------ 
10. restart SQLSERVER Service or Restart your pc
11. Create maintenance plans
12. If this doesn't work, leave a comment here and I will help you....

Thursday, February 14, 2013

Thunderbird Mail Account Settings Cpanel

This summary is not available. Please click here to view the post.

Monday, February 4, 2013

Version's Parameters must be greater than or equal to zero parameter name:build

After starting setup and clinking installation
Click on install new instance
setup support rules - runs fine
click ok
click install support files - completes
Then on the
Please Wait wile SQL Server 2008 R2 Nov CTP setup processes the current operation.....

Error:
SQL Server Setup failure
SQL Server setup has encauntered the folowing error:
Version's Parameters must be greater than or equal to zero
parameter name:build

Click OK



Solution
====== 
----------------------------------------------
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup\CurrentVersion]
"Language"=dword:00000409
"CurrentVersion"="8.00.194"
"CSDVersionNumber"=dword:00000300
"CSDVersion"="8.00.760"

----------------------------------------------
copy following info into a raji'saqlfix.reg file or recreate the following in the registry manually and the SQL Server 2008 R2 installer should continue successfully:
 http://www.sendspace.com/file/rqrxne