|
2>
3> IF EXISTS(SELECT * FROM sys.tables
4> WHERE name = 'TrackPersons' AND schema_id = 1)
5> DROP TABLE dbo.TrackPersons
6> IF EXISTS(SELECT * FROM sys.tables
7> WHERE name = 'TrackPersons' AND schema_id = 5)
8> DROP TABLE sqllogin3.TrackPersons
9> GO
1>
2> EXEC sp_addrolemember 'db_ddladmin', 'sqllogin4'
3> GO
1>
2> EXECUTE AS login = 'sqllogin4'
|