you need to assign the right permission across the whole of the home section, so that people can only see what you want them to see

In other terms

modify/delete all the...

please correct me if i am wrong on this sql guru's

when a row is deleted it is actually marked for deletion, then the internal clean up tasks comes along and...

you cannot tell BIDS what windows account to use to deploy reports it uses the account of the logged in user

SSRS uses windows auth so you need to ensure that...

so you want the get the IncidentID for a particual TransNo where IsVoid is 0

you cant it is a manual thing, SSRS cannot create the groups and assigne people to the groups and the permissions on SSRS

You have to do it yourself

i find the best way to do SSRS permissions is to create windows groups and then assign the group permissions to what it needs, making sure that at the root...

Yes I would have to agree with all the above comments about the 5th answer being in correct making me choose the 6th and getting the question wrong.

The MSDN page...

Thanks Gail.

I will gladly kick myself now, I forgot to put a "mode" in so was always doing limited and returning NULL.

I will go hang my head in shame.

Thanks

Ant

The instance will go into shutdown and not accept any new connections during the fail over. Any connections which are currently running at the point of failure will terminate....

SQLServerManager10.msc for 2008 and 2008 R2 and I think its 9 for 2005, but as I dont have any 2005 servers any more I cant confirm on that.

Indexes and FK's can be done by doing schema.tablename after tables

Might have to write some sort of loop when using GCI/DIR to get the list of tables to drill in...

Sorry I should of mentioned about the Add-PSSnapin parts, the server where the PS1 file was running from was a none SQL machine so it didnt have the SQLPS.dll's registered...

Assemblies and Users are under at the same level as tables and storedprocedures

Indexes and FK's I have yet to find myself as once your in tables you cant go any...

i use powershell to script the object definitions out to a .sql file on a nightly basis so that developers dont need any permissions on the live db.

couple of ways...

Yeah I can connect to the SSIS via SSMS and the SSIS package is there, the SSIS package was created by the maintenance plan wizard, it only rebuilds a few...