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...
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...
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
is there a way to set the column that updated into variable.
create trigger mytest on tablename for insert
declare @columnname as...
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.
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'm trying to write this script that backup and restore a test sql login.
first script backup my test login
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.
I'm trying to write a trigger that will backup a database on creation, but i get this error
"Cannot perform a backup or restore operation within...
I've 2 tables.in table one i've 2 rows and i table two i've one rows.
i need to insert into a third table in one row two columns that i've in...
we use an ERP program that users run queries likes that very often.
i run this query in the DTA and its say that nothing needs to be changed in...
if i use Mirror drive for LogFile and Raid5/10 drive for DataFile - should i make both partition to use the 64K offset or just the Raid5/10...
I use SQL Server 2005 DEV edition 64BIT SP2 on my production server, the OS is Windows Server 2003 ENT 64BIT SP2 and the hardware is HP ML360 G4...
how can i insert into one row the size of the LDF and the MDF from sysfiles,if i have this table and query?
CREATE TABLE DBSize (DBName sysname,...
can i grant permission INSERT on a column to user?
according to BOL i can't.
so if i have a table with a lot of columns and i don't want that...
I've HP Server with SmartArray Raid controller.i use 2 disk in mirror for the system operation and SQL Server Binaries,2 disk in mirror for the...
Separate names with a comma.