i think using the row_number function is the right way to tackle this; note i went to the trouble of putting your data into a consumable format; It helps you...

--a query as an attachment to the email

declare @body1 varchar(4000)

set @body1 = 'Sample Email from SQL2008 ' + CONVERT( VARCHAR( 20 ), GETDATE(), 113 ) +

' '

EXEC msdb.dbo.sp_send_dbmail

...

you have to have setup database mail before you can use it.

in SSMS, under the "management" folder, find Database Mail

you have to create a profile, and also at least one...

the parameters are comma delimited, you have a semi colon before @message.

change to a comma.

also, this param is spelled wrong:

@receipent

and i think you might need more parameters; see the...

naveedanjum1 (3/3/2011)

---

0 down vote favorite

I am working with a database name xyz , table name a ,b, c, d. my question is if in table a name field , table...

via SSIS, it's not possible; you'd have to automate excel in order to do that: formatting codes for excel cells are not exposed.

see this thread for Koen's more complete answer:

http://www.sqlservercentral.com/Forums/Topic1069138-148-1.aspx

a...

if your code is centralized, meaning all inserts occur in a single point of entry, like a stored procedure, then adding the email code to that stored procedure makes sense.

if...

RENAME is the oracle command to do what you are asking.

in sql server, a stopred procedure is used:

EXEC sp_rename 'admin','administration'

or

EXEC sp_rename 'dbo.admin','administration'

note the first parameter can accept just the tablename,...

well, your proc's constructions not going to work, but i realize that was a prototype.

you cannot have a GO command in the body of a procedure; to do what you...

one of the real problems is that a CREDENTIAL is created to hold the password for the SMTP user; i do not know of any way to script out the...

SQL Recon is a free utility that will help you find all installations on a network; other than that, it's reading the registry in multiple places on multiple machines, maybe...

can you add the # hours difference when calculating the server's getdate to the utc date?

for example, this returns 5 form my EST server...it might vary depending on daylight savings:

'

--'returns...

we'd be able to help better if you showed us the body of the stored proc; but in general, if you get an error that is level 16 or above,...

the client tools(SSMS) to query the database are really separate from the cluster itself; it's no different than having Winzip on one server and not the other; it's not...

definitely parameter sniffing first; it is very doubtful your network is bogging down just for one app, unless it is returning a MillionBillion rows. this is one of the first...