sorry for delay in reply

here is sp_who4 script attached

what are the sizes of databases?

how the auto growth option set for each database?

also

u can start trace on the server for some time (say 30 min) on server

and see...

can i revert back to my original tempdb?

i.e now i have 8 tempdb files, can i revert back to 1 tempdb file?

if yes, how?

Thanx a lot for ur replies

Here in this case ,the query provided here is getting fired after every 5sec(Which is refreshing & giving data to user after every...

u cannot create link server without sysadmin rights

refer the link

http://msdn.microsoft.com/en-us/library/aa560998%28BTS.20%29.aspx

but this is not applicable to xp_cmdshell

to execute xp_cmdshell u must be sysadmin

else even if u grant permission to nonsyadmin user for xp_cmdshell, u won't get permission.

GregoryF (4/6/2010)

When you enable xp_cmdshell what will happen is that...

catalog means...

visit

http://www.dice.com

As per my knowledge, there is no 64 bit client tool for SQL 2005

even if u install 64 bit version of SQL server 2005,workstation component (client tool)

remains 32...

this indicates Parallelism

ur query is going in parallel operations

this is possible when u have more than 1 CPU

better use foll script

-- Create the temp table for further querying

CREATE TABLE #temp(

rec_idint IDENTITY (1, 1),

table_namevarchar(128),

nbr_of_rowsint,

data_space_KBdecimal(15,2),

index_space_KBdecimal(15,2),

total_size_KBdecimal(15,2),

percent_of_dbdecimal(15,12),

db_sizedecimal(15,2))

-- Get all tables, names, and sizes

EXEC sp_msforeachtable @command1="insert into #temp(nbr_of_rows, data_space_KB,index_space_KB) exec sp_mstablespace '?'",

@command2="update...

Hii Gail,

in my scenario only 2 indexes are created one is clustered and other is nonclustered

clustered index is created on 1 column which i want to change and create on...

try this one

change the extension from .txt to.sql

Hii arun

Thanx a lotttttt

query worked for me, great job

only the problem is in o\p min & max date changes its sequence alternatively for each database.

for e.g.

O\p is

dbdate dbname datasize_MB

====== ========...