Site: http://www.sqlserver-dba.com/ Link: http://www.quicksqlserver.com/rss.xml
by Jack Vamvas via SQL Server DBA on 8/19/2009 8:38:48 AM
The following command line brings up all instance names and asks to select an instance and then a few button clicks. C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe" /Remove ...
[ read more ]
by Jack Vamvas via SQL Server DBA on 5/27/2009 5:03:11 AM
SQL Server blocked access to procedure 'dbo.sp_sqlagent_get_startup_info' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For... ...
by Jack Vamvas via SQL Server DBA on 1/21/2009 5:18:26 AM
I ran the command EXEC sp_msforeachdb @command1="use ? exec sp_spaceused" which returned all the relevant information per database on a SQL Server instance I was troubleshooting. On the basis of the information I adjusted one of the db sizes .... ...
by Jack Vamvas via SQL Server DBA on 1/20/2009 5:23:51 AM
I installed SQL Server Management Studio , to view some a SQL Server instance 2000. I attempted to access the packages via the : "Management | Legacy | Data Tramsformation Services" and got the following message: SELECT permission denied on... ...
by Jack Vamvas via SQL Server DBA on 1/13/2009 4:53:21 AM
The SQL Server Surface Area Configuration command-line interface, sac.exe, allows you to import and export settings. In a recent server consolidation exercise I exported the setting and used it as a form of backup , in case of any errors... ...
by Jack Vamvas via SQL Server DBA on 1/8/2009 2:49:12 AM
There was a requirement to allow Ole Automation Procedures within SQL Server 2005 , this code will enable the feature. -------------------CODE START------------------------ sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Ole Automation Procedures', 1; GO RECONFIGURE; GO -------------------CODE FINISH--------------------------... ...
by Jack Vamvas via SQL Server DBA on 1/7/2009 2:26:14 AM
Executing batch files throgh Powershell - is not doable by design. The cmd.exe is the runtime environment for .bat files , and it is possible to issue a .bat call via the Powershell prompt PS> cmd /c mybatchfile.bat System administrator... ...
by Jack Vamvas via SQL Server DBA on 1/5/2009 2:22:14 AM
There was a requirement to add a SQL Server login to a group of SQL Servers. The SQL Server login was to be uniform across all the servers. I tend to use SQLCMD for most DBA tasks - and as... ...
by Jack Vamvas via SQL Server DBA on 12/31/2008 1:10:01 AM
On SQLServer 2005 Standard Edition Service Pack 2 - we have a routine that backs up databases onto a dedicated drive. It is a full backup to disk. This routine does not drop the database BACKUP DATABASE MY_DB TO DISK... ...
by Jack Vamvas via SQL Server DBA on 11/21/2008 11:45:14 PM
Based on some problems I've been working on recently, I've set up a maintenance policy to maintain the appropriate speeds on the Network Adapters. I've only found this problem on non-fibre networks. There are a few machines network adapter settings... ...
The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.
