Lun

hi , we have sql 2005 in 1 physical server running on windows 2003 platform, have new server sql 2008 sp1 running on windows 2008 , can 1 me move windows 2003 server sql 2005 db's windows 2008 sql 2008 sp1 db?   hi, there are many ways move/copy database 1 server server using sql server tools. i) detach database old server , attach in new server. purely offline operation , moves database instead of copying it. refer  http://msdn.microsoft.com/en-us/library/ms190209.aspx  : how use attach/detach database in sql server management studio(ssms) ii) database in old server , restore in destination server. can performed during online , creates new database in destination server. refer  http://msdn.microsoft.com/en-us/library/ms187048.aspx  for more information. iii) using copy database wizard in sql server management studio.  select database in source server in ssms right click ->tasks->copy database wizard launch copy database wizard. enter

hi, i’m trying creat medical report.   all fields have 1 item, except medications can list of different medications. i have 2 tables , record , medications.   the medction has record id points id of record table. first created simple data souec, select * dbo.record.   then put table on report , drag firlds over.   this producs spreed sheet reeport of report fields.     i cannot figure out how list medciations perting each record row.   i tried creating simple join id record table equaling recordid firled in medications, well made empty report. i’v done in access using embed reports, there way this???? hi ted, thanks question , sandip’s suggestion. based on description, guess created report using wizard. if didn’t close design surface of report yet, click undo button rollback incorrect actions. click edit button in menu, click undo. if had closed design surface of report, re-design missed data window. this msdn article has detail steps of how desig

we have mentioned our plans support ef code first in past @ conferences etc but happy planning make feature available in wcf ria services v1 sp2 when ships silverlight 5 rtw. most of feature work additive; i.e. separate dll adds existing product dlls. turns out feature did require changes product assemblies domainservice wizard experience. exploring how best preview of in hands earlier. no promises yet may able core run-time capability add-on preview purposes (only) sooner. thanks interest in wcf ria services , ef code first , using 2 together. dinesh kulkarni program manager, wcf excellent news, thanks. hope test soon. Silverlight  >  WCF RIA Services with Silverlight

hi, want add 1 gridview control follows in silverlight application. can 1 me how achieve this? <asp:gridview id="gdview" runat="server" autogeneratecolumns="false" alternatingrowstyle-cssclass="grdalterrowcolor" headerstyle-cssclass="grdheading" headerstyle-horizontalalign="center" rowstyle-cssclass="grdlable" rowstyle-horizontalalign="left" cellpadding="4" cellspacing="0"> <columns> <asp:templatefield headertext="s.no"> <itemtemplate> <%#container.dataitemindex+1 %> </itemtemplate> </asp:templatefield> <asp:templatefield headertext="questions"> <itemtemplate>&nbsp;&nbsp;&nbsp; <asp:textbox id="txtquestion" runat="server" textmode="mul

could please provide sample pdo connection strings connecting sql server 2005+ , sql azure db sql server driver. seem having trouble doing , don't see initial docs it. thanks. hi anthony, we have our docs on msdn. in particular, here page on constructor including sample code use api. http://msdn.microsoft.com/en-us/library/ff628159(v=sql.90).aspx in order connect sql azure, 1 needs add server name after user name. example: " user@tcp:xxxx.database.windows.net,1433 " xxxx replaced name of server (sql azure). hope helps. thanks.  ashay chaudhary   ashay chaudhary program manager, sql server driver php SQL Server  >  Microsoft Drivers for PHP for SQL Server

i have ssis package looping through excel sheets (tabs) , exporting sql2005, working but.... --- times file missing field or file has empty sheet etl fails questions 1- how can find sheet/tab (technically table) in excel missing field/column? yes have list of fields/column in variable how can list of fields of excel file compare with.   2- how can bypass empty sheets , go next sheet without package failing, remember process done in loop thanks http://msdn.microsoft.com/en-us/library/kcax58fh.aspx imports system imports system.data imports system.data.oledb imports system.text imports microsoft.sqlserver.dts.runtime <system.addin.addin("scriptmain", version:="1.0", publisher:="", description:="")> _ <system.clscompliantattribute(false)> _ partial public class scriptmain inherits microsoft.sqlserver.dts.tasks.scripttask.vstartscriptobjectmodelbase enum scriptresults success = microsoft.sqlserver.dts.runtime.dtse

