Posts

Showing posts from July, 2010

Workflow designer in VS2010 Ultimate hangs

Image
hi     using vs 2010 ultimate sp1 on win xp machine. when open build process template , try open couple of sequences, designer hangs , have kill process. there seem lot of threads talking similar issue older versions couldn't find proper fix in of those. inputs great on this issue affects productivity lot. thanks sandeep hello sunny1704, thanks post. please take @ thread see if helpful you: http://social.msdn.microsoft.com/forums/en-us/windowsworkflowfoundation/thread/92adae45-f166-40cc-8647-aaa055b2fd30 in addition, think better if can recreate 1 thread on .net 3.0/3.5 windows workflow foundation forum . there more experts on forum, maybe can better support. 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

Schema clean-up

hi all, i have lot of shemas in db want delete unused shemas. question how can know schemas not in use or used several time ago? need information users use schemas , when last time when current  schema in used. br, sergejs we had user/schema direct relation in sql server 2000, in 2005 has changed: user-schema separation olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  Getting started with SQL Server

Oracel OLD DB provider for sql server

hi  i want request assiatance. i need setup linked server oracle ms sql server database, i have installed oledb priveder version: odac121024xcopy_x64 i getting error message setup environment variable. please advise how set them up. k hi huum,  if sql server system 64-bit, need download oracle x64 client. if sql server system 32-bit, need download oracle x86 client. 64-bit oracle client software in 11107_w2k8_x64_production_client.zip file. 32-bit oracle client software in win321_11gr1_client.zip file.  refer in following link http://sqlmag.com/sql-server/connecting-sql-server-and-oracle-using-linked-servers https://www.mssqltips.com/sqlservertip/1433/how-to-setup-linked-servers-for-sql-server-and-oracle-64-bit-client/ please click mark answer if post helped. SQL Server  > 

Required Registry Access not allowed in WIWA

  i "required registry access not allowed" when trying connect wiwa. i´m using windows authentication, app pool running under "network services". solution? hi rickard, seems wiwa trying access registry , can't, can caused because trust level isn't set full. i can't check but, can see trust level wiwa have in web.config? if isn't set full won't work. here have how can change ( http://msdn.microsoft.com/en-us/library/wyts434y.aspx ) it's strange doesn't work if installed correctly. let me check wiwa config when came home, , i'll tell how in case... thanks... Archived Forums T-U  >  Team Foundation Server - Team System Web Access

How to use Pivot control in SIlverlight 4.0

hi all, i new silverlight , saw pivot control today. excited on this. try out using collection created excel (which mentioned in demo). not able find videos/tutorials on how use/start using pivot control. can direct me in write path? thanks in advance... hi, i created collection using excel. first, please check link: http://www.silverlight.net/learn/pivotviewer/excel-tool/ and here relevant code samples: http://www.codeproject.com/kb/grid/pivotviewer.aspx http://www.silverlight.net/learn/pivotviewer/just-in-time-sample-code/ hope help.   regards Silverlight  >  Getting Started with Silverlight

How To Run XUnit TEsts in VisualStudio online Build

hi i want run xunit tests of project in visual studio online. have ? the normal visual studio test action doesnt execute tests. assume have set test adapter property don't know what ps: posted more details here: http://stackoverflow.com/questions/31511081/how-to-run-xunit-in-visualstudioonline-build hi, in order run xunit test in visual studio online, you have to specify the  path of package folder that contains xunit test adapter in "path custom test adapters" column of "advanced". reference: http://www.donovanbrown.com/post/2015/06/15/how-to-run-xunit-test-with-vnext-build regards, Archived Forums V  >  Visual Studio Team Services

Timeout Importing Database

now that visual sourcesafe , source control integration in ssms deprecated investigating using visual studio 2017 , ssdt solution develop sql server objects functions, stored procedures , triggers. note these additional objects added database delivered our supplier , not develop main structure of database itself. i have installed visual studio 2017, ssdt, created database project , integrated tfs , works fine. cannot intellisense work @ in query editor windows. have managed trace issue importing database schema sql server , seems 'execution timeout.' if example open sql server object explorer within vs, connect server , select refresh database on server gives me error. in ssms there no such issues. my questions then: can increase timeout value somewhere? how in general troubleshoot such issues? regards, stig regards, stig SQL Server

Replication

