You can do it all in a single package. You will have 12 execute SQL tasks and 12 data flow tasks (one for each table).

OR

Use a Foreach loop container with...

What is your question?

KB (6/11/2008)

---

I looked for the text of the queries returning DBID as NULL in my environment and found that select statements using openquery to get data from remote server also...

Not if it is a mode 90 database. My question...

I was able to stop/restart the service without having to power cycle the server. The server, from an OS standpoint, looked like it was idle. Of course, I don't know...

I don't think you can encrypt the connection string in an older ASP application. I just spent the last 20 minutes searching for information on doing this and all of...

Before you start this project, be sure to run the upgrade advisor. It will look at your existing 2000 databases and point out the obvious errors or potential problems that...

http://msdn.microsoft.com/en-us/magazine/cc135978.aspx

I would guess you should have it by now.

If you will send me a private message with your number, I'll try it from here.

I just ran the following and got a successful message to my phone:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Default',

@recipients = '[my number here]@mms.att.net',

...

steve.dowie (6/10/2008)

---

Cheers for the response. Have tried it using 'Test' as the text body see below:

DECLARE @ServerName varchar (100)

declare @body1 nvarchar(100)

SET @ServerName = @@servername

set @body1 = N'test'

EXEC msdb.dbo.sp_send_dbmail @recipients =...

Since SMS is purely text, the HTML version coming up blank makes sense. The phone wouldn't know what to do with what you sent. For the non-HTML message, make sure...

Hmmm... That makes sense. So, if we trust who has access, sounds like we need to go and slap the developers around a bit... 😀

When I wrote my...

I understand it is not controlled code but don't we control access to the server in the first place? If we don't trust the person with the access to run...