hi ravi,

For findout the howmany no.of users connected to sql server you can able to use the stored procedure: sp_who

For find out the no. of the active users...

Hi Bhuvenesh,

when ever your tempdb full then automatically sql server restarts so check that one and one more thing is are you checking any query which is running long period...

Hi Holio,

db_owner is database level role means person having the db_owner permission means he can able to do any thing in the particular database ..db_owner and database owner both indicates...

Hi Bhuvnesh,

Thaks for reply

yes i have to create an linked server for pull the data from multilple servers .i too thought like that .let me try once

Thanks

rekha

But at this time i wanna t-sql script

Thanks

Hi,

Is any problem for user having the public role?

Thanks

Rekha

Hi,

Actually i want to use the below script for giving the datails of database name and size for all databases..

SELECT DB_NAME(database_id) AS DatabaseName,

Name AS Logical_Name,

Physical_Name, (size*8)/1024 SizeMB

FROM sys.master_files

so what...

Hi Muthukkumaran,

Thanks for quick response...could you give me that script having loop for all databases which gives database name and database size.

Thanks

Rekha

Iam talking about dts packages only...

How to scheduling (jobs)and executing the dts...

Thanks fro reply