great point, SQLBOT!

Thank you

it should be busy.....

we have plenty of 'group by', joins, 'order by'...

also i did rebuilt a few indexes with 'sort in tempdb 'option for few databases.....

see no activity in tempdb

????

why not just create a share for D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder

and give him access to the phisical file that he can open with notepad

this way u don't have...

i found solution.....

http://support.microsoft.com/kb/307487

the only way to change 'initial size' for tempdb is

to shut down sql server

connect via cmd using sqlservr -c -f

Connect to SQL Server with...

it didn't shrink...

probably because long ago when I installed sql I specified 'initial size' tempdb data file 1000 mb

but this is my point.....

current allocated size is 1000 mb

and i want to split it to 4 256 mb

i will create 3 more data files later on with...

try this

sp_helprotect NULL, 'public'

Thank you....

So basicaly when I'm specifying the new location for a tempdb datafile

I can specify a new size for that file at the same time in the same script and...

restart sql server agent

Thank you Chim.

Here is what I found...I can't believe my eyes....

CONCAT_NULL_YIELDS_NULL

When set to ON, if one of the operands in a concatenation operation is NULL, the result of the operation...

yes, I did

they confirmed that encrypted SP are not visible

they said that at least the names of the Enc SP should show up....

it's not so, it just shows as 'other...

thank you

Anybody???

not exactly, this email shows you how much space on every drive is AVAILABLE

drive MB free

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

C ...

Try this script.

I created a sql job that executes this script based on the schedule,

such as evry morning at 7 am.

EXEC msdb.dbo.sp_send_dbmail

@recipients = 'email@email.com',

...