If you want to do this once, all you have to do is query the DROP TABLE statements:

SELECT 'DROP TABLE ' + QUOTENAME(name) + '; '

And here's the BOL for creating one:  https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql

They've been around in Oracle ever since I started learning it  and in SQL Server since 2012.

A simple one to end the week.  Thanks.

You need to create the login and user.  If it were me, I'd grant SELECT privs on the tables and functions he needs and nothing more.  The principle of least...

The first thing that came to my mind was sys.indexes, but if the system tables don't honor isolation levels (which I didn't know) then it wouldn't work.

Do you...

Brandie, you say you had this working before, even with the difference in scope?

There are SOX rules about sharing data - so don't do it.  Like Gail said, source code doesn't fall under the SOX domain.

I'm interested in seeing the query...