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...
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, 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.
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, 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...
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...
Hi, I'm trying to write this script that backup and restore a test sql login. first script backup my test login select...
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...
Hi, 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...
Hi, 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...
Hi, 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...
Hi, 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...
Hi, 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...
Hi, 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,...
Hi, 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...
Hi, 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.
