what if the results from the 2 columns are more then 24hours?
i need the Day before the HH:MM:SS like D00:HH:MM:SS.
i've 2 columns 1 with start date and the other with end date.
so far i run this syntax to get the datediff
datediff (ss,start_date,end_date) then...
I need to audit after logon and logout for users.
i use this article...
I'm running a proc that monitor my server every 2 min by sql agent job.
this proc duration is about 2 sec.
now i want in this 2 sec to call...
no i want both where to evaluate to true.
if i want to evaluate those 2 rows to true why i can write the select statement like that?
create table mytest (id int,col nvarchar...
how can i get top 10 results from each job in the sysjobhistory but when run_status = 0 show me the message from step_id = 1
and when run_status...
Thanks for answer.
can you show me how to set it up in this example?
@report_info nvarchar (max)SET
how i can change the output font and text size from this send email html results?
(example html output from BOL)
how i can convert the last_occurrence_time in the msdb..sysalerts to regular time like hh:mm:ss
but still if i want to use this kind of syntax like i wrote, it cannot be done?
what about sp_executesql can it be done with it?
is there a way to set the column that updated into variable.
create trigger mytest on tablename for insert
declare @columnname as...
all the query to view who is accessing the tempdb bring all the processes that running on the server.
i need t view only the processes who is...
i've setup an alert to monitor my tempdb if it is grows beyond XXGB.
i want to setup an a response to execute a job when the alert is fired.
I've to shrink it because someone make an incorrect query and it fill up the tempdb.
know no one is working on the tempdb,but i still can't shrink it...
when i run the DBCC SHRINKFILE i get this error message
DBCC SHRINKFILE: Page 1:3740312 could not be moved because it is a work table page.
i already try that and it is not working.it is not showing the SID and password properly if i change the values to varchar.
CREATE LOGIN [test] WITH...
I'm trying to write this script that backup and restore a test sql login.
first script backup my test login
is it document anywhere?
I've sql server 2005 with sp2 and i've setup the alert for the
"MSSQL$PRI2K5:Buffer ManagerBuffer cache hit ratio"
false below 90.
Separate names with a comma.