Hope this will help

sp_configure 'show advanced options',1 ;

GO

RECONFIGURE;

GO

sp_configure 'blocked process threshold',5 ;

GO

RECONFIGURE;

GO

---------------------------------------------------

--Create a Queue

declare @rc int

declare @TraceID int

declare...

third party tool like sql heart beat will help..

u can view blocking by sp_who2

Thanks Perry I modified the script liek this..

SELECT

CONVERT(NVARCHAR(10), state_desc) COLLATE Latin1_General_CI_AS + ' ' +

CONVERT(NVARCHAR(10), permission_name) COLLATE Latin1_General_CI_AS +

' ON [' + sch.name + '].[' + obj.name...

Thanks a ton Perry

What if we have 100+ users?

I need to get the same of each and every user in a database.

Try trigger

You want to know how it looks and more indepth

click this http://www.sqlservercentral.com/articles/SQL+Azure/68333/

http://www.sqlservercentral.com/articles/Career/61243/

Kudos Gail

KILL 2452

set nocount on

DECLARE @test-2 varchar(20), @key varchar(100)

if charindex('\',@@servername,0) <>0

begin

set @key = 'SOFTWARE\MICROSOFT\Microsoft SQL Server\'

+@@servicename+'\MSSQLServer\Supersocketnetlib\TCP'

end

else

begin

set @key = 'SOFTWARE\MICROSOFT\MSSQLServer\MSSQLServer \Supersocketnetlib\TCP'

end

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key=@key,@value_name='Tcpport',@value=@test OUTPUT

SELECT 'Server Name: '+@@servername + ' Port Number:'+convert(varchar(10),@test)

Even if ur database is in 2000 u can create SSIS package..

Or

U can craete a stored procedure for the same

Can u please let me know y cant u use DTS?

Create an SSIS package and schedule that

U sure u installed the same version u had earlier and then trying to attach the DB??

You might be having all .mdf & .ldf files..Try to attach all database to new instance..You need to recreate all users and jobs if u dont have master and msdb...