VSTSC's Community Server

Browse by Tags

• PowerShell
• SQL Server 2000

• Books Online and securityadmin

  Sometimes Books Online really ruffles my feathers, and this is one of those times. We have a separate security department that handles our IT security. They'd like to have their accounts be able to just administer the security on our SQL Server boxes, Read More... Posted Wednesday, May 20, 2009 5:50 PM by timbenninghoff | 0 Comments Filed under: Sql Server 2005

• Any Number You Want As Long As It's 1

  Any customer can have a car painted any colour that he wants so long as it is black. - Henry Ford in his autobiography " My Life and Work " SQL Server has a stored procedure for creating new SQL Agent jobs called sp_add_job , and this stored procedure Read More... Posted Thursday, April 09, 2009 9:29 AM by timbenninghoff | 0 Comments Filed under: SQL Server 2000, Sql Server 2005

• Object Limit And SQL PowerShell Provider?

  One of the applications we have from a vendor has a SQL Server 2005 database with over 50,000 tables. I was using the PowerShell provider for SQL Server to search through the tables to find any that had the word 'ROLE' in it using the following command: Read More... Posted Wednesday, April 08, 2009 1:35 PM by timbenninghoff | 1 Comments Filed under: PowerShell, Sql Server 2005