Found Lawson Stored Procs In Master Database (LawsonTalk)

Title: Found Lawson Stored Procs In Master Database
Description: Found Lawson Stored Procs in master data

jb1111 - December 12, 2007 02:36 PM (GMT)

hi everyone,

We have Lawson Financials (latest) using SQL Server database on Windows.

I'm not a Lawson admin, know very little about Lawson, but I noticed some non-Microsoft" objects in the SQl Server 2005 master database.

Is this standard/normal for a Lawson installation? I'm hoping that the person who did the installation messed up.

We are not experiencing any problems becasue of this but, as a SQL Server DBA, I'm a bit concerned about Lawson SPs being outside of the lawson environment.

Please advise.

Thanks, John

mnye - December 13, 2007 09:16 PM (GMT)

Id be willing to bet that whoever did the install, when they opened the window to execute the SQL file to create the stored procs, they forgot to change the selected database. But Ive never done a lawson install so i dont know if this step is even necessary.

jb1111 - January 2, 2008 09:02 PM (GMT)

Thanks mnye.

Does anyone else know? We are close to going to production and I'd rather zap those stored procs out of master database while we can still do some testing.

Thanks, John

jb1111 - January 4, 2008 08:38 PM (GMT)

I ran this question by our Lawson 9 tech support guy.

He says these Lawson stored procedures do indeed belong in the master database.

... but I still wonder...

John

View Full Version: Found Lawson Stored Procs In Master Database