Hallo marabu
leider bekomme ich mit
SQL-Code:
IF NOT EXISTS (SELECT * FROM sysobjects WHERE NAME = 'access_rights' AND xtype = 'V')
exec ('Create view dbo.access_rights as
select sys.name as login_name,
ben.benutzer_id as benutzer_id,
ben.name as name,
ben.std_kundenstamm as std_kundenstamm,
ben.access_rights as access_rights,
ben.beschreibung as beschreibung
from sysusers sys
LEFT OUTER JOIN benutzer ben ON (ben.login_name = sys.name)
where hasdbaccess = 1 and ben.access_rights <> 'Deaktiviert'
')
immer noch den Fehler:
"Falsche Syntax in der Nähe von Deaktiviert"
oliver