DECLARE db_cursor CURSOR FOR
SELECT name
FROM master.dbo.sysdatabases
WHERE name NOT IN ('master','model','msdb','tempdb') AND name like ‘lcn%’ -- exclude these databases
No need for NOT IN clause 🙂
DECLARE db_cursor CURSOR FOR
SELECT name
FROM master.dbo.sysdatabases
WHERE name like ‘lcn%’
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)