Browse by Tags

All Tags » script   (RSS)
Copy the SQL Server instances list from Enterprise Manager using vbscript
07 February 08 01:34 AM | SQL Master | 2 Comments   
As you may be aware you can take help of Registry settings in order to copy the SQL Server list that are managed from the Central Managed server. I have seen this VBScript posted by Mohammed U posted the following script, you can save it as .VBS that Read More...
Script out Procedures and Functions - Part 2
13 December 07 11:57 AM | Madhivanan | 2 Comments   
Part 1 uses information_Schema.routines view and this is based on sp_helptext declare @sps table ( texts varchar ( 8000 )) insert into @sps select 'sp_helptext ''' + name + '''' from sysobjects where xtype in ( 'p' , 'fn' ) order by xtype , name create Read More...
Filed under: ,
TSQL to generate blocking scenario for testing
27 July 07 12:44 AM | SQL Master | 1 Comments   
Most of the times you have observed to identify the blocking and how to resolve them. How about you need a script to generate a blocking scenario within your queries, this is to identify the blocker script is working or not. Also will help to test whether Read More...