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...

No, you cannot use a Standard licence for a Enterprise server.

You could install SQL 2012 Standard, and uninstall SQL 2008 Enterprise Trial

annoymous authentication to the web site - as it implies no authentication, everyone can see

forms based authentication - uses forms to authenticated to the web site

custom authentication - write your...

the only way to change a column from DateTime to INT would be to drop and re-add the column as its an explicit conversion

ALTER TABLE is implicit based, if you look at the CAST CONVERT MSDN page, DateTime to INT has to be explicit so you need to do CONVERT(INT,Dtt) but you cant...