you will need to create an expression on the remote path something like the following, changing it to suit your needs

(DT_WSTR, 4) YEAR( GETDATE() ) + right("0" +...

yes it is possible as permissions are cumulative.

as you already know the groups to which the user has access too, check that these groups cannot delete data. Also they...

the leaf node is the bottom level of the tree which is the data pages, unless you mean something else?

changes the table to a heap

queries will cause table scans

non clustered indexes will cause a lookup scan

as it has to look through all of the data pages to find the...

please do not cross post

all replies here please

what is the reasoning behing dropping the clustered index?

you will need to build an expression in the ordering of the tablix based on the parameter values

something like

=IIF(Param!Item1.Value=True, Item1, IIF(Param!Item2.Value = True, Item2..............) untill all possible combinations of...

would also have to build in a call to UPDATE() as well to ensure that it only fires on the update of a specific column

CREATE TRIGGER trigger

ON Schema.Table

AFTER UPDATE

AS

IF (UPDATE...

well you learn something new every day, I didnt think this was possible

4DayWeek 😀

nope, you will need to fully reinitialise logshipping from scratch with a new full backup for the changes to take effect, you cant do this (below) as you cannot modify...

you will need to build a custom DDL trigger which consumes the XML for the ALTER PROCEDURE and ALTER TRIGGER events and splits out the ALTER command, user and date

this...

do you have digital media or physical media, if physical you should have received both x86 and x64 disks if virtual, then you should have access to the MS download...

do a foriegn key to the same table and pass in the right manager employee id for the employee, standard parent child relationship

the account which SQL is running as