Page47 asks a novice question . . .

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Page47 asks a novice question . . .

Author

Topic

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-05-02 : 14:08:17


create proc mydb1.dbo.myproc
as
-- some very intense, logged dml on mydb2.dbo.mytable
go

use mydb1
exec myproc
use mydb2
exec myproc

Here is the stoopid question. Which log file grows?

<O>

sqlxpert
Starting Member

11 Posts

Posted - 2002-05-02 : 15:01:12

log of mydb2 will grow as the operating db is mydb2, this has been well tested in production environment.

AB

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources