I only subscribe to one. SQL Server Professional from Pinnacle. It's a good read. Lots of information in there. Aside from that I am subscribed to...

MDAC is Microsofts set of components to allow access you to read various datasources. MDAC comprises of tools such as ADO, OLEDB and ODBC.

What versions of MDAC and SQL...

Hi,

This query will list all constraints on a given table.

select *

from sysobjects

where parent_obj in (select id from sysobjects where name = '<TableName>') and type = 'C'

Clive Strong

clivestrong@btinternet.com

Or instead of multiple connections, you could create several Execute SQL Task Objects and step through doing each DB. (One for each DB to INSERT to).

Clive Strong

clivestrong@btinternet.com

Yes, you can call different DB's on one server, different Servers even within one DTS.

Feel free to ask anything on this forum. Lots of knowledge to be shared here.

If...

You can't do it with one query.

I dirty and quick way to do it is to use a cursor. Build the cursor full of DB names. You could then...

What kind of processing are you doing in your SP? Not quite sure what to recommend...basically, if all your SP is doing is a complex SELECT statement, then you...

What is in the Stored Procedure? Is it another Select statement?

You can't SELECT from a SP as in your example. However, if the SP contains another SELECT statement,...

Yes! Unless you managed to change the sort order of the dbase within the DTS. I've never seen the sort order change myself unless explicitly coded.

Clive Strong

clivestrong@btinternet.com

Hi,

I been toying with the idea myself. I need to re-format all of my documentation as, basically it sucks.

For SP's, I plan to document all of the criteria you...

This is a good one! Never come accross un-delimited files personally!

I would have gone with Mikes suggestion, except I would not write back to a file. I'd create...

Yes, to do this I would do the following...

exec sp_detatch_db 'Pubs'

GO

exec sp_attatch_db 'Pubs', @filename1 = 'e:\data\Pubs.mdf', @filename2 = 'f:\logs\Pubs_log.ldf'

That should do it..! For more help lookup sp_detatch_db & sp_attatch_db...

I presume this query used to work on the table and that the query has not changed?

Have you modified the table at all? Maybe added a trigger? I...

On Server1, create a Linked Server to Server2.

This way you can directly query Server2 from Server1's SP.

To create a Linked Server, open EM and Security => Linked Servers.

In you SP...

Hi,

Agree with Andy. As much as I'd like to go to a PASS seminar, I've not yet managed to persuade my boss to let me go...Just waiting for one...