hi there,   i have replication between 2 sites 1 publisher , 1 subscriber when connection failed due network error update on the rows  that happened on publisher not update on subscriber. thank in advance ur help hi, if have got error during replication, suggest validate data @ subscriber matches @ publisher. if data validation fails, reinitialize subscription or manually update data. however, in case, key point find out root cause of issue , work around it. reference documents: validating replicated data http://msdn.microsoft.com/en-us/library/ms152758.aspx reinitializing subscription http://msdn.microsoft.com/en-us/library/ms152771.aspx if there more questions, please let me know. thanks. ***xiao min tan***microsoft online community*** SQL Server  >  SQL Server Replication

How to use log file?

hi,  have read .ldf log file holds transaction related information. how see transactions made through this? i mean query have write analysis on this if you're hoping see formatted set of results select/insert/update/delete statements have been run on database, i'm afraid you're going disappointed. transaction log internal component of sql server , stores information requires maintain transactionaly consistency. i haven't used 3rd party tools long time i'm not sure outputs more give "meaningful" results. also, remember depending on recovery model , your backup solution, current transaction log may not hold information anyhow truncated on backup/checkpoint. every day school day SQL Server  >  SQL Server Database Engine

BCP utility uploads 0 rows to SQL Server Azure

bcp azure_db.dbo.db_table in calendar_dates.txt -f  ../../../scripts/format_files/calendar_dates.fmt -f 2 /s tcp:azure_server /u username@servername /p password when issue command through powershell prompt, following response: starting copy.. network packet size 4096 clock 546 ms 0 rows copied. when @ table in azure, there no rows reported.  i tried removing entries in text file leaving first 2 lines, no avail. if input file name wrong or format file name wrong, or first  line indicating sql server version in format file wrong, appropriate error message returned bcp.  with correct parameters, or seems, no error reported, yet nothing happens.  anyone seen this? just figured out problem way bcp interpreting line terminating characters.  notepad says routes.txt, call "bad-file" has no line terminating characters , looks this: route_id,route_short_name,route_long_name,route_desc,route_type,route_url 1-184,1,,,3, 2-184,2,,,3, 4-184,4,,,3,  5-184,5

Visual C# 2008 express edition error connections to sql server files require (*.mdf) require sql server express 2005...

i have ms sql server 2008 installed before install ms visual c# express edition. when try create database through c# using project -> add new item-> server based database i error connections sql server files (*.mdf) require sql server express 2005 function properly. please verify installation of component or download url : http://go.microsoft.com/fwlink/?linkid=49251 does means ms visual c# 2008 express can work sql server express 2005 only? shall fix error. thank you hi daboy regino,   thank question.   this behavior design. when add database file through solution explorer ->my_progect -> add -> new item…, visual studio try use feature "user instance" enabled in sql server express edition, if sql server express not installed on local machine, error raised.   if want use other sql server editions, specify server name , database name in connection string, more detailed information connection string, please refer below link: http://www.c

Find Duration of a particular article

Image
i have merge publication has on 100 articles , taking few hours push snapshot, tht total database size on 2gb not data getting transferred, 1 of tables has varbinary(max) column , suspect may culprit long duration.  using default agent profile verboselevel=2 can see duration various activities @ high level (initialization, schema changes, uploads, downloads) cannot see duration of downloads per table (picture below).  does know if information stored anywhere can query , longest duration of downloading per article?  potentially different verbose level may give me information convert dts ssis | document ssis | 30+ ssis tasks | real-time ssis monitoring | quick starts | bi blitz try msmerge_articlehistory in distribution database. looking book on sql server 2008 administration? http://www.amazon.com/microsoft-server-2008-management-administration/dp/067233044x looking book on sql server 2008 full-text search? http://www.amazon.com/pro-full-text-search-se

Surface controls

are there surface controls have been built (perhaps in codeplex project) bit nicer out of box surface controls? such date picker, or cover-flow control, etc...? have seen these? http://www.infragistics.com/whats-hot/microsoft-surface.aspx#microsoftsurface josh curry (jcurry) | sr. support escalation engineer | microsoft surface support Other Forums  >  Surface Application Design and Development

MDW issue - "A data source instance has not been supplied for the data source Snapshot Time'..

