Any tools available for this ?

thank you

hi

to get loigin user

DECLARE @UserLogon Char(128)

Set @UserLogon = SUSER_SNAME()

select @UserLogon

hi, check this query..

; with

RECORD_SET1(MIN_VALUE, MIN_TSTAMP)AS

(SELECT min(VALUE), min(T_STAMP) from @t

WHERE VALUE = (SELECT min(VALUE) FROM @t)),

RECORD_SET2(MAX_VALUE, MAX_TSTAMP)AS

(SELECT min(VALUE), min(T_STAMP) from @t

WHERE VALUE = (SELECT max(VALUE) FROM @t))

SELECT...

hi ,

pls check this query

select cardno,min(datetime1),max(datetime1),action

from view1

group by cardno,datetime1,action

please add GROUP BY in your query

ISNULL(SUM(Ac_Billbook.CostsNet), 0)

if we use desktop application and web application for ticket booking,

how the database will update:

...

k. thnkx

thanks

no im just a developer. but im trying to be a DBA

its my challenge to to solve it myself...

actually , there are 5 logins including 'sa' login. none of them have the privilege to create database or change privilege except 'sa' login.

but 'sa' login is disabled.

when i...

actually the user (with admin privileges) is already removed from domain and machine.

the only user having sysadmin privilege is 'sa' .

i cannot find any way to add new sysadmin...

query to check number of processor core equals to number of tempdb files?

yes i will...friend