Lun

hi, have data on device  and have data in sqlserver database. i want compare data on device data in database make sure both same afterdownloading what best way that. how can implement checksum on sqlserver tables compare checksum of data on device tables. make sure both data same. i want same compare tables have synchronized , not. at first wanted use build in sql command create checksums on columns , combine them checksum whole table found out compact sql server doesn't support that. then serialized rows of table big string , ran checksum on that. found out, reason xmlserializer.serialize(...) produced different output on cf on full framework. (for example framework put single objects "objectlist" tag whereas cf didn't). so i'm interested in solution well. tobias SQL Server  > 

the vb.net exception is: "incorrect syntax near '%folder containing%'." select   tblbase.*, tblfolders.itemid  as  [folder itemid], tblfiles.itemid  as  [file itemid], tblfiles.[file path], tblurls.itemid  as  [url itemid], tblurls.url, tblfaqs.itemid  as  [faq itemid], tblfaqs.question, tblfaqs.answer      from  tblbase  left   outer   join  tblfolders  on  tblbase.itemid = tblfolders.itemid  left   outer   join  tblfiles  on  tblbase.itemid = tblfiles.itemid  left   outer   join  tblurls  on  tblbase.itemid = tblurls.itemid  left   outer   join  tblfaqs  on  tblbase.itemid = tblfaqs.itemid      where  (tblbase. name   like   '%folder containing%'   or  tblbase. name   like   '%foo%' )  or  (tblbase.description  like   '%folder containing%'   or  tblbase.description  like   '%foo%' )  or  (tblfaqs.questionlike  '%folder containing%'   or  tblfaqs.questionlike  '%foo%' )  or  (tblfaqs.answer

i have sis package trying run send file ftp site. when in bids can run package , runs without error. when deployed package set security not save sensitive data , saved package store. when try run package integration services error password not allowed. i've tried adding user name , password ftp connection string , still receive same error. what missing. thanks in advance wayne the password dropped under protection level error. you need config file ftp session password parametrized (fed config or in script task: http://wannabesoftwareengineer.blogspot.ca/2009/03/setting-ftp-password-from-external.html) arthur my blog SQL Server  >  SQL Server Integration Services

we have 3 applications each on different website need interact set of 3 databases varied permission , need make sure set permissions correctly.   we’ve identified 3 levels of permission/accessibility , have separated websites 3 separate integrated app pools.  each integrated app pool has own automatically-created windows account , allows use windows authentication access sql server greater security , convenience.  windows accounts follows: usersite – read access 2 live databases , write log. testsite – version of live data applications, on test website staging upgrades; needs have read/write permission. maintenancesite – used internally perform backup/restoration various test sites.   needs able backup sites , restore test sites.   we’re assuming when restore live data test system keeps permissions source , not destination permissions.   is correct?   if so, best way automate changing permissions after restore? permissions want live databases:  (are these correct fixed da

hello, i planning install sql server express 2012 ( ex-denali ) on windows 7 home premium (64-bit ) , surprised document : http://www.microsoft.com/download/en/details.aspx?id=29062   it seem not existing "full" edition including database engine, sql server management studio express, full-text search , filestream support , reporting dervices , localdb. have these features, thinking edition advanced services correct edition, don't see localdb feature installed edition ( if have correctly understood document, exists edition ( 3rd 1 ) including database engine,ssmse, localdb, not full-text , reporting services. does mean there no real full edition ( last 1 have separatet install localdb ) ? maybe document missing indicate advanced services including localdb. if document correct, maybe ( if possible ) , please , is possible sql server express team include localdb in sql server express 2012 advanced services ? i have been insterested the  ( clear , gripping )

a question memory management in querying an ssas server.   it happens users make huge queries on unoptimized elements of cube. the result on our server is memory usage grows fast, and far beyond totalmemorylimit specified on server.   especially, specified 2.6gb totalmemorylimit, , performance graphs have show memory usage service exceeded 4.5gb for of these bad queries ! as result, paging explodes, , put system on low-memory conditions... since service runs on shared environment, causes troubles other services running there...   i understand momory limit kind of soft limit can exceeded, not !!! i prefer bad queries are automatically killed service, replying not have enough memory complete...   is there way configure service way ?   hi if haven't have @ following article http://www.microsoft.com/technet/prodtechnol/sql/2005/ssasproperties.mspx in particular following server properties   for query timeouts servertimeout   memory clean up tot

hi all, how versioning of media files viz wmv, mkv videos format etc. if possible, size limit? after check in multiple times tfs going store seperate video or stores delta changes. thanks in advance. regards, santosh kotagi there no enforced size limit in  tfs source control repository from know. there limit on work item attachment file size (4mb), can changed using http://msdn.microsoft.com/en-us/library/ms400780.aspx. not sure tfs store large files. while  tfs designed handle large files gracefully, have problems network bandwidth when upload/download files. not mention, when store large video files in tfs , try request  historical versions of large files, you're going make server apply delta chain revision, resource intensive. now, imagine multiple users doing same thing... slow down tfs server significantly. Archived Forums V  > 

hi  i have been asked basic question. use tool should have install sql 2012 , office 2010. i'm using sql 2008 , office 2007. please guide/help me. thanks mohd shams hello, powerpivot, please read following articles: http://blogs.office.com/b/microsoft-excel/archive/2009/10/23/using-powerpivot-with-excel-2010.aspx http://www.bing.com/videos/watch/video/introduction-to-powerpivot-for-excel-2010/10tsptgbo (set of videos) http://msdn.microsoft.com/en-us/library/hh231671.aspx powerview, please read following resources: http://www.bing.com/videos/search?q=how+use+%22power+view%22+sql+server&mid=7bfe97f4124e06191ae67bfe97f4124e06191ae6&view=detail&form=vire4 http://msdn.microsoft.com/en-u s/library/hh231687(v=sql.110).aspx hope helps. regards, alberto morillo sqlcoffee.com SQL Server  > 

hi. looking using streaminsight on project @ work , have read lot of articles i've not found details around hardware requirements this. have seen minimium set-up documents, sort of after real life examples. for example if trying process events on hour between 10,000 , 20,000 events. keeping in memory process - take? if on day. is there considerations when server fails? can recover of events (expect re-processing) or mirroring server? sorry if these aren't technically correct, getting head around concepts. thanks in advance ian actually, don't have add powertx125 said .. he's absolutely correct. 10k-20k events/hour that's pretty easy streaminsight handle. how cpu need depends on complexity of analytics , how many output sinks have. how memory need depends on of same payload size. said, streaminsight pretty efficient when comes memory usage. as raw throughput ... little update txpower's numbers ... i've gotten 150k events/second throughput o

hello all, i need in, deleting duplicate rows using composite key ( 2 columns) i trying read csv file data sql server table getting data type mismatch error. initally haing excel data file, has duplicate data have saved file .csv. have create composite key 2 columns , using combination duplictes should eliminated sample data col 1                                                                                               col2 row 1   asset disposition                                                                             asset disposition row 2   asset disposition                                                                             asset disposition row 3   capital contributions                                                                       capital contributions row  4  capital contributions                                                                       capital contributions row 5   certificate of compliance                     

i trying issue simple delete statement deletes 2 rows table of 444 rows , runs forever, wait type shows in activity monitor as  pageiolatch_sh.   any suggestions?   thanks satya start collecting performance counters disks in perfmon.  want collect following counters:   physical disk: %disk time average disk queue length average disk read queue length average disk write queue length memory: pages/sec sql server memory manager: memory grants pending   you have bottleneck somewhere in memory or io , counters should show is.   edit:   also have @ erlands sommarskogs aba_lockinfo:   http://www.sommarskog.se/sqlutil/aba_lockinfo.html         SQL Server  >  SQL Server Database Engine

i not getting around digging entity framework. have basic model contains following entities:  person customer (inherits person) employee (inherits person)  i add person database: dim dtc as new myentitymodelcontainer dim n as new person   n.firstname = "john" n.lastname = "doe"   dtc.addtopeople(n) dtc.savechanges() now how tell john doe employee? know beginning: dim dtc as new myentitymodelcontainer dim n as new employee n.firstname = "john" n.lastname = "doe"   dtc.addtopeople(n) dtc.savechanges() but since have john in database already, want employee, how that? then on top of that, john both employee , customer? what doing, have database filled "persons" , if customer or employee seperate tables "customer" table , "employee" table. have 1 pool choose "persons" know how customers , employee's

tfs project server  integration configuration appears ok – settings verified running tfsadmin projectserver following switches: /getregisteredpwa /getmappedcollections /getmappedprojects /getmappedworkitemtypes /downloadfieldmappings n ote: tfs server renamed after pwa registered before collection mapped . however when try verify data synchronization, ms project client, n othing seems happening: i've opened published enterprise project pwa uri in gantt chart view, i've added 2 columns: "publish team project" , "work item type (tfs)" – ( should 2 nd  column have drop down support ? – first does) i pick task , "publish team project" select "yes" , "work item type (tfs)" type "task" (definitely mapped work item type) i select file > info > publish (i select "do not create site @ time" - do need create site ?) – press publish – see "publish completed successfully" in status bar

i import data csv file. my database have primary key. pk1, pk2, data. my csv sample data looked below if open text file: "data 1", "data 2", "data 3" "data 1", "data 2 ", "data 3" when run import task, prompt me duplicate primary key because take data 2 , without spacing same data. i had set text qualified = " is there setting make different of data 2? thank you! hello calvin, dont set text qualifer,and data "",and use derived column companent.write below expression replace([columnname],"\"","") SQL Server  >  SQL Server Integration Services

can "scale-out deployment" option turned off can migrate ssrs databases enterprise edition standard?  after attached databases ssrs 2005 enterprise ssrs 2012 standard i getting error scale-out deployment not supported.  way around can migrate databases, bringing reports , report subscriptions new ssrs instance? lee markum hi lee, from document , can know scale out deployment feature supported in enterprise , business intelligence editions in sql server 2012. in order fix issue, can refer similar thread post ben: http://social.msdn.microsoft.com/forums/sqlserver/en-us/8eebf25f-2c40-40d3-9bb7-bb481fdafc12/is-this-a-scaleout-deployment-?forum=sqlreportingservices hope helps. thanks, katherine xiong katherine xiong technet community support SQL Server  >  SQL Server R

i have 6 different team projects own project portals. each 1 have wiki lot of information they're doing. how can search between these project portals? when search for: "outsourcing" results team project a, team project b , team project d? thank's andré maldonado hi maldonado,   as these issues related sharepoint products , technologies , suggest post @ http://social.msdn.microsoft.com/forums/en-us/category/sharepoint  for quicker , better response, sharepoint experts live in. best regards john qiao please remember mark replies answers if , unmark them if provide no help. welcome all-in-one code framework ! if have feedback, please tell us. Archived Forums V  >  Team Foundation Server - General

canot create subscription please me i error code is: title: connect server ------------------------------ cannot connect 89.19.13.138. ------------------------------ additional information: sql server replication requires actual server name make connection server. specify actual server name, '94de80acd308'. (replication.utilities) ------------------------------ buttons: ok ------------------------------ please check links my server info : http://www.tolgasimsek.com/11.jpg and error screen : http://www.tolgasimsek.com/22.jpg this can happen when publisher or subscriber hostname has been renamed @ point. on publisher , subscriber execute this: select @@servername on both publisher , subscriber execute this: select * sys.servers also, on both publisher , subscriber execute command prompt: hostname you should see mismatch in names.  if so, drop publication , disable distribution.  execute sp_dropserver , sp_a

we're noticing error of " this page has encountered critical error. contact system administrator if problem persists. " when selecting "view project portal" visual studio 2008. any ideas? also, ran best practices analyzer , says not part of " site administrators " group. how add myself group? there nothing specified errors in servers event log. please advise found answer problem guys. needed update web.config comment out few lines. found answer here:   http://scrumforteamsystem.com/cs/forums/4033/showpost.aspx   apparently authentication in subdirectories of website interferes.   it says to modify scrumforteamsystem\web.config, commenting out line 160 <!--            <authentication mode="windows"/> --> and line 197: <!--   <trust level="full"/>   <identity impersonate="true"/> --> in scrumforteamsystem\web.config the portals seem working again. thanks

why need use select 1 table tb1.col1= tbl2.col2? do? hello, that's wrong sql statement, because there not tbl1/tbl2 in clause, statement raise error. olaf helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * wenn ich denke, ist das ein fehler und das beweise ich täglich blog xing SQL Server  >  SQL Server Reporting Services, Power View

i have been experiencing issues running queries on our sql server. i've been getting linked server null errors when using opendatasource open , import excel file. long story short, has been happening quite time, has gotten worse of late. so, i'm checking more. while looking through performance counters, noticed following counter says there 24 active temp tables. sqlserver:general statistics:active temp tables    = 24 so, ran following query @ these temp tables. select  * from    tempdb..sysobjects where  name '#%' it of course listed 24 temp tables. had hexadecimal names starting temp table # sign. xtype = 'u' , had crdates spanning 5 days ago through today. refdate same crdate in cases. basically i'm wondering 3 things. is odd have many (24) active temp tables? can remove these safely? how tell process or script created these? also, there reference how use system monitor , performance monitor diagnose problems? instance, learning locks. how many locks

i have sp purges data multiple databases.   i’m running sp database named db100   i have try\catch goes was:   ------------------------------------------- begin try               delete       from   [db101] . [dbo] . [atable]       where xyz   delete       from   [db102] . [dbo] . [btable]       where xyz             …   end try   begin catch insert into [db100] . [dbo] . [log_table] ( stepnumber , description , desctype ) values ( 2 , error_message (), 'error' ) end catch   when try run code try not able catch error happened on db101 , db102 while code running on db100. any on how may catch error?   thanks adam, could modify erland's script can reproduce problem? the try / catch construct catches execution errors have severity higher 10 not close database connection (this bol), , not compilation ones. sql server allow create stored procedures referencing non existing tables be

hi all, i wanted know if can assign different colors different tabs in excel export of ssrs report. , if yes, how? thanks in advance! hi dipti s phadke, setting tab color functionality supported excel, having nothing ssrs. not allowed configure conditional colors in ssrs report, there no possibility achieve that. best regards, yuliana gu msdn community support please remember click "mark answer" responses resolved issue, , click "unmark answer" if not. can beneficial other community members reading thread. if have compliments or complaints msdn support, feel free contact msdnfsf@microsoft.com . SQL Server  >  SQL Server Reporting Services, Power View

hi, i have silverlight 4 solution using wcf ria services v1.0 sp1.  development done , in process of moving production environment. now, production environment load balanced.  1 of requirements load balancer there resource in each website can "pinged" make sure site alive.  created new "ping.aspx" page , put in website hosts silverlight application , ria services.  good. however, site uses windows authentication , allow access application if user in roles.  controlled web.config here: <system.web> <rolemanager enabled="true" defaultprovider="aspnetwindowstokenroleprovider"/> <profile enabled="false" /> <authentication mode="windows" /> <authorization> <allow roles="isdevelopment, agent, superuser"/> <deny users="*" /> </authorization> </system.web> so first time tried hit ping.aspx page got login challenge , prompt

hello dbas trying migrate sql 2000 std. ed. database running in windows 2000 sql server 2005 std. ed. on windows 2003 server sdt. ed. configured merge replication immediate execution. , trying create same environment on windows 2003 , sql server 2005 sdt. ed. but, when select merge replication, says sql server mobile edition can subscribe it. kind of replication method should go achive task. & regards jack no, think there confusion. can subscribe version same or lower current version. mobile editions cannot act publishers instead allowed subscribed. you can set merger replication on sql 2005 std. without problems. if getting kind of error while configuring it, kindly post complete errror message. regards, deven ----------------------------------------- please vote if find of post helpful. SQL Server  > 

i have started facing issue while using tfs preview. not able add new team members project site or perform project related actions. throws exception :  buffer cannot null. parameter name: buffer because user id added project administration group contributors group, , contributors group not have rights perform admin related actions add user etc. contributor group overriding access rights project admin. troublesome thing me because, admin in project, , due exception not able remove user-id contributors group , perform other project related actions. has faced similar ?? in advance !! can email me  tfs url , live id @anj-2011@hotmail.com? also if have dev11 client, can run below cmd , send me output  tfssecurity /imx <email> /collection:https://<instance>.tfspreview.com/defaultcollection   regards, anjana mazumder Archived Forums V  >

sql 2008 r2 ok first off might confused. when enable db mail , go through steps, same thing if right click on job|properties|notifications| , choose actions perform when job completes email etc etc. part works fine. under assumption that's different , don't need selected if notify operator on maintenance plan itself. here have done. enabled db mail. setup account , profile. click send test mail , fine. profile public , defaulted. setup operators name , email. maintenance plan-modify-general-notify operator task. (one success , 1 failure) attached main db backup sql srv agent-properties-alert system- enable mail profile set database mail , chose profile prev created , restarted it. firewall turned off when run maintenance plan backup occurs attached notify operator success not.  test email db mail setup works fine though. what missing? check db mail log details of mail not coming. error in understanding thigns in details. regards, rohit garg (my

hi all, i know backup file size can smaller actual db size (i.e., mdf size + ldf size). in case observing huge difference.  my database size 16 gb out of 10 gb consumed mdf , 6 gb consumed ldf. when took backup, backup file size 1 gb!!!!! i skeptical whether doing wrong. please advice me. olaf right must compressed backup: to check if backup file compressed or not restore headeronly disk = 'path backup file'; looks column labelled "compressed". 1 = compressed, 0 = not compressed. if skeptical about backup file can verfiy whether sql database backup can read , restored: restore verifyonly disk = 'path backup file' if backup valid, sql server database engine returns: the backup set on file 1 valid SQL Server  >  SQL Server Manageability

hi guys, i have started project using linq sql , ssce. goes until realize ssce can run in full trust. linq sql planned support partial trust scenario. plans such support in sql compact edition? dany   hi dany,   thanks feedback. sql server compact 3.5 not support partial trust. logging feedback enabling partial trust in future version of sql server compact   regards   mr devesh anand SQL Server  >  SQL Server Compact

i'm having strange issue update statement appears closing encryption key, resulting in being unavailable further use same stored procedure. i've added debug code shows key open prior update , appears closed after. code i'm using along lines of shown below: -- -- encryption key opened @ point -- declare @keynamebefore sysname declare @keycountbefore int declare @keynameafter sysname declare @keycountafter int -- name of open key select @keynamebefore = key_name sys.openkeys print @keynamebefore -- count of open keys select @keycountbefore = count(*) sys.openkeys print @keycountbefore update table1 set col1 = encryptbykey(key_guid(@enc_key), rtrim(@data1), 1, hashbytes('sha1', convert(varbinary, @custkey))) col2 = encryptbykey(key_guid(@enc_key), rtrim(@data1), 1, hashbytes('sha1', convert(varbinary, @custkey))), table_key = @custkey -- name of open key select @keynameafter = key_name sys.openkeys print @keynameafter

how can programmatically associate changeset 1 work item in check-in policy's task? have carry out this? i believe cannot change association between changeset , work items in check in policy code; policy can access collection of associated work items through pendingcheckin.workitems.   cheers, eugene Archived Forums V  >  Team Foundation Server - Source and Version Control

  hi,   when access teamplain http://localhost:8888/admin  i not log in, maybe forgot user , password or maybe there default user, can tell me how can restore user , password or wich default user , password or how reestore it?   thanks team system web access does not use own user accounts, works existing team foundation server accounts. can add/remove accounts , change permissions user accounts through team foundation client, or through tfs utilities tfssecurity.exe (found in common7\ide folder under vs install on tfs server).   below link msdn article on managing tfs users , groups: http://msdn2.microsoft.com/en-us/library/ms252477(vs.80).aspx   regards, --nick Archived Forums T-U  >  Team Foundation Server - Team System Web Access

how change sql server cluster service account? how change sql server cluster service account? from sql server configuration manager. clustered servers changing service account used sql server or sql server agent must performed active node of sql server cluster. when running on windows server 2008 (in non-default configuration using domain groups), changing service account used sql server or sql server agent requires sql server configuration manager stop sql server taking resource groups offline. cheers, shashank please mark reply answer if solved issue or vote helpful if helped other forum members can benefit my technet wiki articles mvp SQL Server  >  SQL Server High Availability and Disaster Recovery

here interesting problem. inside of our team foundation server, have few 2003 projects. these projects have yet me converted , don’t know when will. though not invoke 2003 build inside of script. problem every time run script, ends in infinite loop , never seems end. doing wrong?   <? xml version = " 1.0 " encoding = " utf-8 " ?> < project defaulttargets = " desktopbuild " xmlns = " http://schemas.microsoft.com/developer/msbuild/2003 " > < import project = " $(msbuildextensionspath)\microsoft\visualstudio\v8.0\teambuild\microsoft.teamfoundation.build.targets " /> < projectextensions > < description ></ description > < buildmachine > sdlc </ buildmachine > </ projectextensions > < propertygroup > < teamproject > development_code </ teamproject > < builddirectorypath > f:\build_management\team_build </ builddirectorypath > <