Share
ReportDoes 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
You’re offline. This is a read only version of the page.
Announcements
2,434
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
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!
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
FETCH NEXT FROM tables_cursor INTO @tablename
END
CLOSE tables_cursor
DEALLOCATE tables_cursor
SET QUOTED_IDENTIFIER ON
GO
Here is a script to find all of the tables that contain a particular field name like Cpnyid
#1
Community Member
136
#2
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
#3
REUser
8
All responses (
Answers (
