Lun

i maintain application uses sql 2005 / 2008 data persistence. clients use merge replication (pull or push) replicate data. of tables contain information should never erased. versions of row such table should stored, somewhere in database. means updates , deletes rows should result in in 2 affected rows: • copy of row before change • row containing change (or deletion of row in question) plan achieve using after update,delete triggers on tables "versioning" required. old versions of row may stored in same database, other database (or database on linked server). hoping creating not replication triggers on published database. theory was: update , delete queries performed against subscribed database should replicated (for concurrency) publisher. when updates , deletes replicated, triggers on published database fired, updating table containing version rows. there seem 2 problems approach: 1/ update query against table of subsc...

i'm having issues merging our main development branch our test branch. before worked great, we're restructuring our code, we've moved 100 files around. i tried merging changes totally screwed branch up. we're going re-do branch, in future there way pure "copy & overwrite" 1 branch another? you use tf.exe . --- save script.tfc --- merge %1 %2 /r resolve %2 /r /auto:accepttheirs checkin %2 /r --- save script.tfc --- then run tf @script.tfc $/path/to/source $/path/to/target note potentially dangerous thing do: tfs throws merge conflicts reason, namely, wants human verify right thing being done.  sidestepping automatic accepttheirs blow away changes made in target.  (you can them -- that's source control -- point stands.) Archived Forums V  >  Team Foundation Se...

users able manage/configure kpis "browser" security role, when should have view permissions.  creating custom role task "view resources in folder hierarchy; , view resource properties.", still users able change kpi properties.  am missing something? hi usg_bi, first, if grant “browser” role users give them view permission, please check tasks added “browser” not including manage permissions. also, should take inherit account, kpis might inherit lager permissions managing reports parent or higher node. second, if add custom role in folder hierarchy, kpi report not inherit permission automatically. so, have modify role permissions report manually. third, please check whether user account used run kpis has great permissions, being members in system administrator group. if have question, please feel free ask. best regards, yuliana gu SQL Server ...

hi, after googling frantically solution problem decided try here. i upgraded windows 7 windows 10 when came available , had previous versions of sql server installed before uninstalled them before upgrading windows 10. there alot of traces of old installations , after spending hours removing them using msiinv.exe , cleaning out registry, there shouldn't left. still same error when trying install sql server 2014:  there failure calculate applicability of setting licensepath. this applies both standard , express version. standard version run iso , express version .exe file. edit: noticed have same culture id problem op in: https://social.msdn.microsoft.com/forums/sqlserver/en-us/a8a52f80-764d-4a01-b60a-1c4c363d1150/error-while-trying-to-upgrade-sql-2008-sp2-to-sql-2012-there-was-a-failure-to-calculate-the i live in finland apart timezone , keyboard settings set english. can't issue since it's worked fine before previous versions of windows. below summary.txt...

i using query year(getdate())  - year(patient_birth_year) - case when month(patient_birth_year) > month(getdate()) 1            when month(patient_birth_year) < month(getdate()) 0           when day(patient_birth_year) >day(patient_birth_year) 1 else 0 end dont know weather right or not giving results same answer showing patients same age i.e 106 dont know why can tell me how deal or give me query need calculate age dob dob column name  (patient_birth_year) tahir ayoub you cannot have select in named calculation. have   year ( getdate ())-patient_birth_year   vinu SQL Server  >  SQL Server Analysis Services ...

hi. i have set table header , group header repeat on new page.. when run report works fine on report manager... when export excel 2003 , hit print preview headers dont repeat on second , other pages.. how should fix this? and noticed strange fine when exported excel. , in ssrs 2005. first column in table had set false when ran report on report manager columns had been shifted left when exported excel worked fine. any appreciated. thanks karen           hi karen,  first question: need repeat group header , table header when export report excel, please refer steps achieve this: 1. open excel file, click “file” menu , select “page setup”. 2. in “page setup” dialog, click “sheet” tab. 3. in “rows repeat @ top” section, type in : $1:$1 (note: “$1:$1” means repeat row 1.) after that, header displayed on first page , repeat headers on su...

hai good morning what erd model , how use ,please give me description it. thanks shanthi hello shanthi, erd = entity relationsship diagramm; see http://en.wikipedia.org/wiki/entity%e2%80%93relationship_model olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Reporting Services, Power View