I didn't forget this thread !

I'm not at the office today.

I'll get back to this tomorrow.

it is not a bug,

it is a limit one must know about.

If you need more than 8000 bytes, you need an implicit convert to varchar(max).

,replace(cast('abcdefghicde' as varchar(max)) ,'cde' ,'xxx') As...

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...