no its not but how to you view them in EM?

ok a5xo3z1, do i have to create a stored procedure for that? is creating procedures hard or should i just learn to do them? can you tell...

we got it thanks,

in a view:

'rcod' = CASE when TOT = 'errl' then '0001' END

Error 2002: SQLServer/Agent Error The sqlagen mail seesion is not running check the mail profile & or SQLserver/Agent Service startup account in the SQL/Agent Properties Dialog.

thats the error...

You must have a mail client that can be outlook. But is must configured in sql. how do you configure it? and how do you configure net send...

thanks that worked, cheers

i just wanted to say, hey nice name!

matt

nevermind, just add

order by ProductName

i wonder why that is missing from the view.

so if you say

select distinct name, count(name)

from table

it won't work

you have to say

select distinct name, count(name)

from table

group by name

and it lists the amount of each instance of the distinct name.

how...

thanks

what are mdf. and wmf documents?

what are the benefits of a compiled query plan?

yeah i was just curious about seeing some of the performance stuff.

can anyone use this to pratice in query analyzer or is it just for him? does it create an action after it runs? like to you get to...

If you want to view Processor time, interrupt/second, cache hit ratio, and current disk queue length how do you use or even launch the Performance monitor. I am using...