Backup log file with truncate_only option and shrink database log file.

restore header_only from disk = 'your bak file path'

Yes it is sql server 2005.

I want user can change table structure from query anlyzer only by scripts.

--For Full backup of system databases:

Declare @date varchar(50)

DECLARE @sql varchar(8000)

set @date = convert(varchar,getdate(),112)

DECLARE @BAK_PATH VARCHAR(4000)

declare c_bak cursor FAST_FORWARD FOR

select name from sys.databases where name in...

Can i run Upgrade Adviser on database which have in SQL server 2005 (which was restored from sql server 2000 ). but have compatibility is 80.

U can schedule following script as per ur requirement.

--Full backup database stared from dev_

Declare @date varchar(50)

DECLARE @sql varchar(8000)

set @date = convert(varchar,getdate(),112)

DECLARE @BAK_PATH VARCHAR(4000)

declare c_bak cursor FAST_FORWARD FOR ...

select Login_name from sys.sysprocesses

--To find hostwise connection

select hostname,count(spid) as Total_Connection,sum(isnull(memusage,0)) as MemUsage from sys.sysprocesses

group by hostname

----------

--To find Database wise connection

select db_name(dbid) as DatabaseName,count(spid) as Total_Connection,sum(isnull(memusage,0)) as...

-- To find Database space

sp_msforeachdb 'dbcc showfilestats'

GO

sp_msforeachdb 'sp_spaceused'

GO

sp_databases

GO

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

Row count and space used for all tables in database -------------------------------------------------------------------------------------------

/*****************************************************************************************************************************************

******************************************************************************************************************************************/

if exists(select * from sys.objects where object_id = object_id('dbo.proc_records_per_database') and type =...

Pls find attachment..

Great

Thanks,

Can u differentate Active/Passive and...

Yes,

SPID is intrenal process of sql database like any connection with database.

which u get from select * from sys.sysprocesses

and ProcessId which the cliient processes like SQL server and it'e comonent...

Use following script :

CREATE PROCEDURE DR_Script_logins

AS

DECLARE @login_name sysname

DECLARE @name sysname

DECLARE @xstatus ...

Yes u r right this way

Use follwing events:

TSQL:

1.SQL:BatchCompleted

2.SQL:BatchStarting

Stored Procedure:

1.RPC Completed

and use following filter

1.Databaseid

2.Loginname