The error code 0x80040154 is for "Class Not Registered". I'm wondering if your connection values are correct?

There is a section on this site: http://weblogs.sqlteam.com/phils/ about...

You could use EM to generate a single T-SQL script. Right-click on the database name > All Tasks > Generate Sql Script. Click on the show all button and you...

Hi,

It's possible to monitor the current activity by either capturing the results of sp_who2 or querying the sysprocesses and syslocks/syslockinfo tables.

I would be careful about automatically killing processes.

Hi,

I've never used SAS but can you set up a System DSN pointing to the SAS source on your Sql Server machine? If so you should be able to use...

Hi,

You can execute the DTSRUN utility using master.dbo.xp_cmdshell passing the variables in to defined GlobalVariables.

DECLARE

@var1 INT

DECLARE @var2 VARCHAR

Hi,

I don't think it's possible to create constraints on Image columns. You also can't reference them in the inserted/deleted tables of triggers.

There is a workaround that involves a trigger. You...

I can't see the screenshot, can you type the Error message please?

David,

Definitely more elegant than mine!! Should've seen that. I went through all sorts of JOIN routes and everything.

I don't know whether I'd call it elegant but this works:

DECLARE @invoices TABLE (AccountNumber INT, InvoiceNumber INT, InvoiceDate DATETIME, RowID INT)

INSERT INTO...

Have you got the MSDN link please? I think it'll be quite interesting to see what they're doing.

Thanks!

You can get a list of the local packages by querying tables within the MSDB database.

SELECT * FROM msdb.dbo.sysdtspackages

There are other tables in the MSDB database to do with DTS information also:

sysdtscategories

sysdtspackagelog

sysdtssteplog

sysdtstasklog

Is...

That's probably a lot better than I would have done.

And quicker too!

Okay, understood. I'll get back to you!

With that, I'm not sure DTS is the best way to go...

Can I just check with you to make sure that I understand...

You could use the DTS Import/Export Wizard in Enterprise Manager to copy table data. Right-click on the tablename in the list in EM and choose All Tasks > Export Data....