If you are a DBA you should be familiar with @@Version to get the information for you SQL Server, but whatif you want to get a little more that the @@Version information. Here is a head start. CREATE PROCEDURE usp_getserverinfo AS IF @@VERSION LIKE ('% 10.%') BEGIN SELECT SERVERPROPERTY('ComputerNam... as ActualServerName ,SERVERPROPERTY('MachineName') as SQLServerName ,SERVERPROPERTY('InstanceNa... as instancename ,(CASE WHEN CONVERT(VARCHAR(2),SERVERPR... ......
I was at a client location the other day and there was a need to configure PowerShell to back-up the SharePoint 2010 Farm after getting my commands ready and executing them it boomed out on me with the following errors Verbose: [Database_Name] SQL command timeout is set to 1.00 hours. Warning: [Database_Name] Cannot open backup device 'e:\etekglobalinc\backups\s... Operating system error 3(The system cannot find the path specified.). The path seemed right but the .bak file didn’t ......
When publishing SharePoint 2010 Portal you encounter the following error “The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator. “ This issue is caused by lack of Session State Service which usually is a result of farm being configured manually. To fix the issue power up your PowerShell on the SharePoint Server and run the following commands, these commands will create a State Service ......