Home Forums SQL Server 7,2000 SQL Server Newbies Can I create a table in Database B from a view in Database A in a script that's using Database A? RE: Can I create a table in Database B from a view in Database A in a script that's using Database A?

  • Just kept spinning, perhaps because View3 is rather large...or it could be that it doesn't really work, I've had that happen before too. I don't have my own test database to play with at the moment and I don't want to risk inadvertently messing anything up on the company DBs. I'm about 90% sure that the SQL I posted originally works as I intend it to, but I want to be extra cautious before I update the script. It may be that my Google-Fu is not very strong, but I wasn't able to find any sufficiently similar posts out there.