robert.gerald.taylor (8/20/2012)

---

I've got a schema (Reporting) that I want to grant CREATE, ALTER & DELETE permissions to a group; the T-SQL statements I did are:

GRANT ALTER ON SCHEMA::Reporting TO [abc\BI...

you can do this easily withe DelimitedSplit8K function here on SSC:

declare @val varchar(8000)

set @val='ABC DEF GHI JKL MNO 12 PQR'

select * from dbo.DelimitedSplit8K(@val,' ')

where ItemNumber=5

read the article here and...

this is creating a table dynamically, i think; or what access might call a query?

I'm weak on Access formatting:

this is what i'm talking about:

this is your query reformatted...

to use the GUI, you need dbo rights.

to do the same via script, you only need db_ddladmin.

sb_dataReader and db_dataWriter are for data only, not for DDL changes.

the GUI requires more...

if you have the query, we can help you html-ize it.

what have you put together so far?

rebuilding the database creates a fresh master, and would not retain the links to teh databases that were there previously.

fortunately for you, the MDF/LDF's will still be in place onthe...

A database is not like an excel spreadsheet; the data is not stored, nor returned in any specific order .

if you want the data in order, you MUSt supply an...

this page has it broken down by application:

http://msdn.microsoft.com/en-us/library/ms143506.aspx

Database Engine and data files, Replication, Full-Text Search, and Data Quality Services

811 MB

Analysis Services and data files

345 MB

Reporting Services...

I had speed-read your question, and assumed the problem was the GUI scripting out ALTER commands.

i completely misread your question, sorry about that. that's why i scratched it out, but...

that's EXACTLY why you need to follow...

that's EXACTLY why you need to follow...

no, i don't believe it will work.

if no schema is provided in SELECT columnList From Tablename, the default schema is assumed

...customschema in your example.

if you explicitly states teh schemanmae,...

if you run this command, are the results null for the ObjectName? I've never heard of the built in function not working correctly, it's usually because of the issues Gsqared...

Edit: What i thought below doesn't hold true; I just tested it, and I don't think it's doing what I thought it did.

Tools>>Options>>SQL Server Object Explorer>>Scripting.

I think It's the Scripting...

well this uses soon to be deleted oldstyle syobjects, sysdepends,etc, but it works correctly;

i'll look into updating it to use new metadata instead.

SELECT

OBJECT_NAME(sd.id) Referencing_Object,

(SELECT

...