I'm dealing with queries that manages a lot of data consolidation and I'm having to repeat large blocks of code to get the desired result.
I'm wondering if that is any way to make it simple.

My...

I can't find any DTS tool on MSSQL 2005 Express Edition

Is there any tool that execute DTS tasks?

I need to perform 2 tasks:
- import a large Access file into MSSQL
- deploy database to...

I hava a table that stores payment information, with invoicenumber int and part varchar, where part can be (1/1, 1/2, 2/2, 1/3, 2/3, 3/3, etc)

The thing is not all payments are related to...

I have a table with a primarykey ID and a unique key for ID_EMP and OSID
When I insert I want to populate the OSID column whth the next int value related to id_emp

My trigger works but is...

tks a lot
I was missing the dbowner prefix

[]s

Can a query running a selected database access a table on other database?
How do I grant this kind of access?
Going further, can a Foreign key be created among diferent databases?

I'm running...