Yes, the index rebuild is logged to the transaction log and therefore replayed on the subsequent restore.

your using impersonation then, this is out of my skill set now, if the data source the report uses is set to use that particular SSRS_Virtual account then something is...

just so happens that in a previous role I was tasked with doing just that so I went for PS

This was my script (changed to prevent servername and databasename from...

data source been redeployed, check the data source is still set to use the SSRS_Virtual account

impersonation gone wrong?

new data source which isnt set to use the account?

That will be the issue, you shouldnt issue ALTER DATABASE master MODIFY FILE as the MDF and LDF locations are also stored in the SQL Server Configuration Manger which is...

did you issue ALTER DATABASE .... MODIFY FILE for the master database?

Some of that stuff you should be able to get from sys.dm_exec_sessions. HostName, ProgramName, ClientInterfaceName, LoginName, SessionID.

OS will be tricky but if you had a table of servers with...

Developer == Enterprise but with special license rules

Standard != Enterprise

You can install Standard over the top, but will be a named instance

you could script the procedures out and put them in a locked down share on the network where only read permissions are granted, could render the file in a pdf...

do you not enforce IP rights, where anything company related is the companies and if used elsewere is in breach of these rights and can lead to the developer being...

ravisamigo (5/17/2012)

---

Hi All,

I'm having some doubts on Edition upgrade.

1) We have SQLServer 2008 R2 Enterprise Evaluation edition now.

Can we apply SQLSerever 2008 R2 standard edition licence key?

2) Do we have...

well there is no difference between granting view definition and scripting, if they have 1 they can do the other, so the queston is, do you want to limit developers...

if you do SELECT RIGHT(@@SERVICENAME,2) what do you get?

typically in a default instance it will be ER, so trying to put characters into a number wont work.

if they have view definition then they will be able to script out the objects as you have explicitly granted them the access they need to view the definition of...