Notifications
Announcements
No record found.
Does anyone know of a good tool (or back-end scripts) on how to delete a company completely from the SL system?
*This post is locked for comments
The only idea I would have is to share the tables that contain the cpnyid field and then remove one by one from each of the tables where cpnyid = 'xxxx'
SET QUOTED_IDENTIFIER OFF
GO
DECLARE @tablename varchar(30)
DECLARE tables_cursor CURSOR
FOR
select name from sysobjects where xtype = 'U' and id in (select id from syscolumns where name = 'Cpnyid')
order by name
OPEN tables_cursor
FETCH NEXT FROM tables_cursor INTO @tablename
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @tablename
END
CLOSE tables_cursor
DEALLOCATE tables_cursor
SET QUOTED_IDENTIFIER ON
Here is a script to find all of the tables that contain a particular field name like Cpnyid
Thanks Elaine
I am communicating with the customer as well, and will possibly log a direct call with Microsoft surrounding this. (just so its official)
Thanks a mil!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