hi,   have following setup: •web server has sharepoint 2010 , project server 2010 uac enabled •database serevr has sql server 2012 , ssrs 2012 uac enabled   built report using ssrs , deployed report sharepoint site using page viewer web part (native ssrs), when i'm trying view report web server through sharepoint site ssrs error "the request failed http status 401: unauthorized" when i'm trying access report database server through same sharepoint site working correctly!   can explain me? hi, "the request failed http status 401: unauthorized" should realted authentication. have @ http://msdn.microsoft.com/en-us/library/ee384252(v=sql.100).aspx  which includes solution this. if don't understand how register spn kerberos authentication, have at: http://msdn.microsoft.com/en-us/library/cc281382.aspx http://support.microsoft.com/kb/2723587 regards, james

hello! i have change collation of our sql server 2008 r2. i fond statement so: setup /quiet /action=rebuilddatabase /instancename=instancename /sqlsysadminaccounts=accounts /[ sapwd= strongpassword ] /sqlcollation=collationname but can't figure out hot use admin account built iin sql server (not domain or local machine user). btw: in june 2010 ther reported there bug in setup prevents task of working. anz news this? thanks in advance , regards, fritz log on using ssms , sa account , pwd. check wich account sysadmin, or add own account , add sysadmin server role. can start installation sysadmin account thats local admin on server. regards marten rune microsoft certified professional database administrator/developer 2008 SQL Server  >  SQL Server Database Engine

i in middle of large project migrating ssrs 2005 reports ssrs 2008 r2.  has gone extremely hit huge roadblock i've been trying debug past 2 days.  help!!!  caveat did not develop of these reports. i have report runs flawlessly on our current 2005 report server when run in either visual studio 2008, report builder 3.0 or 2008 report server (against exact same data source - ssas 2005 cube), of cells on report show #error. the report rather complex , set of 6 tablixes contain drilldown capability.  many of textboxes in vs have warning [rsruntimeerrorinexpression] value expression textrun 'textbox127.paragraphs[0].textruns[0]' contains error:  input string not in correct format'.  have been able find stop gap solutions of these textboxes not of them involve type casting of metrics within expression in textboxes same data type. i don't want rewrite report because complex.  have googled until i'm blue in face , cant find example of having specific issue.

due past sql admin's understanding of backup procedures, inherated a large full , incremental backup file, 1,5 years of data.  this file 380gig , taking time backup , verify.  take let's 10% chunks pick point in time can begin correct backup procedures.     there no mechanism delete specific backup out of file.  have set retention period when backup, , allows backup overwritten in backup set.  recourse start fresh backup set, , provide retention period allow backups overwritten when expire.   see   http://msdn2.microsoft.com/en-us/library/ms186865.aspx SQL Server  >  SQL Server High Availability and Disaster Recovery

