almost. 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. THX
hi, 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...
Hi, I need to audit after logon and logout for users. i use this article...
Hi, 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.
Hi, if i want to evaluate those 2 rows to true why i can write the select statement like that? THX create table mytest (id int,col nvarchar...
Hi, 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...
Hi, Thanks for answer. can you show me how to set it up in this example? declare @report_info nvarchar (max)SET @report_info =N '<br><font...
Hi, how i can change the output font and text size from this send email html results? THX (example html output from BOL) DECLARE @tableHTML...
Hi, how i can convert the last_occurrence_time in the msdb..sysalerts to regular time like hh:mm:ss THX.
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? THX
Hi, is there a way to set the column that updated into variable. like create trigger mytest on tablename for insert as begin declare @columnname as...
Hi, 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...
Hi, 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. the...
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. but the...
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...
Hi, I'm trying to write this script that backup and restore a test sql login. first script backup my test login select...
Thx. is it document anywhere?
Hi, 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. this alert...
Separate names with a comma.
