Lun

hello all,   have written code , create library file microsoft visual studio 2008 , want call functions of dll stored procedure of sql server. how can thsi? you need catalog assembly sql server , define types and/or methods create function, create procedure, create type, etc. access them from your t-sql code. here's section of sql server books online shows how this. http://msdn.microsoft.com/en-us/library/ms131102.aspx cheers, bob beauchemin, sqlskills   SQL Server  >  .NET Framework inside SQL Server

hello all, i need create complicated calculated member similar sql statement “select in”. there 2 dimensions errors , products. each product assigned error or has no error. each product has amount. example, have errors e1, e2, e3 , n/a no errors , have 3 products p1, p2 , p3. instance have following situation: product error amount p1        e1    10 p2        e1    20 p3        e2    30 p1        e2    10 p1        e3    10 p2        e3    20 p2        n/a  20 p2        n/a  20 p1        n/a  10 and need see following in cube error amount failed amount total e1 30 120 e2 40 70 e3 30 120 n/a 50 120 amount failed amount each error. e1 these products p1 + p2 -> 10 + 20 = 30. e2 -> p3 + p1 -> 30 + 10 = 40. e3 -> p1 + p2 -> 10 + 20 = 30. n/a -> p2 + p2 + p1 -> 20 + 20 +10 = 50. simply- problem amount total. amount total sum of amounts of products exist on current level. example e1 following products assigned: p1 , p2. need find amounts p1 , p2 on levels. these 10 (p1 e1...

hello, i've got following problem: i have windows mobile application uses sdf database. every time change database structure (add new table, add column existing table) user have update database file (all stored data must synchronizet serwer). there way update database structure without data loss ? the ideal soulution script or small application updating sdf file ( converting old database file actual structure) may send user. thanks lot help. greetings! michał you use code in tool (open source) basis own tool - consider porting work on mobile device well, command lines not supported, other way of running on mobile required - maybe xml file command line, , output file - how sound? http://erikej.blogspot.com erik ejlskov jensen - please mark answer, if it. SQL Server  >  SQL Server Co...

hello replication folks , i have following annoying situation: -  transactional replication , network lately becomes shaky. - working fine until a network error happens ( link subscriber fails few seconds) , distribution agent reports error , attempts retry. - agent running since then  number of undistributed commands rises , never reduces unless agent restarted manually. this annoying behavior , the distribution agent seems doing doesn't , number of pending commands keeps piling up. when distribution agent restarted , see number  undistributed commands goes down quickly. anyone has explanation why distribution agent has restarted when status shows executing? , how avoid this. is issue code calculates number of pending commands ? i saw similar pots here : http://forums.microsoft.com/msdn/showpost.aspx?postid=811307&siteid=1 btw , subscriber sql 2005 sp2 on [windows server 2008 ] thanks this looks bug. please file connect bug , take look. ...

i have sql server agent job created scheduled data transfer task in 2 steps. have been testing , works fine except when click on start it, opens dialog prompt box. the dialog box lists 2 tasks (1 , 2)  in job  under heading "start execution @ step:" and has the "start" and "cancel" buttons enabled , "cancel" greyed out , have click start before start. question is: how can disable prompt. have not seen before in other jobs created in past. help pat pat pat, has been way quite while.   1. if job has 1 step, run immediately. 2. if job has more 1 step, prompt choose step. you can run by:  exec sp_start_job 'your job name' if @ parameters of sp_start_job, see it possible choose particular step start on command.  so, argue dialog implements choice command offers. fwiw, rlf SQL Server ...

i need add constraint various feilds in table. on executing following code incorrect syntax constraint. please see attached code all highly regarded r alter table [nop].[dbo].[product] alter column packsperlayer int not null constraint ck_product_packsperlayer default '0' go alter table [nop].[dbo].[product] add constraint [ck_product_packsperlayer] default '0' [packsperlayer] jon SQL Server  >  SQL Server Tools

hi, we have developed silverlight module (in form of .xap) that start selling , determining best way license it. we want price runtime such it's cheaper "light usage" , expensive "heavy usage". so, how define "light usage" , "heavy usage"? i see these factors reflect on "usage": - number of physical servers module gets deployed. - number of domains module gets used. - other factors? even above, not sure how might reflect "usage" of module. any input appreciated. thanks i think lot of depends on silverlight module "does". didn't address this, might difficult intelligent responses. Silverlight  >  Programming Silverlight with .NET – General ...

i have computer excel 2010 64 bits and i can't connect analysis services 2000  but in other computer with excel 2010 32 bits there no problem. problem need oledb provider 64 bits ssas 2000 is correct? darren correct. have no choice other using 32-bit client if need connect 2000. there 64-bit version of ole db provider it, ia-64 , not x64 -- that's not use either...   thanks, akshai -- posting provided "as is" no warranties, , confers no rights SQL Server  >  SQL Server Analysis Services

i've developed custom formatter component transform complex xml documents, , following error when trying use it: <notificationservicesevent>  <description>   the notification not formatted.  </description>  <context> <eventparameters>  <instancename>nhsdinstance</instancename>  <applicationname>nhsd</applicationname>  <distributor id>1</distributor id>  <distributor name>nhsddist1</distributor name>  <distributor work item id>4</distributor work item id>  <notificationclassname>nhsdvalidationnotifications</notificationclassname>  <notification id>7</notification id> </eventparameters>  </context>  <description>   request permission of type system.security.permissions.strongnameidentitypermission, mscorlib, version=1.0.3300.0, culture=neutral, publickeytoken=b77a5c561934e089 fail...

hi, i trying understand advanced lookup functionality in ssis. here actual scenario: dim_details ( lookup table ) ------------- first_name   | last_name   | middle_name   | addr1   |  state   | country | lno -----------   ----------     ------------    ------    ------   --------  ----- james           john          michael      abc st      ny        us       k1998ny23 mary            clarke        james        abc st      ny        us       k2010ny29 source excel file has values follows: excel file ( source file ) ---------------------- first_name   | last_name   | middle_name   | addr1   |  state   | country | -------...

i have table data in sql server want data goes access db import data sql accessdb. want automate data mean if suppose data added sql table data should reflect in access db. please let me know how automate , keep in sych access db.     hi rajashekar,   actually, in such situation, recommend use linked table in access retrieve data sql server. once modification in sql server , use access view content of table, retrieve data sql server immediately. used views in sql server.   meanwhile if have further question related access, recommend ask in access developers forum , specific support.   if unclear, please let me know. regards, tom li SQL Server  >  SQL Server Setup & Upgrade ...

one of our teams going use tfs , need export attachments tfs part of bulk work item upload? best way that? tia! hello funkey_flier, one clarification you, mean want use excel upload attachments respective user stories @ same time? based on understanding, don’t think possible upload attachments respective user stories in excel @ same time. however, can 1 one. in excel, click appropriate user story , click links , attachments button, , in links , attachments userstoryname dialog can attach attachments user story , publish tfs. if indeed want upload attachments respective user stories @ 1 time, can consider using tfs api so. thanks, vicky song [msft] msdn community support | feedback us get or request code sample microsoft please remember mark replies answers if , unmark them if provide no help. Archived Forums V  >  ...

i created build definition in visual studio online build visual studio solution.  several projects have signing enabled using strong name key, protected password (pfx file). when build solution following error: "cannot import following key file: xxxxxxxxxx.pfx. key file may password protected. correct this, try import certificate again or manually install certificate strong name csp following key container name: vs_key_xxxxxxxx". i know solution import certificate strong name csp (sn -i key1.pfx vs_key_xxxxxxxx), , works when building on server control.  how do when running build in hosted pool in visual studio online?  1 solution attempted add build step run batch script imports certificate , pipes keyfile password sn command, command fails message sn command not allow password piped in. how can implement build definition allow me build solution using hosted pool in visual studio online?  note have not used tfs or xaml build definitions befor...

hi there, i trying implement union/intersect in mdx, 1 have tried: select [measures].[canon number of openings] on columns ( select intersect({[job location].[hierarchy-county].[state].&[al]&[6].children},        {[job location].[hierarchy-county].[county].&[houston, al]&[al]&[6]}) on columns [licube_demo]) [calendar].[month].&[2011]&[7] this works fine same if try facing issue, select [measures].[canon number of openings] on columns from (select intersect({[msa].[msa name].&[metropolitan division]}, {[job location].[hierarchy-county].[state].&[oh]&[6]})  on columns [licube_demo]) error getting : query (3, 1) 2 sets specified in intersect function have different dimensionality.  is there other way can done?can please me out? thanks, aish i think add each member both sets: intersect({[msa].[msa name].&[metropolitan division], [job location].[hierarchy-county].[sta...

went watch on netflix, video works fine audio sounds strange, want know how can fix this? hi, could please elaborate little bit more on issue facing?  details problem helpful determin if 's issue form silverlight or netflix. you may try play videos in following links , check if these videos play same issue, these videos use sliverlight play. http://www.microsoft.com/en-us/showcase/details.aspx?uuid=3603e302-10f1-413e-8c9d-f1479e1ffe5f http://samples.msdn.microsoft.com/silverlight/samplebrowser/#/?sref=homepage if common issue every silverlight videos, suggest upgrade silverlight latest version. else may contact  netflix support assistance. thanks. best regards, qimin ding we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. ...

hello... i'm real new sql server express , need following.   i have 2 tables...   table 1: column emailaddress   table 2: column cust_id, emailaddress, firstname, lastname   i want search table 2 emailaddress, table 1 emailaddress, , if of email addresses in table 1 found in table 2, delete rows in table 2.   thanks, car54     delete table2 emailaddress in (select emailaddress table1)   madhu SQL Server  >  SQL Server Express

  hello anyone,   we have client still uses excel 2003 , analysis 2000 in data warehouse. complaining reports takes more day refreshed using excel while in owc (bi portal), takes couple of minutes. unfortunately, users needs report in excel.   one of things we've noticed on reports excel being used high utilization of cpu , memory , disk. problem quite annoying since report access shouldnt problematic.   i understand excel , owc sends different mdx query table difference shouldnt in form of hours. we've bought new server (2 quadcores , 8gb memory) , made dedicated olap server unfortunately, doesnt seem address problem.   any insights on happening or causing this?     regards, joseph SQL Server  >  SQL Server Analysis Services ...

  dear all i have 6 instance running on dev server.we configured instance use  processors,(using ent manager) but if ran procedure/query on database instance using 1 processor. what may cause.   sponguru hi, do mean run 1 specific query or stored procedure , inspecting how many processors used 1 query/procedure? the optimizer in sql server not pick parallelized plan (i.e. use more 1 thread) queries because not queries benefit parallelized plan. because there overhead synchronizing threads, reasonable amount of data or work has involved optimizer consider a parallelized plan. or saying during normal workload, lots of queries hitting sql server, 1 processor used? /elisabeth elisabeth rédei | www.sqlserverland.com | http://www.linkedin.com/elisabethredei SQL Server  >  Getting start...

  hello,   i've got question sql server agent account. i'm having issue running job 'myself'. need run job domain\my account due fact account has security access folder on different machine. sql agent running different account. when try , change owner of job account following error:   the job failed.  unable determine if owner (domain\user) of job waiver_export has server access (reason: not obtain information windows nt group/user 'domain\user', error code 0x5. [sqlstate 42000] (error 15404)).   is there other fix issue other going services sql server agent (mssqlserver) , changing run using account?   thanks, phil not job owner, job step "run as" leave job owner alone.   SQL Server  >  SQL Server Integration Services ...

the database object contains member 'get_logfiles' returns nice collection of database's logfiles. can't seem find comparable member return collection of datafiles. if can point me in right direction, grateful that's because log files not reside in filegroups. check out filegroup property, contains collection of data files.     wesleyb visit sql server weblog @ http://dis4ea.blogspot.com SQL Server  >  SQL Server SMO/DMO

we are  facing issues in our application , database.earlier our application having front end classic asp, asp.net  , backend sql server 2000. migrated sql server 2000 to  sql server 2005  thereafter  problem started appliccation & database getting hang . facing issues of application & database getting hang during project  assignment team. if more 20 users login application time if edit assignment application , database hangs. code used  in asp page for  assignment team. <%  response.buffer = true  %> <!--#include virtual="/includes/admin_security.asp"--> <!--#include virtual = "/includes/db_con.asp"--> <!--#include virtual = "/includes/dbcon1.asp"--> <!--#include virtual="/error.asp"--> <%  field_names = split(replace(request.form("field_name"),"'","''"),", ")  field_id = split(replace...

hi is there anyway of generating report builder model data xml schema? we trying write our business layer using entity framework 4.0 (ef) , expose access data using ef , wcf. in other words, clients call wcf service internaly uses ef, returns data client using xml data (ef entities automatically serailise xml). so, need to "point" reportbuilder (sql server 2005) our wcf service layer generate model users can use ad-hoc reporting. possible? regards amir report builder 2.0 can work xml data sources. regards amir SQL Server  >  SQL Server Reporting Services, Power View

hi all, i new tfs 2013 & git have 1 query. when try pull repository using git pull getting error "timeout". i little bit in confusion why happening. please me troubleshooting steps , probable reasons of error. thanks help. hi vishwajeet,   thanks reply. please ensure can pull small file git team project correctly first.     for current issue, please try below command: git config --global --unset http.postbuffer or refer answer reply in post: http://stackoverflow.com/questions/6842687/the-remote-end-hung-up-unexpectedly-while-git-cloning we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Archived Forums V  >  ...

i have column in table xml. i'd pull out elements , attributes out of xml column. my table name is: reportdefinition my columns are: reportname, contentxml i'd have output follows: reportname,  element (from contentxml,  attribute (from contentxml) there may number of elements and attributes in contentxml column i'm not how create syntax extract value but know on right track: select x.y.value('local-name(..)', 'varchar(max)') parentelementname, x.y.value('local-name(.)', 'varchar(max)'), x.y.value('.', 'varchar(max)') @xml.nodes('//*[text()], //@*') x(y) john use cross apply against xml column shred it, eg declare @reportdefinition table ( reportname varchar(50), contentxml xml ) insert @reportdefinition values ('report1', '<report> <a b="c">d</a> <f g="h">i</f> </report>' ), ('report2', '...

hi guys, i have code writes on 3 variables.  dim arr() string     dim ch char()     dim delimstring string = ","     dim varlist variables     dim strbrand string     dim strbusinessdate string     dim strstore string public sub new()         ch = delimstring.tochararray()     end sub public overrides sub postexecute()         varlist             .vbrand = strbrand             .vbusinessdate = strbusinessdate             .vstore = strstore         end with         mybase.postexecute()     end sub public overrides su...

i have availability group, agname1 running 3 databases.   how connect it?  --by availability group name in ssms? if have created availabilitygroup listener able connect using listener name here useful links http://www.sql-server-performance.com/2012/managing-and-connecting-to-alwayson-availability-groups/ http://msdn.microsoft.com/en-us/library/ff877884.aspx http://msdn.microsoft.com/en-us/library/hh213417.aspx -sqlharry sqlharry blog SQL Server  >  SQL Server High Availability and Disaster Recovery

i unable stdevp function work.  query follows: select     stdevp(schedule_weight) expr1 from         order_start_steps_weights where     (schedule_weight_type = 1) when try execute query (from either bids or ssms) query gets changed to: select     count_big(schedule_weight) expr1 from         order_start_steps_weights where     (schedule_weight_type = 1) i should mention stdev function works fine if substitute stdevp function. needless say, there big difference between counting population , finding standard deviation of population. have hit bug?  in advance. steve wells     this has been address in http://forums.microsoft.com/msdn/showpost.aspx?postid=268240&siteid=1 cheers, dan SQL Server  >  SQL Server Tools ...

hello, is there way edit (customize) build template use custom activity when assembly of activity not in gac? in other words, can add assembly system.activities components without registering in gac? do need installing custom activity assembly in gac on building machine? machine running both controller , agent. machine running agent, need custom activity assembly installed then: in both machines, agent machine? thank you, regards, leo i found out solution. seems not required register custom action assembly in gac being able add visualstudio toolbox. however, if assembly isn't registered in gac, impossible drop item (that represents custom action assembly) workflow of build template. maybe placing assembly in 1 of locations windows search can solve issue well. not know, didn't try. regards, leo Archived Forums V  >  ...

hi have mdx query in linked tabel in excel. the headers prefixed dimension name. for example, date dimension dates.date.date shown header: "[dates].[hierarchy].[date].[member_caption]" in linked tabel in excel. is there way have 'date' header? i don't believe there can column names mdx not have feature of column aliases sql does. you fake hiding row 1 inserting new row above , typing own descriptive names in cells above query result.... http://darren.gosbell.com - please mark correct answers SQL Server  >  SQL Server Analysis Services

hi getting following error "sync failed exception "we have encountered issue in syncing data, sync group out-of-date. suggest delete sync group , recreate it."    more information, provide tracing id ‘66b30ae5-f170-4798-a960-9a252c60e31c’ customer support." please assist thanx deon hey deon, from error message, indicated sync group out-of-date. root cause there changes failed sync more 45 days result in out-of-date status. please provide sync group id our further investigation? regards, bowen Microsoft Azure  >  Azure SQL Database

i attempted download sql 2012 business intelligence vhd , while downloaded vhd 6 peta bytes! granted there lot of stuff on system requirements state 250gb optimal hd space needed. i got www.microsoft.com/betaexperience more info on blog post here   i able work on if knows what's or can point me actual file. thanks! love them all...regardless. - buddha that's file size being displayed in error message. had been corrupted. found article on web talking about exact problem download after over. go figure. when downloaded on wired instead of wireless able copy , got installed without hitch. check out comments section in blog post for guy had same issue , resolved using winrar unzip rather native zip utility. love them all...regardless. - buddha SQL Server  >  ...

i made simple codes follows:   1 using system; 2 using system.collections.generic; 3 using system.linq; 4 using system.net; 5 using system.windows; 6 using system.windows.controls; 7 using system.windows.documents; 8 using system.windows.input; 9 using system.windows.media; 10 using system.windows.media.animation; 11 using system.windows.shapes; 12 13 namespace sl4textboxbinding 14 { 15 public partial class mainpage : usercontrol 16 { 17 entitya theentity; 18 19 public mainpage() 20 { 21 initializecomponent(); 22 //txtinput.lostfocus += new eventhandler(txtinput_lostfocus); 23 this .theentity = new entitya() 24 { 25 = "the value" 26 }; 27 this .datacontext = this .theentity; 28 29 } 30 31 private void txtin...

hello, i trying retrieve last 3 periods current month (ie sept, oct, nov).  thinking lastperiods function might work, getting following error " the lastperiods function expects member expression 0 argument. tuple set expression used. "  here's code. select { lastperiods (3, tail ( nonempty ([week].[week].[week name]. members )) ) } on columns from [gmdsummary] maybe ?   select { lastperiods (3, tail ( nonempty ([week].[week].[week name]. members )).item(0).item(0) ) } on columns from [gmdsummary] SQL Server  >  SQL Server Analysis Services

hi guys, i have report drillthrough links other reports , when export main report excel, need export drillthrough reports separate tabs. possible? couldn't find solution anywhere.... if not possible, @ least able open drillthru report straight away in excel instead of browser when user clicks on link main report exported excel? thanks help!! quite desperate @ moment;-) thomas hi mike, i have been playing while , found out possible, posting solution future reference if struggles same thing. i nested drill-through reports main report , put page breaks in there - way exported separate worksheets. set visibility hidden when not exported excel, report has still 1 main page when executed in browser or exported pdf or printed. duplicated columns links , set action go bookmark (bookmarks pointing nested drill-through reports) other set. hid 1 set when exported excel , hid other 1 browser. works fine me! cheers, thomas ...

hello: i have configured asyn database mirroring a b , xyz target . mirroring working fine, when failover a b getting following error on transamission_queue " an error occurred while receiving data: '64(the specified network name no longer available.)'." and error message sql profiler run mirror server (b) target (xyz) "connection handshake failed. there no compatible endpoint. state 23." sql error mirror b database mirroring login attempt failed error: 'connection handshake failed. there no compatible endpoint. state 23.'. sql error xyz target service broker login attempt failed error: 'connection handshake failed. there no compatible endpoint. state 23.'. all required permissions, endpoints correctly configured on b (mirror server). i see no problem on target server & queue enabled. any appreciated. thanks sorry aaditya,  i cannot issue, dont have exp mirroring along sql broker. experts like  remus may...

 how write below xaml in code-behind window  (xaml.vb)    < canvas x:name= "layoutroot" background= "antiquewhite" > < button canvas.left= "100" canvas.top= "200" content= "good morning" ></ button > </ canvas >  thanks... hi http://forums.silverlight.net/forums/t/136732.aspx Silverlight  >  Silverlight Controls and Silverlight Toolkit

hi, i need restrict access cube data different ssas roles. have tried adding mdx expression ssas role not work. below details: 1) have cube single measure "sales" 2) have multiple dimensions "dimcustomers", "dimproducts" 3) create 1 ssas role per customer , configure role able query cube , see own tuples. 4) adding mdx expression "[dim customer].[customer key].&[1]" to          * ssas role/properties/dimension data         * ssas role/properties/cell data shows either no data or data customers in cube. need configure ssas role dimcustomer.customerkey=1 see tuples sales regardless of dimension selected. could please advise? best regards, alex   the problem goes away if add "[dimcustomers].[customer key]" is there easy way restrict user in ssas role reading other users cobe cells without adding "[dimcustomers].[custome...

how 1 switch between 'details' view , 'list' view when looking @ object explorer details page in sql server management studio? hi william you can use f8 to open /switch object explorer , f7 to open /switch object explorer details page or else can use view menu well arunraj chandrasekaran, mcts, author: sqlxpertise.com if found post useful, please " mark answer " or " vote helpful " SQL Server  >  Getting started with SQL Server

hi all.    have database running on sql 2000 sr4 , need upgrade latest version.  believe need goto sql 2008 interim step.  , suggestions appreciated.  regards,  that correct. can sql 2000 database , restore on sql 2005 sql server or above. , there , restore on sql2016. from https://msdn.microsoft.com/en-us/library/ms178513.aspx in sql server 2016, can restore user database database backup created using sql server 2005 or later version SQL Server  >  SQL Server Migration

i've inherited control runs fine in original solution on pc has ever had silverlight 3 installed. when compile own new solution errors on 2 attributes browsableattribute , designerserializationvisiblityattribute compile-time error complaining not exist in system.componentmodel a search on either attribute using latest sdk chm file shows nothing these attributes. similar search on these forums returns bunch of posts complaining how bad search facility here is! and yet have solution file happily compiles using these attributes. can point me can find information on these attributes in silverlight documentation (and dlls required - msdn tells me system.componentmodel in system.dll) , or give me clue why might compiling fine in 1 project , not in another? two of have eye-balled different references (between solution resolves references , 1 doesn't) , can see no differences - both pointing @ version 2.0.50727 dlls in framework\silverlight\v3.0 folder or sdks\silverlig...

hi, so have seen couple of blogs says there no direct migration of team foundation server 2008 2013. rather have 2012 , migrate 2013. so can me whether microsoft recommends direct migration 2008 2013 without additional steps in between. if so, how , share me links.  thanks & regards, srivatsa  hi srivatsa, thanks post. we cannot upgrade tfs 2008 tfs 2013 directly, please refer tfs 2013 upgrade requirements in document: https://msdn.microsoft.com/en-us/library/dd631912%28v=vs.120%29.aspx?f=255&mspperror=-2147217396 . so suggest upgrade tfs 2008 tfs 2012 first, upgrade tfs 2012 tfs 2013.   we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Archived Forums V  ...

hello, i using afterdropbuild target custom actions copy compiled output iis mapped folder. this looks something like this: code snippet < target name = " afterdropbuild " >    < makedir directories = " $(sourcelocation)\servicesweb\log " />        <!-- copy published files to iis folder -->    < createitem include = " $(binariesroot)\debug\_publishedwebsites\servicesweb\**\*.* " >      < output itemname = " filestocopypublished " taskparameter = " include " />    </ createitem >    < copy sourcefiles = " @(filestocopypublished) " destinationfiles = " @(filestocopypublished->'$(sourcelocation)  \servicesweb\%(recursivedir)%(filename)%(extension)') " /> </ target >     now thinking worst case - having solution in source control not compileable. if case iis website not run anymore, because afterdropbuild f...