hi all, i in need create animation sample application i'm working on. requirement described below let me first i've seen similar examples on web none fit needs. instead of copy & pasting till works i'm looking resources me learn how make such animations myself. have programming experiance silverlight haven't ventured in design realm yet.  the requirement have screen information (in case it's chart in grid) , when button clicked i'd disable control , on top of overlay container (e.g. grid) has additional data. background grid disabled , overlaid 1 have (semi)transparent background. i'd action accompanied page turn-like effect. is, top overlay layer gradually fold out on top of existing ones (similar engineers used when super-imposing blueprint on top of another). examples of great i'm looking resources me learn how action myself. i'm not sure start?  thanks in advance, stefan  oh thought wanted learn anatomy of page flip

i have missing something, please help. 1 using system.collections.objectmodel; 2 using system.linq; 3 using system.collections; 4 using system.collections.generic; 5 using system; 6 7 namespace dashboard.helpers 8 { 9 public static class observablecollectionextentions 10 { 11 12 public static observablecollection<t> toobservablecollection( this ienumerable<t> collection) 13 { 14 //construct 15 observablecollection<t> returnvalue = new observablecollection<t>(); 16 17 //populate 18 foreach (var item in collection) 19 { 20 //returnvalue.add(item); 21 } 22 23 //return 24 return returnvalue; 25 } 26 27 } 28 }  error:   the type or namespace name 't' not found (are missing using directive or ass

hello,       work medical office , experiencing issues sql management studio , after extensive google search have been unable find solution. trying integrate piece of medical equipment running windows 7 sql server management studio installed. according vendor need logged in under local account came machine. per instructions launch sql server management studio , connect database. works fine. right click security/ new/ login. problem strikes. asking me enter our domain , username object box. unable find our domain under locations , manually entering path not allow object found either. does have insight on how can pointed @ our domain , able add domain user need? any , appreciated. thanks. you must join domain (or domain trusted existing domain) before can add domain user login. windows has able contact domain active directory in order figure out domain user is. sql server has sid (security identifier) of domain user. i presume can connect sql server. type of l

all,   i have newbie/general questions. here goes:   is there way limit indvidual's access (say customer - off site) allow them view bug reports in tfs. not want allow them see sharepoint or have kind of access tfs - viewing reports.     thanks, aa- hello,   you can restrict access reports using security of reporting services. open http://server_name/reports , there should see list of tfs projects , here can allow and/or restrict access.     ninoslav rasinec applicationaspect.com Archived Forums V  >  Team Foundation Server - General

i have work item type in process template setup this: <field name="project name" refname="mycompany.common.projectname" type="string">         <readonly not="[project]\project administrators" /> </field> but when try upload process template following error in log: exception message: tf248001: have specified project-scoped group, '[project]\project administrators', not allowed global list or global workflow defined project collection. remove reference specified group. (type provisionvalidationexception) my field not global list or part of global workflow, i'm not sure why i'm getting error. if remove readonly field process template uploads fine. but, can load specific work item type manually without problems team project. any idea why it's problem loading when done part of process template upload? this tfs2010. thanks. hi anthony, you need install tfs sp1. 1 of issues fixed this

i started getting errors vso/vsts azure cloud service build.  i many of these types of error: 2015-12-17t22:02:26.7346781z ##[error]c:\program files (x86)\msbuild\microsoft\visualstudio\v12.0\windows azure tools\2.7\microsoft.windowsazure.targets(2787,5): error msb3021: unable copy file "c:\a\1\s\src\gameplanwebrole\.\tsjs\app-workspace\workspace\workspace.js" "c:\a\1\s\src\gameplanazure\obj\release\gameplanwebrole\c:\a\1\s\src\gameplanwebrole\.\tsjs\app-workspace\workspace\workspace.js". given path's format not supported. 2015-12-17t22:02:26.7356784z      2>c:\program files (x86)\msbuild\microsoft\visualstudio\v12.0\windows azure tools\2.7\microsoft.windowsazure.targets(2787,5): error msb3021: unable copy file "c:\a\1\s\src\gameplanwebrole\.\tsjs\app-workspace\workspace\workspace.js" "c:\a\1\s\src\gameplanazure\obj\release\gameplanwebrole\c:\a\1\s\src\gameplanwebrole\.\tsjs\app-workspace\workspace\workspace.js". given path's

hi, in dataflow put data set recordet destination use dataset in controlflow. in controlflow have query table , result set should append same recordset object variable.but in control flow if give same object variable lose old dataset. i need both data set (from data flow , control flow) in 1 object variable.after should use foreachloop container. hi - in case, use 1 data flow task have 1 flat file connection flat file data - add derived column hardcoded value of "1" an oledb connection query database single value - add derived column hardcoded value of "1" do not add precedence constraint between these 2 items add merge join take inputs both of them and  join on 2 derived columns take output fropm teh merge join , push nto ado destination rgds geoff ---------------------------------------------------------- mark answer if resolves problem or "vote helpful" if find helpful.

hi, have stored procedure returns 3 items, id, begindate , enddate.  on report have 3 parameter 1 id, , 2 dates.  want select id , in data begin , end date id date parameters. it working when form loads becouse of default value of id parameter but when select different id not change value of data parameters. any idea why? thank again.  select id, begindate,  enddate  where id = (@id)  and begindate = (@begindate)  and enddate = (@enddate)    if have multi selection use in     select id, begindate,  enddate  where id in (@id)  and begindate in (@begindate)  and enddate in (@enddate) you can reference this  http://msdn.microsoft.com/en-us/library/aa337498.aspx SQL Server  >  SQL Server Reporting Services, Power View

i'm hoping has seen before , can me resolve weird issue. we using visual studio 2010 , tfs 2010.  using legacy msbuild script upgradetemplate. in build script, using solutiontobuild elements below.  have lot of them, , contain mix of c++, c++/cli , c# projects.  of our solution files have been set mixedplatform|release configuration.     < solutiontobuild   include = " $(buildprojectfolderpath)/../../version 2012.0 cycle/util/groups/util.sln " >         < targets ></ targets >         < properties ></ properties >     </ solutiontobuild > i have set configurationtobuild below solutiontobuild itemgroup:      < configurationtobuild   include = " release|mixed platforms " >          < flavortobuild > release </ flavortobuild >          < platformtobuild > mixed platforms </ platformtobuild >       </ configurationtobuild > however, in our last build, found assembly built

hi,   i creating custom data flow component , want access the variables collection   here code: dim vars as variables variabledispenser.getvariables(vars) variabledispenser.lockoneforread( "logid" , vars)  // <- gives error, see below dim var1 as object = vars(0) vars.unlock()   when try run ssis package contains custom component, fails @ run-time following error: error: 0xc0047062 @ data flow task, stat count [246]: system.invalidcastexception: unable cast com object of type 'system.__comobject' class type 'microsoft.sqlserver.dts.runtime.variables'. instances of types represent com components cannot cast types not represent com components; can cast interfaces long underlying com component supports queryinterface calls iid of interface.   any idea causes , how fix?  appreciated. thank in advance.   peter   try instead:   code snippet dim vars as variables variabledispenser.lockoneforread( "log

we have following.  live / dev / test          ---     environments live , dev work intended sql reporting services 2008  -      running sharepoint 2007 sp2  in integrated mode.    test, mirrors live , dev. has issue when trying use trusted account in central administration integrate reporting services. error if use windows authentication works. error below suggested troubleshooting have gone through our sql team link take recommend step trouble shooting.  5.3 “an unexpected error occurred while connecting report server. verify report server available , configured sharepoint integrated mode”  http://msdn.microsoft.com/en-us/library/ee384252(v=sql.100).aspx we can see there access issues on reporting logs. library!reportserver_0-4! 1344!05/24 /2012-16:5 7:43:: e error: throwing microsoft.reportingservice s.diagnost ics.utilit ies.access deniedexce ption: , microsoft.reportingservice s.diagnost ics.utilit ies.access deniedexce ption: permissions grante

hello, i executing stroc proc using execute sql task . passing 2  parameters follows connection: ole db sqlstatement  :   exec sp_updatereportlog ?,6 bypassprepare : true   the parameter mapping is follows: variablename      direction      datatype        paramname  paramsize user::sourcefile  input          nvarchar       0               -1 when execute task recieved following error. error: string or binary data truncated. [execute sql task] error: executing query "exec [dbo].sp_updatereportlog ?, ?, 6 " failed following error: "the statement has been terminated.". possible failure reasons: problems query, "resultset" property not set correctly, parameters not set correctly, or connection not established correctly. the variable user::sourcefile size has value of 110 char lenght, combined path + filename. did regression testing truncating file name 1 until executed sucessfully @ 100.  seems default parameter size of -1 can handle

i hoping can challenging import text file sql server. have text file has data represent new table throughout. in between each table header , footer, there simple text data can imported columns , rows. possible import text file creates new table @ each table trigger, , puts information between table start , stop text table. sql server have tool complex etl processes , ssis = sql server integration services . it's included in sql server standard , higher tditions. the tool creating ssis packages free available @ download sql server data tools (ssdt)  and if wouldn't have visual studio it install "vs integrated shell" olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Data Access

  i want create powerpivot excel spreadsheet can archived.  definition of archiving turning off capability refresh datasources allow people still manipulate disconnected data.  in addition, save copy of the powerpivot excel spreadsheet new spreadsheet refresh capability datasources.   the answer should work with and without sharepoint. (note: create powerpivot reports preserve period data , can copied current period it can dynaically updated new data , archive when done.) maybe bit simplified if use username/pw datasource users right credentials able upate data in general data "disconnected", still copy file , refresh if have right credentials though, never able manipulate data directly in powerpivot option think of load data excel spreadsheet/table , use linked tables import powerpivot can remove data-connection excel , "disconnected" , can manipulate data hth, gerhard - www.pmone.com -

hi, i created business application , second silverlight application. when set ria services link point business application web project error resources not found in silverlight application. error 67 the type or namespace name 'resources' not exist in namespace 'nevells.framework.web' (are missing assembly reference?)  is there special need make work? thanks in advance hi, i guess need add link to the web projects's resources/registrationdataresources.resx , resources/validationerrorresources in new added silverlight application  Silverlight  >  WCF RIA Services with Silverlight

all of sudden 1 of builds (which takes 1 minute 10 minutes , still going.  i decided stop build.  after build agent stopped working.  i restarted build service, tfs background service, controller, , agent.  my controller shows little green arrow indicate it's go.  however, agent has little red square in red circle though says it's started.   i following exception: dev agent' had exception:  exception message: there no endpoint listening @ http://tfs.corp.epnet.com:9191/build/v3.0/services/controller/2 accept message. caused incorrect address or soap action. see innerexception, if present, more details. (type endpointnotfoundexception) the innerexception is: exception message: unable connect remote server (type webexception) exception stack trace:    at system.net.httpwebrequest.getrequeststream(transportcontext&amp; context)  at system.net.httpwebrequest.getrequeststream()  at system.servicemodel.channels.httpoutput.webrequesthttpoutput.getoutputstre

i doing integration of reporting services 2008 (sharepoint integrated mode) sharepoint 2007. both servers sharepoint server , reporting service running under same domain in different servers. i able create & deploy reports ssrs server , able view reports sharepoint server. however, throwing below message in case if try access report client-machine (a machine same domain). able login sharepoint web app same user report not working. "an unexpected error occurred while connecting report server. verify report server available , configured sharepoint integrated mode." please advice how can address issue. hi, choose either of following approaches avoid error: on computer hosts report server, continue run report server service networkservice , add built-in account, such nt_authority\networkservice wss_wpg windows group. -- or -- configure service account run under domain user account follows: start reporting services configuration tool , connect report serv

hi,   have 2 table pull data navision financial system,1 detail ( name "income statement") , 1 total account only. foe example, account 11000~11880 cash account , 11898 11000~11880 total. detail table include 11000~11880, , total table has 11898 only. for now, in tabular, can create measure like #11898 := calculate(sum([net charge]),   filter('income statement', 'income statement'[acctno] >= "11000" && 'income statement'[acctno] <= "11890")) . how create "calculate column" in total table of column 11898  ? thanks!! james liang hi james, in scenario, this many 1 relationship, supposes have column link detail table , total table. can create calculated column in total table like: = calculate(sum(detail[net charge]),filter(detail,detail[linkcolumn]=related(total[linkcolumn]))) regards, simon hou technet community support

hello, i'm new ssas , have run issue way measure distributed among attribute.  essentially, have fact table of attendance records contain studentid, year , schoolid keys.  there absense type code , value of how of day student missed (0, .5 or 1) on day.   now, apologize if can't describe issue propery, here best shot.  the individual entries in fact table (studentid, year , schoolid) seem rolling specific attendance dates in manner can't figure out nor want. a query on underlying data such as select attendcode, attenddate, sum(absense) attend_oos_detail  studentid = 'xxxxxx'  group attendcode, attenddate order attendcode will return 46 distinct rows data distributed expect, when view deployed cube, end 46 days rolled 4 distinct days.  worse, of type 'o' codes rolled type 'a' codes (i've limited 2 simplify debugging process).   looking @ detail of records ordered date, totals cube can reached summing between dates, re

i have designed ssrs chart. on horizontal axis has show each month(jan-11,feb-11,mar-11,april-11) the report shows number of records per each month in form of chart. but in x-axis see labels skipped (/ jan 2011 (8records) /[month label not shown series of records shown] (6records) / march 2011 [10 records] / [month label not shown series of records shown] [12 records] ) trying find option in properties disable skipping of labels couldn't find it.   please me solve this.   thanks, tom. variable auto interval has made true. got it! thanks! SQL Server  >  SQL Server Reporting Services, Power View

is possible configure log shipping between sql server 2005 , sql server 2008?  originating database , server (the primary database) sql server 2005, , receiving database , server (the secondary database) sql server 2008. hi sqlscript,   is possible configure log shipping between sql server 2005 , sql server 2008? if primary database in instance of sql server 2005 , secondary database in instance of sql server 2008, possible. meanwhile log shipping sql server 2008 sql server 2005 not possible.   this because log shipping implemented via backing , restoring database , transaction log primary database secondary database. since backup of database , transaction log restored previous version of sql server later version of sql server, possible implement log shipping sql server 2005 sql server 2008. meanwhile possible restore backup of database , transaction log later version previous version of sql server, log shipping sql server 2008 sql server 2005 impossible.   if u

after installing tfs 2012 build agent on 1 of our machines (no vs 2012), launching vs 2010 gives following error: the 'microsoft.teamfoundation.client.serviceshostpackage, microsoft.visualstudio.teamfoundation.teamexplorer, version=10.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a' package did not load correctly. the problem may have been caused configuration change or installation of extension. can more information running application /log parameter on command line, , examining file 'c:\users\[username]\appdata\roaming\microsoft\visualstudio\10.0\activitylog.xml'. do need re-install vs 2010? running vs 2010 cmd prompt /log option gives following relevant message: could not load file or assembly 'microsoft.teamfoundation.client, version=10.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a' or 1 of dependencies. system cannot find file specified. thanks debasish das hi das,  thanks post. i suggest repair vs 2010 on build