how i can run this syntax when i have a job name that called DB's

this syntax not working because of the ' between the B and s

select step_name from msdb..sysjobhistory

where...

are you sure that the spaceused is calculated right with this syntax?

THX

THX for the link.

i'm working with those steps in this article http://www.sqlservercentral.com/articles/SQLServerCentral/sqlserver2005logontriggers/2366/

my question is on the stored procedure.

i want to filter only if specific user make logon success or failed...

can anyone help plz?

is there a way to set the column that updated into variable.

like

declare @columnname as varchar (50)

declare @results as varchar (50)

set @columnname = 'col1'

set @results = (select...

is there a way to set the column that updated into variable.

like

declare @columnname as varchar (50)

declare @columnname1 as varchar (50)

set @columnname = 'col1'

set @columnname1 = (select @columnname from inserted)

print @columnname1

--to...

I've a thought about this trigger issue and i need your help here with this test that i try.

i create 2 table

- one the table that needs audit

create table...

yes.

all sql server 2005/8 SP are cumulative.

by the way there is sp3 already out there.(and it's cumulative too)

what are my options to capture the issue command on the deleted rows from the table?

THX

thanks.

this script is nice but it is not give the the current (live) CPU utilization, and i can't rely on it.

anyone have something else that give me the current CPU...

how can you create an alert for CPU utilization exactly?

THX

you can use this improved script.

--This script create a store procedure that Move All MDF - LDF Files

--Wrote by Avi Grinberg

create procedure MoveAllDatabaseFile

@FileType char (3),@fullpath varchar(100)

as

if @FileType not in ('MDF','LDF','mdf','ldf')

begin

print...

hi,

you can use this syntax to view the file backup information

RESTORE FILELISTONLY FROM DISK = N'C:\restore\restore.bak'

if you need more info you can use those syntax

RESTORE HEADERONLY FROM DISK = N'C:\restore\restore.bak'

RESTORE...

THX.

there was a problem with the export script on sql server 2005 sp2 log shipping.

on sp3 log shipping the error is disappear when you run the script on the secondary...

thx for your replays.

but anyone knows how to make the ms log shipping work from the tsql and not from the wizard?

THX

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 free space on the...