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

this is the book i used to learn warehouseing

http://www.amazon.co.uk/The-Data-Warehouse-Toolkit-Dimensional/dp/0471200247/ref=sr_1_1?ie=UTF8&qid=1332518170&sr=8-1

COFFEE!!!!!!!!!! had to much of the stuff today, I'm wired

you need to be careful with that dont you know. putting Google into Google will break the internet due...

do you have software assurance with your SQL 2008 licences? if so and it is still valid you can upgrade at no extra cost. if you do not...

personally I like to have atleast 2 full backups on local disk but thats just me

as you say it adds complexity to the solution and if you where to restore/backup...

this is one question I used to ask when I was interviewing, I didnt know it until I attended one of Itzik Ben-Gan's training courses in London and now its...

+1 on what Lynn said as well.

As long as the secondary read-only copy is not being accessed by the web or by more than the 200 CAL's already purchased you...

hadn't heard of that tool pack until this topic, must say looks great

L' Eomot Inversé (3/23/2012)

Koen Verbeeck (3/23/2012)

Well, the local version works. If I enter...

take a look in my signature block for Jeff's string splitter

each action has a cost against it, its the SPID with the lowest cost which is the deadlock victim

if they are exactly the same in each and every way then...