i have issue mdw. when click on query statistics report , inside click on query plan following error "a data source instance has not been supplied data source snapshot time'.. when trace error in sql profiler error returned is  'error converting data type nvarchar numeric.' , query exec snapshots.rpt_query_plan_details @instance_name=n'wge3db025p\sqlodsp01', @plan_handle_str=n'0x05001600d4e5f2578094d03a3400000001000000000000000000000000000000000000000000000000000000', @statement_start_offset=1086,@statement_end_offset=4450 looking inside snapshots.rpt_query_plan_details see following variables declared...     @instance_name sysname,      @plan_handle_str varchar(130),      @statement_start_offset int,      @statement_end_offset int  has came across error ??  or know how fix ??  the reason im using mdw profile queries , see plan not working  sql server 2014 sp1 ... ilikefondue hi ilikefondue , thanks ques

ASPX to SQL Server - page contents dependent on ?id= value

<%@ page title="" language="vb" masterpagefile="~/master1.master" autoeventwireup="false" codefile="details.aspx.vb" inherits="medical_details" %> <%-- add content controls here --%><asp:content id="content1" runat="server" contentplaceholderid="pagetext"> <div id="content"><h2>some title</h2><p>medical information for: {player name}</p> <p> <asp:detailsview id="detailsview1" runat="server" autogeneraterows="false" datakeynames="playerid" datasourceid="hgaadmin" height="50px"> <fields> <asp:boundfield datafield="playerid" headertext="player id" insertvisible="fals

Database snapshot in mirroring

hi, when take snapshot of mirrored database in mirror server using following code create database snap1 on (name=adventureworks_data,filename='d:\backup\adv.ss') snapshot of adventureworks go i'm getting below error msg 1823, level 16, state 2, line 1 database snapshot cannot created because failed start. msg 5119, level 16, state 1, line 1 cannot make file "d:\backup\adv.ss" sparse file. make sure file system supports sparse files. make sure volume on which you are creating snapshot formatted ntfs , not fat32 SQL Server  >  Database Mirroring

Update the current entity with server-side values? (Entity & RiaServices)

