My first thought is to do it via SQL job (cursor/loop) with SQL Mail (or Database Mail in 2005) functions

Something like

FOR every record in TABLE WHERE conditions = ...

BEGIN

EXEC send_email

@To

@From

@Subject

@Message

END

I think it's possible, but do you really want to have cluster in different physical locations?

They should be close-by, with a short heartbeat (private VLAN, or simply a cross-over cable)

You...

koteswara kishore K. (3/18/2009)

---

Thanks for the update.

In your Image just look there is a Login "sa" is not showing connected database information.

That is what i need. If...

I am using SSMS 2008 now

It supports block region (I just expanded/collapsed a IF BEGIN ... END block)

Anyway, FYI, there is SSMS Tools Pack for 2008 available

http://www.ssmstoolspack.com/Download.aspx

I knew it

The 40% promo didn't work a week prior

so I bought a MS voucher for $115 USD (plus 2nd shot) and booked my exam

The week after, the 50% off...

Yes, I think SQL 2008 requires you to have

.Net 3.5 SP1

and if you have VS2008 installed, it wants SP1 for that as well

Not sure what you mean

It does show DATABASE in the "Processes" panel in SSMS 2008 for me, and others

Google Image

Is SQL on default port (1433) and default instance name MSSQLSERVER?

If not, you have to specify it

or turn on SQL Browser

2GB on a DB server is really tight

Try limiting the MAX MEMORY in SSMS 2008 (to 1 GB or less)

or even STOP the SQL Service to see if Windows is...

I thought this was a trick question, but got it right anyway, whew~

If you are really searching for terms, FULL-TEXT will be faster

and it will return results right away, with a rank (but full-text has its cons)

You can create a full-text catalog,...

Any reason why you want to do this? As new SSMS costs more memory than a new tab in existing SSMS

Just called Prometric

The rep said the promo code came up, but only good for United States

so much for Canada being part of North America, I am hurt, as a Canadian...

You think IntelliSense is good? Try RedGate SQL Prompt 😛

command to refresh cache in SQL Prompt is CTRL-SHIFT-D

You should do what the error tells you to do, check

1. Job step history (if it's simple few lines trivial errors)

2. Go into Maint. Plan page, right-click on the...