SQL_Helper (3/26/2012)

I have a active passive cluster (2 node)

Now I want to create a seprate active/active cluster (2 node)

Appreciate if anyone help me to resolve my following query

1 - how...

what if you wrap the whole expression in ()

other than that, would need to see the data to figure out whats happening

whats the definition of the bulk insert task and can you provide a sample of the excel file that needs to be imported?

is that the exact text which is in the expression? if it is your missing a )

common cause is that the agent hasnt started

thats where you need the loop so that it send the email 1 by 1

DECLARE @Name NVARCHAR(100), @Email NVARCHAR(100), @Message NVARCHAR(MAX), @It INT, @Num INT

SELECT @It = COUNT(*) FROM todayBday

SET...

only problem would be the text as you have sun's you will need to contatinate in a char(39) to avoid using ' and terminating the string

sun'+char(39)+'s

and as always...

its the steps you need to take to get the task done.

first point of call would be to google sp_send_dbmail and see what parameters it needs to work, then google...

you will need to build some kind of loop, (while loop, cursor) then pass in the email and other data into parameters which are passed into sp_send_dbmail

pesudo code would be...

Jerry came up with the quickest soution, ask the other side if it is possible in their citrix environment to mount local machine drives on connection to citrix, if not...

please do not cross post

please post on this topic

you would want to look at the sp_send_dbmail procedure which lives in MSDB passing in the parameters you need.

if you want to send personalised mail messages to each, i am...

data driven subscriptions are only available in Enterprise edition so not everyone might have the right version to do that, but you can still use the normal subscription method to...

Error: Failed to connect to server BOM1-7HD1H1S.(Microsoft.SqlServer.ConnectionInfo) ***<nl/>2012-03-23 22:40:21.62 *** Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or...

wholegrain