Lun

we using sql server 2008 r2. some advanced users have been working on database retrieve data tables , alter existing views years. give them permissions create own views. it not supposed give them rights such creating tables. possible that, such creating new schema purpose. thanks. i don't think did give user permission on dbo objects. try again, don't grant permissions. see if had access dbo objects. if yes, permissions coming somewhere else. perhaps granted public. if no, repeat grant statements, checking after each 1 see when access dbo objects arrived. rick byham, microsoft, sql server books online, implies no warranty SQL Server  >  SQL Server Security

i have created vs 2008 deployment package in i have included sql expreress 2005 sp2 (sqlexpr32.exe) prerequsite (also .net 2.0 , windows installer 3.1).  installs on 32 bit machine, on vista 64 bit, sql express not install.  trying include sqlexpr.exe (which understand install necessary 32 or 64 bit environment...the wow version, think) in deployment package, not listed  under prerequsites on property page; lists sql server 2005 express edition sp2.  know how can add  sqlexpr.exe list of prerequsites, or how can version of sql server express included in deployment package?  many thanks. kira qian kind enough share solution this.  can add own custom prerequisites "click once" applications using bootstrap manifest generator.  can download tool from:   http://code.msdn.microsoft.com/release/projectreleases.aspx?projectname=bmg&releaseid=1567 kira left helpful link: http://www.codeproject.com/kb/aspnet/add_custom_prerequisite.aspx. ...

hi, i have installed tfs 2010 trial version , on windows 7 machine. tfs configured use windows users. need tfs user email id, api gives email id empty. in tfs database there field called mailnickname, remain empty. how update tfs users email address ? no special configuration needs done. however, tfs syncs ad on schedule changes don't how - it's hourly. second, have looked @ user object active directory users & computers (or whatever call these days ...)? don't assume field populated ... i've seen cases email set , working find , dandy ... email addresses of users not set in active directory. devbiker (aka j sawyer) my blog if answered question, please mark answer. if post helpful, please mark helpful. Archived Forums V  >  Team Foundation Server - Setup and Ad...

hello, have report 2 rectangles.  first rectangle has property [page breakafter].  there property value under break location called [disabled] doesn't seems work when change value false , true. when render report 1st rectangle shown on page 1 , second rectangle shown on page 2 event though have set value true. -miracles easy, impossible takes bit longer- hi pau, this disable property used group level can see in screenshots below. i have tested on local environment, if set “page break options” “between each instance of group”, , set “disabled” property “true”. there no page breaks between each instance of group when previewing report. obviously, property effective. in scenario, set page break in tablix level, , disable page break on group level, it’s no work. if have questions, please feel free ask. regards, charlie liao if have feedback on our support, please click here . charlie liao technet community support ...

hi, here sproc create linked server. ran successfully. but did not create link myremotesql, instead, linked @serverinstance.   use [master] go set ansi_nulls on go set quoted_identifier on go alter procedure [dbo].[createdlinkedsql] @serverinstance varchar (50) as if exists (select * sys.servers [name] = n'@serverinstance' )  exec sp_dropserver @serverinstance, 'droplogins' exec master.dbo.sp_addlinkedserver @server = n'@serverinstance' , @srvproduct=n'sql server' exec master.dbo.sp_addlinkedsrvlogin @rmtsrvname=n'@serverinstance', @useself=n'false',@locallogin=null,@rmtuser=n'mylogin',@rmtpassword='########'     use [master] go declare @return_value int exec @return_value = [dbo].[createdlinkedsql]   @serverinstance = n'myremotesql' select 'return value' = @return_value go   any help?   thanks   take @server = n'@serverinstance'  out of quotes.  use @server...

hi, is there way can change name of element . for example if have following xml < applicationdata xmlns = "" > < recordid id = " d_72bb6d91a3d946debd0f0b58b51ce56c " > 11 </ recordid > </ applicationdata > and want change element name recordid to other value e.g. sequencenumber can achieved? usm121 declare  @xml xml         set  @xml= '      <applicationdata xmlns="">      <recordid id="d_72bb6d91a3d946debd0f0b58b51ce56c">11</recordid>      <address id="d_49ef04a0b3df4a0eb03bbe57f3a501a7">      <row id="d_49ef04a0b3df4a0eb03bbe57f3a50117">        <city id="d_49ef04a0b3df4a0eb03bbe57f3a50127">a</city>       <city1 id="d_49ef04a0b3df4a0eb03bbe57f3a50137">b</city1>     </row>     <row id="d_49ef04a0b3df4a0eb03bbe57f3a50117">        <city id=...

hi, trying should simple task. have table linked several tables via foreign keys. relationships picked in entitiy model no problem, updated metadata [include] tag. when including 1 table only(users table), can pull data dbse without problem, when try include second table(types), no results. know data there , valid. code in domain service follows: public iqueryable getdetail(int id) { return this.context.details.include("users").include("types").where(d => d.company.id == id); } including types table without users table again gives no result, not sure how resolve. relationship set, , created in same way relationship users, , picked in entity model also. metadata has include tags. ideas? try changing name in model other types. Silverlight  >  WCF ...