hello! possible update current displayed entity? scenario following: ask server operations (not directly on current entity), when these 1 finished, server modifiying properties on current entity , give me succeeded reply of true or false. problem current entity not aware of these server-side modifications.... how can force entity new values server?? there no .refresh() or .reload() method? context of type  system.servicemodel.domainservices.client.domaincontext ( http://msdn.microsoft.com/en-us/library/system.servicemodel.domainservices.client.domaincontext(v=vs.91).aspx ) wcf riaservices. help! the load method of domaincontext takes in loadbehavior enum. if load behavior of mergeintocurrent or refreshcurrent load new values server. mergeintocurrent keep changed values, refreshcurrent overwrites values. Silverlight  > 

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 when start

Merge Replication Subscription Detail Window: Initialization phase periodically takes orders of magnitude longer to run

Image
merge replication between 2 geographically dispersed sites.  single table publication. active monitoring of replication status checking last time merge agent completed periodically (typically once or twice day) encounter monitor alerts indicating subscriber has not been updated. checking merge subscription detail window shows synchronisation, takes less 10 seconds process 100-200 dml actions has taken 10-12 minutes, initialization phase accounting 100% of total. research (see http://www.yaldex.com/sql_server_tutorial_3/ch12lev1sec4.html ) suggests initialization phase involves startup of merge agent , establishes connection publisher , subscriber.  there no indication of connection failures or bottlenecks between publisher , subscriber.  welcome troubleshooting guidance determine causing significant drop in synchronisation performance. although short-lived can result in false alarms our on call support team @ 3:00 am. query msmerge_history see detailed informati

making a cross-domain request on Application_Exit

can done? can't use webclient.downloadstringasync because during exit call url never goes through. can't use browser's xmlhttprequest object because need make call webservice on domain. according msn library silverlight: an exit event handler should not include long-running, re-entrant, or cyclic code, such resetting silverlight plug-in's source property. ( http://msdn.microsoft.com/en-us/library/system.windows.application.exit(vs.95).aspx ) your question has been answerd before, see topic: http://silverlight.net/forums/p/20279/130230.aspx Silverlight  >  Programming Silverlight with .NET – General

Data transfer from SQL Server 2008 R2 to Oracle 11gR2 slowness

hello eveyone! i need daily transfer 30 000 rows dataset oracle, sql server , slow (1 min / 1000 rows).  my employer doesn't have nor enterprise edition, nor developper edition of sql2008.  we have deal sql2008r2 straight.  i tought microsoft connector oracle attunity, have forget our sql version not compatible. the data transferred simple data flow task, no transformation, no filter, no fancy anything.  i tried several connectors provided in ssis , fastest 1 .net providers\oracleclient data provider. also, not familiar oracle, tests have made on oracle server (test not same setup prod. go figure why!) seemed prove there wrong our oracle prod setup, cannot put finger on since i'm newbie oracle.  here differences in setups: test environment setup (going @ normal , acceptable speed): db_cache_size = 33554432 java_pool_size = 67108864 large_pool_size = 8388608 log_buffer = 1163264 shared_pool_reserved_size = 10000000 shared_pool_size = 167772160 sort_ar

Failure to connect to server access denied not a valid user

i error don't know do.  have been through 2 different tutorials. first 1 came microsoft sql server management studio , other found on-line ( http://download.microsoft.com/download/7/4/f/74f85fd1-c1f2-453a-ae90-452abab1234c/med302_msdn_sql_mobile.doc )   but keep having problems.  got far, stuck.  i sql newbee.   the message on new subscription wizard is: falure connect sql server provided connection information.  sql server not exist, access denied because sql user not valid user on sql server, or password incorrect.  hresult 0x8000r005 (29060)   i using user name sa , password password, fails.  do have add user sql server mobile (how?) or sql server? do have set permissions? i running on xp professional, sp2 wiith ms sql server management studio version 9.00.1399.00 any appreciated. i figured out.   the tutorials assume c drive shared tell use machine name everywhere instead of c drive.    if c drive not shared agent cannot run.   my company not sha

Return XDocument from service

i have web service: [ webmethod ] public xdocument loaddata( string path) { stringbuilder resturl = new stringbuilder (); httpwebrequest restrequest; httpwebresponse restresponse; resturl.appendformat(path); restrequest = ( httpwebrequest ) webrequest .create(resturl.tostring()); restrequest.headers.add( "authorization" , "basic " + convert .tobase64string( encoding .ascii.getbytes( "demo:demo" ))); restresponse = ( httpwebresponse )restrequest.getresponse(); stream stream = restresponse.getresponsestream(); xmlreader reader = xmlreader .create(stream); xdocument xdoc = xdocument .load(reader); return xdoc; }  but when try view in browser (.asmx) shows me following error: system.xml.linq.xdeclaration cannot serialized because not have parameterless constructor what should overcome it? constructor should be? don't return custom class - xdoc - variable. try using xmldocument system.xml inst

scrollbar in grid

hi all, trying enable scrollbar in grid cannot it. tried using the code below, there no change. can me? scrollviewer.verticalscrollbarvisibility ="visible" thanks in anticipation, amol parikh   you can place grid in scrollviewer control. <scrollviewer verticalscrollbarvisibility="auto"> <grid height="1000" /> </scrollviewer>   Silverlight  >  Programming Silverlight with .NET – General

Issue with the use of OLEDB Command task to update Db2 target table

Image
  i having problem on updating data in db2 target table.   i followed bj custard's ( http://forums.microsoft.com/msdn/showpost.aspx?postid=1058272&siteid=1&mode=1 ) (thanks amillion!) post , configured oledb destination insert data. have update or delete data target table based on flag source.   i tried using oledb command uses oledb connection created following steps posted in above link.   trail 1 real requirement): when used sql query: delete table col1=? , col2=?   i unable map parameters. when click refresh button after writing query, " there is data source column no name. each data source column must have name. " message. added to before message, there no parameters map to.   trail 2: when hard code parameters :   delete from table1 col1='abc' , col2='xyz' no parameters come up, no mapping. when execute mapping following error:   error: 0xc0202009 @ load .........................................

In which situation the sql server use the index?

for example customer want information employee table.the table containing 2000 employees details,in 1 more 1750 employees draw 10k 20k salary , remaining employees draw more 20k salary. client ask want employees details draw between 10k 20k salary.so,in situation sql server use index data employee table fast? other wise in situation sql server use index? i sure table has employee no. columns nad has primary key .if yes , should create non-clustered index in salary column , including select columns in include section should suffice .. if dont have primary key on column make clustered index on employee no. column used in of queries .primary key creates clustered index . if query : select * employee salary between 10000 , 20000 create non-clustered index on salary . if query : select name , age employee salary between 10000 , 20000 create non-clustered index on salary , include name , age columns in index (this fro 2005 , above).   abhay chaudhary ocp 9i, mcts/mcitp (sql serve

SQL cluster

hi recomandition secure cluster ? , how install failover cluster ? must install data protection manager every nods ? thanx falcon hi marek_g, thanks post. to install instance of sql server failover clustering, can refer following books online documentation: how to: create new sql server failover cluster (setup) ( http://msdn.microsoft.com/en-us/library/ms179530.aspx ). also, data protection manager not prerequisite sql server failover clustering setup, give additional data protection mentioned @ http://www.microsoft.com/systemcenter/en/us/data-protection-manager.aspx . hope helps. best regards, chunsong feng please remember click "mark answer" on post helps you, , click "unmark answer" if marked post not answer question. can beneficial other community members reading thread. SQL Server  > 

RC0 - Having Trouble creating Proxy for Silverlight-enabled WFC Service.

i trying create silverlight 2 rc0 project accesses silverlight-enabled wfc service in vb.net. online documentation seems outdated , not work. created new silverlight project new asp.new project. the default project added new silverlight-enabled wcf project called service1. got visual studio error when did said "error, object reference not set instance of object." action seemed go ok, service added , project compiled ok. next project executed "add service reference" default dowork operation. operation seemed go ok , servicerefernce1 added. problem how define proxy in page.xaml.vb file access dowork service. project added references system.servicemodel , system.servicemodel.web. page.xaml.vb file can add imports system.servicemodel , system.servicemodel.channels. page.new() after initializecomponent() add "dim proxy = new silverlightapplication6.web.servicereference1.service1client" compiler says not defined. service1client defined in object browser

merged cells in excel

Image
when import data excel ms sql, got following rows in db.in excel row2 row4: field1 merged , row5 & rows6:field1 merged. now, want replace null values row2 field1 value in row3, row4 field1, similaryly row4 field1 value in row6 field. row1 - field1 field2 field3 row2-   abc      b       c row3-   null     d       e row4-   null     f         g row5-    def     i          j row6-    null    k        l finally should this... row1 - field1 field2 field3 row2-   abc      b       c row3-   abc      d       e row4-   abc      f         g row5-    def     i          j row6-    def     k        l i suggest use sql - cursor to process these records, can't sort them because break sequence, cursor can process them row row. here's code testing data. declare @rowdata table ( field1 varchar(50), field2 varchar(50), field3 varchar(50) ) insert @rowdata values ('abc','b','c'), (null,'d','e'), (null,'f

Rotating a picture back 20''

Image
 i have following problem:  <image x:name="polaroidtwo" rendertransformorigin="0.5,0.5" source="polaroidone.jpg" height="114" width="114" canvas.left="616" canvas.top="17">                 <image.rendertransform>                     <transformgroup>                         <scaletransform scalex="1"/>                         <skewtransform/>                         <rotatetransform angle="20"/>                         <translatetransform/>                     </transformgroup>                 </image.rendertransform>             </image>   when move mouse on polaroidtwo, want rotate 20 degrees  "straight" position. rendertransform doesn't seem solution here...:( use storyboard animation rotate them. did similar buttons. can exact same thing images. check out storyboard below --

Change owner of an SSIS package

i need change owner of ssis package. reason developer created package listed <developer name>.packagename.  i'd lke subsitute "dbo" <developer name> tia, barkingdog hello, you need @ below tables , update ownersid column. below teh code snippet that. --sql server 2005 select * msdb.dbo.sysdtspackages90 --sql server 2008 select * msdb.dbo.sysssispackages update msdb.dbo.sysssispackages set [ownersid] = suser_sid('sa') [name] = 'maintenanceplan' may want cacth on post jonathan. http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/05/04/dyk-maintenance-plans-have-owners.aspx | sankar reddy | http://sankarreddy.spaces.live.com/ | SQL Server  >  SQL Server Tools

Why is the display SSMS backup dialog so out of whack with the rest of the app?

Image
this on surfacebook 2 additional monitors through docking station...  there couple of display issues, in general, ssms seems have real problems scaling dialogs. have advice on how change settings fix this?  main screen , dialog fine, backup dialog ends freaky , unusable. thoughts? j http://digitalcamel.blogspot.com/ see below link spaghettidba, http://www.sqlservercentral.com/blogs/spaghettidba/2015/10/14/ssms-in-high-dpi-displays-how-to-stop-the-madness/ regards, s_no "_" SQL Server  >  SQL Server Tools

TFS 2010 Best Practice Analyzer, Unauthorized to call Team Foundation Server Web Services

Image
i running tfs 2010 on windows server 2008 r2 virtual machine. windows authentication set connecting server , when try connect via vs 2010 team explorer, or via ie works fine. client machine running windows 7 , credentials provided inside windows credentials manager matches credentials required tfs.    however, when run best practice analyzer's complete health scan came april version of tfs power tools, error: unauthorized call team foundation server web services.    what should approach?  you need run bpa on server. ewald - please remember mark replies answers if help. blog: www.ewaldhofman.nl Archived Forums V  >  Team Foundation Server - General

Dimension Security - Multiple Roles

hi guys, i working on implementing ssas dimension security. i have following 2 roles on dimension security implemented on 2 different attributes ( city , country): city_role = {[geography].[city].[city code]} country_role = {[geography].[country].[country code]} the first role restricted on cities , second restriced on countries. scenario 1: the user wants have access either on city or country level .we can map him corresponding role.so , user can see data authrozied see. not facing issues. scenario 2: the user wants have access on both city , country level. in case, have mapped him both roles. after which, whilst trying connect cube via excel, user can able see entire data irrespective of city , coutry mapped him per ex. incorrect. for ex:  city    : illinois  country : london please me in providing suitable solution scenario 2 . let me know if unclear. thanks in advance. regards ganesh ganesh,  are attribute relations set hierarchy? without

help constructing a select statement

using sqlserverce...   i need little constructing select statement - have product summary table contains quarters , weeks. data can come in asynchronously. need able select (for example) quarter = 2 , week = 3 or week = 2, depending on whether week 3 available yet.   something "select * products quarter = 2 , week = 3 (or week = 2 if no week 3)----   mike p       hi captain,   if understand correctly, want data last week of quarter. if so, can use  inner join follow:   create table products ( id int , name nvarchar ( 10 ), quarter int , week int ) go insert into products values ( 1 , 'a' , 1 , 1 ) go insert into products values ( 2 , 'b' , 1 , 2 ) go insert into products values ( 3 , 'c' , 2 , 1 ) go insert into products values ( 4 , 'd' , 2 , 2 ) go insert into products values ( 5 , 'e' , 2 , 3 ) go   select a .* from products a inner join ( se

Attaching Northwind (2000) into SQL Server 2005

i trying attach sql server 2000 sample northwind database using sql server 2005. when database-->attach using gui seems alright. can open northwind database , see usual listing of stuff. however, when click on database diagrams, error message stating "database diagram support objects cannot installed because database not have valid owner. continue, first use files page of database properties dialog box or alter authorization statement set database owner valid login, add database support objects." i have tried repeatedly alter authorization statement work, no avail. have restarted machine, , properties of database saying owner same other databases have, keep getting error message. what doing wrong here? how can fix this? any appreciated. thank you. did checked link: http://msdn2.microsoft.com/en-us/library/ms186345.aspx hth, jens k. suessmeyer. --- http://www.sqlserver2005.de --- SQL Server

Using Weighted Dimension in SSAS

hello everyone, working standard-modeled olap cube of sales, consists of customer, time, shop dimensions , transactions fact, standard measures: amount (sum), # of transactions , distinct count of customers. now, need weight measures using defined customers' weighting factors, means following: every customer in dimension has weighting factor (from 1 100); amount measure should summarize transactions' amounts multiplied appropriate customers' factors; # of transactions should take account customers' factors, e.g. transaction customer's factor 100, should output 100; distinct count of customers should weighted, e.g. should treat "factor 100" customer 100 customers , output result accordignly; appreciate ideas of how can implemented , whether possible implement using ssas @ all. best regards, vitalii vitko. for amount , # of transactions either multiplication in view or in dsv or load fact table. let insert "pre-wieghted" va

Static resource instances in memory

i've been learning how use windbg , noticed appears strange behavior in application. as example, running !dumpheap -stat noticed following: 0868fb84 918 11016 ui.silverlight.converters.accountaddresstostringconverter indicating have 918 instances of accountaddresstostringconverter in memory. in reality i'm implementing once static resource in resource dictionary this: <ftconverters:accountaddresstostringconverter x:key="accountaddresstostringconverter" /> i'm not referencing static resource anywhere in code.  perhaps don't have complete understanding of how static resources work seems me there should 1 instance of accountaddresstostringconverter in memory. further investigation shows of 18 converters i'm declaring static resources in same resource dictionary of them have 918 instances in memory. as said i'm new windbg don't know go here continue troubleshooting issue.  i'm including output of !gcroot 1 of 918 instances in