kwoznica (12/16/2008)

---

All,

I am still fairly new to SQL Server so please pardon the simple questions I may ask on these forums.

As a junior dba I feel it is...

Keep this in mind !!!!

the KB states:

Note If you are upgrading from SQL Server 2005 SP2 Cumulative Update 10 or from SQL Server 2005 SP2Cumulative Update 11, you must apply...

You can find it in the install bootstrap files:

e.g in the file "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_servername_SQL.log"

search for

MSI (s) (A4:D8) [09:09:29:007]: Command Line: USERNAME=xxx COMPANYNAME=yyy ERRORREPORTING=0 SQMREPORTING=0 INSTANCENAME=MSSQLSERVER INSTALLSQLDATADIR=D:\...

Make it fool proof...... and they'll come up with a better fool 😀

It will take a while before this...

rbarryyoung (12/15/2008)

---

I agree with you Johan, it is important to remember that unlike their corresponding DDL events, DDL triggers do execute synchronously and in the source execution context. Consequently...

.... a diaper issue, so to say :w00t:

Thank you for the comments.

Fortunately it didn't take me that much time to figure out the issue :Whistling:

I'm always using my version of sp_who to see what's going on...

ps (12/14/2008)

---

...

My questions are:-

1. how to control the number of backup sets that can be written in a file using the device i created above( in above example 2 backups...

Off course the @recipients parameter still needed modification ...

while @@fetch_status = 0

begin

Set @emailrecepients = @ops_manager_email + ';' + @it_manager_email

Declare @TheQuery varchar(1000)

Set @TheQuery = 'Select refno , ben_name, amount ,...

Here's a "dynamic" solution.

Primitive, but effective

It requests your data for all children with a total of 5

but it includes twins, triplets, ...

If you have 3 children and then are...

As you'll see I've commented the send_dbmail , you must un-comment it.

Test it first.

drop table branch_info

go

create table branch_info

(

br_code ...

s_kaswani (12/10/2008)

---

Dear when i execute i got this error

(5 row(s) affected)

Msg 137, Level 15, State 2, Line 14

Must declare the scalar variable "@ops_manager_email".

Msg 137, Level 15, State 2, Line 17

Must...

Simplest is to concatenate both columns in your query to a format your targetusage needs (dbmail)

Declare @email_recepients varchar(225)

declare @email_body nvarchar(max)

declare mail_merge2 cursor for select DISTINCT @ops_manager_email + ';'+ @it_manager_email,email_body from...

So your goal is to only send one email per recepient ?

In that case, alter your cursor :

declare mail_merge cursor for select DISTINCT supervisor_email,email_body from mail_merge

easyest way is to use sql server profiler.

Create your trace with all filters (db) you want and script it.

Then launch it in a startup job or procedure.