o? where is this default trace file stored? I don't remember turning anything off during setup.

thx

in our environment, dev has their own servers to destroy. we don't support the dev servers or their test databases, only uat and prod.

when they are promoting code to...

what's there not to understand about the script I provided? it creates a memory table and stores all of your .trn file names in it.

Then the while loop...

(nolock) doesn't help with performance. You are basically doing a dirty read of the table and allowing other process to write to that table. It does nothing for...

if u have already added the linked server then all you need to do is:

exec servername.msdb..sp_start_job @job_name = 'name of the job on the linked server'

4 part naming is your...

the script should go something like this:

-- declare variables

declare @dir varchar(1000), @rowid int, @sqlcmd varchar(1000), @filename varchar(1000)

declare @trn table (rowid int identity(1,1),file_name varchar(1000))

-- set variables

set @dir = 'dir c:\i386\ /TW...

hey jack,

here's table structure for @info-2:

and the select into statement:

INSERT...

you can use datediff and use a while loop to loop thru 12 times to give you 12 months worth of data.

or you can use datediff and the BETWEEN function.

RS is capable of sending out reports via email. I'm going to subscribe to the report and have it set to email me once a day 🙂

you can look into using ntext or maybe varbinary(max).

ntext will be removed in future releases.

varbinary(max)

Variable-length binary data. n can be a value from 1 through 8,000. max indicates...

nope, didn't work 🙁 . RS or C# here I come!

hrmm using case statement, interesting idea.

I'll give it a shot and if it doesn't work, I'll just use Reporting Services.

this is what I got now to send out regular HTML email

set nocount on

declare @tableHTML nvarchar(max)

SET @tableHTML =

' ' +

' ' +

...

transactional replication is near real time data being sent to your subscriber. your subscriber is accessible during this time.

mirroring is near real time data however, the mirrored server isn't...

is there an operator setup? is your server setup to send out notification?

I wouldn't rely on those latency BS SQL got, it didn't do me any good in the...