Looking at the DTS object model, the Dynamic Properties Task is exposed via a method, hence you make be able to change it using visual basic

Personally I find copying the entries in the sysdtspackages table a lot easier, as described at http://www.sqldts.com/?204

Haven't used that one, but I have used ASPEmail (http://www.aspemail.com).

To call this you need to use sp_OACreate (see http://support.persits.com/show.asp?code=PS01050851 for details)

You would need to add...

Take a read of the following article

http://www.sqldts.com/?225

Books online is a good place to start

see 'sql profiler'

Frank,

MS provide the newsgroups via HTTP as well as NNTP, hence you should be able to get to them.

http://www.microsoft.com/sql/community/newsgroups/default.asp

NGS Software have two very good papers on injection. Well worth a read.

http://www.nextgenss.com/papers.html

You beat me by 11 seconds, and basically had the same answer....

Frank

Take a look at the following link

http://www.sqldts.com/?212

Steven

Here is one way using temporary variable and derived tables. This was quickly of the top of my head, hence there will be better ways.

set nocount on

-- setting up...

Are your databases set to 'autoextend'? (espcially tempdb)

Thanks Allen

I'll recheck the system/application event log to make sure I didn't miss any events.

You could try the (free) sqlping utility to can your network (http://www.sqlsecurity.com)

The new beta version also tells you the real sql version, hence you can check the patch...

SQL Server only takes the memory when it needs to. Hence when you restart it, it slowly takes more. If it hasn't used the memory it hasn't needed to use...

This was the first time I had seen this error, hence I was just after any extra info on it. As it was a first time, and due to the...