SQL Server, Insert Into Select From Databases on 2 Servers

1. problem w/CREATE RULE...ON INSERT...INSERT INTO...SELECT...FROM...WHERE w/multiple inserts - PostgreSQL

2. Best way to select and insert a huge table in the same database

insert A (...) select .... from B inner join C on .....
will create huge transact log. Any better way?

3. Cross-database - select/inserts - SQL Server

4. selecting insert into another database

Hi,

I am able to create an additional table by selecting fields from another 
table, thing is I need to create table # 2 in a different database on the 
same server, this is my sql:

Select userid, TEMPFleischutID

into ZZFLEISCHUTEMPIDS

from users

This will create the table on the same database, I need to create it in 
database called "FAA", is this possible ?

Aleks 

5. Help with Insert statemnt selecting from Access database - SQL Server

6. Exclusively lock database during multiple SELECT, UPDATE and INSERT operations

Hi,

My application needs to execute several read and write operations to one or 
more tables in a Sql Server database and for the database to be exclusively 
locked across all these operations.

I cannot use lock hints because, as I understand it, they are part of the 
INSERT or UPDATE statements.  If I am executing an INSERT statement followed 
by an UPDATE statement within a stored procedure I need to prevent other 
users getting access to any records in the interval between the INSERT 
portion finishing and the UPDATE starting.

But it's worse - some of the INSERT/UPDATE bits are determined based on data 
that's been read in and cached in its memory by my application.  So what I 
need is to be able to do something like:

- Lock database for all operations other than mine
- Do the reads I need
- Do the writes I need
- Release the database so other users can either read it or execute similar 
lock - process - unlock operations

Is this possible, and if so, what's the best / easiest way to achieve it? 
(Bearing in mind that the operations that need to be executed while the 
database is locked are not all in a single stored procedure etc.)

If I can't do it 'properly' I will have to resort to creating a file on a 
network location and trying to open it exclusively in order to start the 
READ-INSERT-UPDATE stuff I described above, but I'm hoping to find the 
elegant solution - i.e. within SQL Server.

Thanks!

Pete 

7. INSERT INTO TABLE SELECT FROM ANOTHER DATABASE WITH JOINS - SQL Server

8. INSERT SELECT with multiple databases

Hello,

I want to do an insert select, where data from one table in one
database is copied into another table in another database. The
databases are on the same server. The tables have the same structure.

I have tried:  INSERT INTO db1.table SELECT * FROM db2.table
but I keep getting this error: Incorrect table name

Is it possible to do an INSERT SELECT with different databases on the
same server?