probably what you are asking, is, if you have multiple email accounts, how do i change which one is used for the default email profiles?

IN SQL Server Management Studio, int...

well, it's possible... you can do it with a wHILE loop, i guess.

something like this seems to be what you are asking for, maybe?

DECLARE @rowcount int

SET @rowcount = 1

WHILE @rowcount...

have you looked into SSRS Data Driven Subscriptions, I'm pretty sure that's exactly what you are after, so that there is no user interaction required to create teh reports...so you...

tripri (10/11/2012)

---

Hi I got a table with one column of lenght 500 and i got around 500,000 records.

So from that i'm looking for some record 'abc dfgr hjk kishg lZDjsdf...

ok SELECT OBJECT_NAME(437576597) will tell you the table that is having the problem.

since it says index(0) and index(2) on that object, we know the table is a Heap, and...

run this command in SSMS, and post the entire results back here.

the database in question is VertexProd, right?

DBCC CHECKDB('VertexProd') WITH NO_INFOMSGS, ALL_ERRORMSGS

yeah the second half of the issue is tough; you can stick the descriptive data in a relationsship witht eh columns/tables, etc with extended properties(sys.sp_addextendedproperty and fn_listextendedproperty), but that also...

if the OP can identify how he knows the "same record" already exists, it would be something like this

CREATE trigger Del_records on Active_Table

AFTER insert

as

delete from Active_Table a

INNER JOIN...

I had to do that a lot previously.

keep the table you import into, but create a view with column names that better describe the purpose of the columns;

even better, the...

this thread has a very similar issue:

too strong of permissiosn were granted, but the DENY command doesn't have the level of granularity to take away things like ALTER TABLE

this example...

come on, you should know this.

html does not respect whitespace!

find and replace char(13)(char10) with <br />, and isnert <br /> wherever else you want new lines to appear.

sanmon_11 (10/10/2012)

---

My friend,

Now...

if a table will do the trick, why not create and then drop a permanent table in master or msdb to hold the script you are generating for a ##globaltemp...

change your query to select distinct email, notes.

when you merge them with FOR XML, you often have duplicates.

should be very easy.

Start The Task Manager.

make sure you check the "show processes from all users' checkbox.

order by name or cpu to find the offending service.

right click onthe process in...

well now you have the desired contents for the email; now it's just a cursor based on that query:

here's part two of the example, where you send individualized emails:

DECLARE

...