Your string literal need to be NVarchar, not Varchar.

@query shouldn't be in quotes, you want the executesql to execute the contents of that variable, not to try and execute the...

Grant Fritchey (9/30/2016)

---

However, I do all my demos against AdventureWorks (and moving towards WideWorldImporters, or, as I call it, World War I, WWI) and my scripts and presentations are all...

Your string literals need to be NVarchar, not Varchar, so N'string contents' rather than just 'string contents'

Also, @query1 shouldn't be in quotes, you want the executesql to execute the contents...

No.

I said that an active VLF can't be moved. To...

Log backups *and* additional write activity on the DB such that the active VLF wraps around. You can't move VLFs, and you can't ever make the one that's active and...

The minimum RAM requirement for installing the OS is 4GB. Windows needs memory to manage...

The general guideline is to ignore tables under 1000 pages. Fragmentation only affects large range scans from disk, not general operations against pages in the buffer pool.

Make sure you're doing...

For 2, try a google search for database permissions

For 3, try a google search for fixed server roles and database permissions

You grant ALTER on the schema, then the required CREATE permissions at the DB level, make sure the user has NO permissions to the dbo schema, doesn't have DB_Owner, doesn't...

You can pass parameters to and from sp_executesql. See: https://msdn.microsoft.com/en-us/library/ms188001.aspx

Cool, so you have a working GRANT statement for the schema, based on the permissions listed there?

Have you even bothered to read the linked page?

The page that lists EXACTLY what are valid...

And, after you're read that, tell me whether 'CREATE PROCEDURE', 'ALTER PROCEDURE', 'DROP TABLE', etc are valid permissions to be granted on a schema.

What's the error?