You should be wrapping things in a transaction so this doesn't occur. Like you do w/ begin and commit tran. Have you considered using Component Services COM+ applications to...

Try this:

SELECT Inventory.Item, c.CompName

from Companies c ,Inventory i where

(c.ID = i.ManufacturerID )

union select Inventory.Item, s.SvcName

from companies s, inventory i

where (s.ServicerId = i.ServicerId)

Darren

You'll have to build a dynamic sql statement in a loop. Loop on the number of tests creating a select statement like this:

declare @SqlClause as varchar(500)

select @SqlClause = 'select...

I'm not sure what it is but maybe if you post your query we could brainstorm. If it's not in BOL, then you could try removing parts of the...

We use source safe. However, we've had to create custom tools to integrate tracking of stored procedures and some of our parameter tables that we want to track change...

Check out BOL topic "OPENQUERY". This allows you to call an insert query from a linked server.

Darren

1) In the Transformations tab of DTS properties. Double click on the line from the column that you want to transform to nulls. This should bring up a...

Did you check the system application logs on the server? Instead of rebooting can't you just kill that process?

Darren

My personal opinion would be to return all records that might be used and then process the subsets on the client side. You can easily do the loop by...

Wrap the above query in a cursor, then for each table name from sysobjects you can dynamically build a select query then call EXECUTE passing in the sql statement with...

Are you sure you don't have any jobs running on startup?

Darren

When your query is running, try running sp_who2 in another session of query analyzer and see if there are any blocks. Does this table not have an index with...

select * from sysobjects a, syscolumns b

where a.id = b.id

and b.name = 'YourColumnName'

Darren

OK, I got that working but I now have another issue. The new proc can run from any database but returns results only from the master database. Like...

Could you give me the purpose of this query in a real example so I can think it through more?

Darren