Lun

  hi, get error in log, "the time stamp counter of cpu on scheduler id 1 not synchronized other cpus." , moment wan't disable server loggings.   indeed errors should investigated, not moment...   thanks! rickard start sql -n parameter:   http://msdn2.microsoft.com/en-us/library/aa213799(sql.80).aspx http://msdn2.microsoft.com/en-us/library/ms190737.aspx     however, specific error, don't know why want stop error logging.  turning off important part of sql server troubleshooting.  if want more information warning message at:   http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx http://support.microsoft.com/kb/931279   i see error on development servers alot run sql on virtual servers.  hasn't created problem yet, , seems affect execution statistics have seen.  

hi all, pls me on below query on code review feature in tfs 2012. my question on related workitems option on request code review pane. lets assume, have 3 tasks workitem parallelly working(all 3 task wi has state "in progress") now if go request code review changed file means is showing 3 tasks in "related workitems" but code review of changed file task1.i not getting how individually choose  task workitem related workitem in codereview pane. regards,  santhosh when working on 3 separate tasks in parallel, should use suspend/resume option , request reviews. when you've got multiple tasks in progress @ same time (without suspending), review trigger open changes. to work around this, temporarily shelve&revert other changes, request review. to request review specific changeset after checking in, open history panel, locate changeset , right-click request review specific set if changes. my blog: blog.jessehouwing.nl

hello everyone! develop silverlight application touch screens, got big problem. silverlight application under wp7 , touch-screen same? can develop under wp7 , use same application on other touch screens? you, please, provide me sample application works under touch-screen? don't have touch-screen monitor, wp7 emulator. thanks, volodya. no not same , if throw in wpf , xna different again. having said there set of 3 articles mike taulty here: http://mtaulty.com/communityserver/blogs/mike_taultys_blog/archive/2010/11/02/touched-part-3-manipulation-and-gesture-support.aspx towards end of part 3 talks wp7 , xna too. articles worth working through. Silverlight  >  Silverlight for Windows Phone

hello, i'm new silverlight , other thing visual studio i'm creating application whit links other sites im using hyperlink button don't know code musi inser in page.xaml.cs code have button_click event handler:             initializecomponent();         } private void install_click( object sender, routedeventargs e)         {  *         } *= want button open page p2.aspx in same folder code should insert there sorry, need specify absolute uri  <hyperlinkbutton navigateuri="http://server.com/p2.aspx" content="click me" /> Silverlight  >  Visual Studio & Silverlight Development Tools

when go edit powershell file in tfs , in vs ide must explicitly check out file other files viewing can jump in , start editing , tfs check out you. how make extensions seemingly unknown tfs known annoying not able check out on fly. hi brthomas, you cannot check out file automatically edit if file opened in other software other vs ide. in other words, if file can opened in vs ide, file can modified in source control explorer. for example, if want edit ps1 file automatically in source control explorer, can right click file in source explorer, , select open with, in open dialog, if set editor(known tfs mentioned) can open ps1 file such automatic editor selection(xml) default, ps1 file can edit automatically in source control explorer, otherwise, cannot edit it. hope helps! if have concern, please feel free let me know! best regards, cathy kong   Archived Forums V

hello,   i'm installing application , getting following error:    can't connect sql server db.  error: tcp/ip connection host <database_engine_name>, port 1433 has failed. error: : connection timed out. verify connection properties.  make sure instance of sql server running on host , accepting tcp/ip connection @ port.  make sure tcp connections port not blocked firewall.   can please advise me. 1. make sure sql server service running 2. if named instance, make sure sql server browser service running 3. make sure sql server configured allow remote connections 4. examine sql server error log messages confirming sql listening on expected network interfaces , ports 5. test server connectivity ping client machine 6. test port connectivity using telnet or powershell server , port (from step 4) client machine.  for example a. telnet <server-name> 1433 b. powershell: 1433 | % { echo ((new-object net.sockets.

i have parent package , children; want make connection string of childern package dynamic. parent package passes connection string children i have execute package task in foreach loop in parent package load , executes childern, , how can define connetion parameter in parent package , parent package passes children the parent package executed through c# code   thanks sqldev make string variable store connection string in parent package(configure want). next use parent package configuration in child package to make variable accessible in child package. use expressions in child package connection data variable. SQL Server  >  SQL Server Integration Services

hi there, the following error recorded in sql error log, operating system error 'incorrect checksum ( expected: 0x823f5642; actual: 0x823f5642 )' resulted attempt read following: sort run page (7:347418), in file 'd:\data\tempdev_05.ndf', in database id 2. sort retrying read. error: 823, severity: 24, state: 7. resources on the web have pointed storage issues. curious why expected checksum matches actual checksum above? thanks in advance. regards, yong hwee run dbcc checkdb on database   http://www.sqlskills.com/blogs/paul/category/checkdb-from-every-angle.aspx best regards, uri dimant sql server mvp http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/ SQL Server  >  SQL Server Database Engine

hi, for unknown reason, when open ssms, "error list" in bottom.  there columns like: description / file / line / column in "error list". we wonder how turn on / off ? cheers for  display "error list" window (transact-sql editor only) you can use keyboard shortcuts ( it depends on version ): crtl+\, ctrl+e   or  ctrl+\, e you can learn more following link shortcuts: http://msdn.microsoft.com/en-us/library/ms174205.aspx i saw later using version 2005, may using version of express shows this? please mark answer if helps solve issue tzuri ben ezra | certifications: comptia a + ,microsoft mcp, mcts, mcsa, mcitp | facebook: tzuri facebook | vcard: tzuri vcard  |  microsoft id: microsoft transcript     |   SQL Server  >  Getting

i have created build definition on on-premises tfs 2015, , trying build simple web application. getting below error: this version of msbuild not supported: 'microsoft.build, version=15.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a' below id complete log build task. 2016-08-11t10:01:47.2275152z checking if artifacts directory exists: c:\agent\_work\1\a 2016-08-11t10:01:47.2275152z deleting artifacts directory. 2016-08-11t10:01:47.2431185z creating artifacts directory. 2016-08-11t10:01:47.2431185z checking if test results directory exists: c:\agent\_work\1\testresults 2016-08-11t10:01:47.2431185z deleting test results directory. 2016-08-11t10:01:47.2431185z creating test results directory. 2016-08-11t10:01:47.2900162z starting: sources 2016-08-11t10:01:47.3056189z entering tfvcsourceprovider.preparerepositoryasync 2016-08-11t10:01:47.3056189z localpath=c:\agent\_work\1\s 2016-08-11t10:01:47.3056189z clean=false 2016-08

hi need create new 'role' following permissions, 1. access sql server logs. 2. access maintenance plans ( can avoid access) 3. access activity monitor 4. normal access product databases , not system db´s need guidance on how it, can point me in right direction please? thanks 1.grant  execute on xp_readerrorlog [domainname\ad user or group]; 2. http://technet.microsoft.com/en-us/library/ms191002.aspx 3.view server state permission 4. make user member of dbo_owner database role. best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql consulting: large scale of database , data cleansing remote dba services: improves ms sql database performance sql server integration services: business intelligence SQL Server  > 

i want specify files types should not auto merged, we have many (700+) vb6 projects each branched various versions of application in different stages of development. quite bit of merging takes place between these version branches, merging isnt problem, except vb6 project files. there 2 problems why want manual merge them.  1. the format of project files subject heavy change if minor changes made adding new file. 2. changes new version number of versions of references in files not seen conflicting , merged automaticaly in many cases wrong thing do.   problem 1 makes hard merge adding of file target project file because files dont match @ all, not of problem can use our own merge tool update these nicely. (as these seen conflicting)   problem 2 harder because doesnt give chance use our merge tool because tfs thinks can update changes safely.   i want tell tfs never auto merge vb6 project file can use our own merge tooling merge type of file. in effect show conflicting

hi all i have created virtual server win 2008 r2, installed sqlexpress , application compatibility toolkit. when run act , try create database can connect me database (local)\sqlexpress no databases appear in box below. can type name of database , click create, when red error saying: "this database not compatible application" i check sql server manager studio , has created database. have checked permissions think relevant: (local)\administrator has "dbcreator" server role (local)\administrator has database ticked in "user mapping" , db_owner, db_datareader, db_datawriter , public permissions under database - security - users have administrator account , service "nt service\mssql$sqlexpress" (this account sql server service runs according services) in database security heading, local\administrator account has db_owner, db-datareader , db-datawriter "membership" the service has db_dataread

 i looking @ using silverlight 3 new project has short timeframe.  have vs2008 , expression studio 2.  can install , use sl3 these?  thanks , appreciate quick reply...the clock ticking.   to work silverlight 3, need install these, silverlight3 runtime: http://go.microsoft.com/fwlink/?linkid=150228 silverlight 3 sdk: http://www.microsoft.com/downloads/details.aspx?familyid=1ea49236-0de7-41b1-81c8-a126ff39975b&displaylang=en   silverlight 3 tools vs 2008: http://www.microsoft.com/downloads/details.aspx?familyid=9442b0f2-7465-417a-88f3-5e7b5409e9dd&displaylang=en expression blend 3: http://www.microsoft.com/downloads/details.aspx?familyid=e82db5e2-7106-419e-80b0-65cce89f06bb&displaylang=en   silverlight 3 toolkit: (optional more tools) http://silverlight.codeplex.com/release/projectreleases.aspx?releaseid=24246   also u have install in these order..       if post answers ur question, don't forget mark post answered..

i've got few web edition sized dbmses in north central data center.  up until last week able use ssms r2 sp1 rename them object explorer.  did feature dropped service release of aug 30?  sql instance has select @@version: microsoft sql azure (rtm) - 11.0.1467.26 aug 30 2011 23:41:16 copyright (c) microsoft corporation did feature tossed on purpose?  if accident (hey - i've made share!) can re-animated in next service release? thanks. regards, howard hoffman does pressing f2 work? Microsoft Azure  >  Azure SQL Database

how integrate or create bcm database on azure sql server bcm databasetool outlook? hi  instead of trying create bcm database in sql azure, can try dynamic crm online itself  http://crm.dynamics.com/en-us/home hope helps !!! arunraj chandrasekaran, mcts, author: sqlxpertise.com if found post useful, please " mark answer " or " vote helpful " Microsoft Azure  >  Azure SQL Database

i running vs2005 rc , have attempted create few team projects failed due problems permissions.  .net attempted rollback partially created project failed @ point of deleting project because of permission issues.  stuck ghost solutions.  fyi:  permission issues resolved.  project not show nor can create project same name or use tfsdeleteproject delete project.  when run tfsdeleteproject "the item '/<projectname' cannot found ---> item '/<projectname' cannot found.  ok main problem when connect source control ghost projects show in source control.  have tried delete them within vs2005 rc client told delete them using 'deleteteamproject' (renamed tfsdeleteproject in rc).  @ point stuck junk solutions.  know how resolve issue without uninstalling vs2005 server or there table in can remove these entries don't show in source control list? thank you, bracken it project creation couldn't create folder in reporting services, described recent posts

hi, how find out missing index & duplicate index? want prepare report of both this. please me. hi maur, have @ script http://blog.sqlauthority.com/2011/01/03/sql-server-2008-missing-index-script-download/ select top 25 dm_mid.database_id databaseid, dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) avg_estimated_impact, dm_migs.last_user_seek last_user_seek, object_name(dm_mid.object_id,dm_mid.database_id) [tablename], 'create index [ix_' + object_name(dm_mid.object_id,dm_mid.database_id) + '_' + replace(replace(replace(isnull(dm_mid.equality_columns,''),', ','_'),'[',''),']','') + case when dm_mid.equality_columns not null , dm_mid.inequality_columns not null '_' else '' end + replace(replace(replace(isnull(dm_mid.inequality_columns,''),', ','_'),'[',''),']','') + ']' + ' on ' + dm_mid.s

we looking put sharepoint in dmz, along website. both of these need connections sql server, safer? we prefer not purchase full copy of sql on cards if needed. currently have 1 sql 2008 express server running internal, people connect using front end access, data cant seen outside world , needs stay secure @ moment. if put sql server on dmz need sync live data between internal server dmz , sync data 2-3 times day dmz internal server. what secure way after? cheapest way, , how secure make sql server on internal network other databases nobody externally should able see connecting dmz i recommend place sql in internal network , open necessary ports (1433 default) on firewall. tom tom van zele | blog | twitter | linkedin SQL Server  >  SQL Server Setup & Upgrade

tfs beta3 refresh:   when creating new team project chose "do not create source control folder @ time" on final step of wizard nevertheless source control folder ("$/project1" in case) still created. i not able find way remove source control folder without removing team project - tf.exe not have enough options this. on other hand can't find how create source control not linked team project. thanks the bug caused project creation wizard ignore " do not create source control folder @ time " fixed recently.  lived couple of weeks.  unfortunately couple of weeks spanned when snapped tree beta 3 , didn't catch it. you can't create root level folders other team projects , can't delete them except deleting team project. brian Archived Forums V  >  Team Found

we tried sync preview - followed steps in'https://azure.microsoft.com/en-us/documentation/articles/sql-database-get-started-sql-data-sync/'.  we have 2 shards (created using elastic scale).  we tried syncing 1 of tables 1 database shard other.  the sync went on ever , had cancel operation.  tried table couple of records make sure not problem volume of data.  any ideas on have gone wrong helpful. hi silverkat, could provide more details(e.g. subscriptionid, server name, sync direction, etc) further troubleshooting? regards, gary Microsoft Azure  >  Azure SQL Database

i using ssrs 2008. have developed report has parent group called area , child group called status. area can a, b, or c. status can open, closed, new. the report this: area a           status new                                                count of apps 'new' in area 'a' = 10          status open                                               count of apps 'open' in area 'a' = 18          status closed                                              count of apps 'closed' in area 'a' = 2 area b            status new                                                count of apps 'new' in area 'b' = 17          status open                                               count of apps 'open' in area 'b' = 20          status closed                                              count of apps 'closed' in area 'b' = 6                   what wa

i'm working in visual studio 2010 , windows 7 ultimate x64, , have installed following: silverlight_developer.exe silverlight_sdk.exe silverlight4_tools.exe silverlight3_tools.exe is installed. if create new silverlight 4.0 app, cannot find dockpanel in toolbox or gac. if create new wpf app, can find dockpanel. cannot load dockpanel toolbox when have silverlight app loaded. what have install access dockpanel in silverlight app? i've found thread on codeplex talks unloading/reloading "toolbox", i've had no successin doing system.windows , system.windows.browser (which verified coming silverlight4 directory). thanks, randy my mistake downloading silverlight toolkit following location: http://www.microsoft.com/downloads/en/details.aspx?familyid=b3deb194-ca86-4fb6-a716-b67c2604a139&displaylang=en i figured out because found , watched following jesse liberty video: http://www.silverlight.net/learn/videos/silverlight-videos/silver

hi - i'm using ssrs 05 , believe trying accomplish nested aggregate. in table have expression show date difference. =iif((sum(iif(fields!progdescr.value = "typed" ,1,0)) = 1),(fields!progdt.value - fields!recvdt.value), "-" ) this part working fine. trying average of field in month grouping. any appreciated. lee - 2008 r2 supports nested aggregates workaround 2005 involves including first aggregate within query each row include sum of monthly grouping: select ...., (select sum(val) foo month(dateval) = month(t.dateval)) foo t ... ofcourse situation bit more complicated moving if-else expression sql SQL Server  >  SQL Server Reporting Services, Power View

according company policy person responsible (in assignedto field) particular work item has receive email notification on each change of workitem. i didn't manage create single rule workers in project, have create separate rule each person in following way: notification: .name = wi-j.smith .condition = "portfolioproject = myproject , assignedto=j.smith" .sendto    = j.smith@mycompany.com i wonder possible create single rule somehow in following manner: ... .condition = "portfolioproject = myproject " .sendto = @assignedto mike mike, i'm not expert on area, try having a subscription web service instead of mail address, , have web service one forwarding email right end user. of course, unfortunately more work single rule attribute, @ least might mitigate having keep rules date when new people or email addresses change. hope helps... ben  Archived Forums V

hi, i pretty new configuring tfs (single server) , trying system setup on hosted (rackspace) environment accessible either work domain or external pc's. the current situation is: installed sql server 2008 r2 installed tfs 2010 , configured using basic configuration created subdomain , pointing server (i.e. tfs.mycompany.com) modified binding in iis7 team foundation server website use tfs.mycompany.com changed urls in tfs admin console (notification url , web access url) disabled loopback reg key now when connected server via remote desktop connection can see tfs project collection (empty @ moment) through team explorer 2010 , through web page when using either http://localhost:8080/tfs or http://tfs.mycompany.com:8080/tfs. asks me authenticate , current rackspace server windows account works fine (needed lookback reg fix fqdn work ). far problem comes when try see tfs outside of rdc. on work pc start te2010 , try connect rackspace tfs instance error saying can't

hi everyone i have ssis package has parameter messagedate  as input. i making sql agent job in want  parameter messagedate autometilcally take getdate() you can use sql agent "tokens". please see: https://www.mssqltips.com/sqlservertip/3553/passing-sql-server-agent-tokens-to-an-integration-services-package/ https://msdn.microsoft.com/en-us/library/ms175575.aspx?f=255&mspperror=-2147217396 SQL Server  >  SQL Server Integration Services

hi, let me know how can use dsv in offline development of ssis. checked cant browse table in dsv when database offline. detailed information highly appreciated  regards, shanu hi shanu, the data source (not sure why call view) connects live sources when needed, entire package number of connection managers can set work offline , not bothering establishing connection data sources typically metadata validation purposes. the purpose of global dataset in providing single point of connection various entities within same project. i think referring shared connection manager feature (new in ssis 2012). arthur my blog SQL Server  >  SQL Server Integration Services

hello all, can please provide me information ado.net data service. want benifits of , how use silverlight. thanks. hi, this topic has been discussed here . john papa has a  great article subject on msdn magazine (source code included). other useful resources available on ado.net data services home page. hope helps. Silverlight  >  Visual Studio & Silverlight Development Tools

i have style in app.xaml targets properties of datepicker: < style x:key= "edittemplatedatevalue" targettype= "controls:datepicker" > < setter property= "fontsize" value= "12" /> < setter property= "margin" value= "0,0,0,0" /> < setter property= "height" value= "25" /> </ style >   because needs different namespace, have @ top: xmlns:controls="clr-namespace:system.windows.controls;assembly=system.windows.controls"   blend displays fine, runs fine, but visual studio thows error , wont render preview me: error 1 invalid attribute value controls:datepicker property targettype.  in experience visual studio preview pane not work (in useful way) simple xaml Silverlight

hello everybody, i using sql server reporting services in asp.net application. when users access report webapplication, annoys prompting credentials. "enter user name , password access data source: " , abutton "view report". can please me out how solve this? need report viewed users without prompting credentials as are authenticated using integrated windows authentication. thanks. regards, phoenix hi phoenix, the following article may solve issue: http://www.odetocode.com/articles/216.aspx if have more questions, please feel free ask. thanks, jin chen jin chen - msft SQL Server  >  SQL Server Reporting Services, Power View

i have following entity: [enableclientaccess] public class yearlystatisticcalcs { public yearlystatisticcalcs() { } [key] public guid id { get; set; } public decimal volume { get; set; } public decimal produced { get; set; } public decimal unproduced { get; set; } public decimal needed { get; set; } public int satisfactionyes { get; set; } public int satisfactionno { get; set; } public int totalcustomers { get; set; } public int personal { get; set; } [include] [association("mykey", "id", "id")] public weeklystatisticcalcs runningyearlytotal { get; set; } [include] [association("mykey2", "id", "id")] public weeklystatisticcalcs runningyearlygoalstotal { get; set; } here

i have created radio button new work item survey type. if open workitem of survey type, functions perfectly. if open workitem home page entering number renders perfectly. if open query in preview window functions perfectly, although first rendering of form processes each custom control 30 times. if open query, radio buttons invalidate process works[i had tested adding alert], there else occurring blank out radio button checked. there 2 concerns what causing rendering process fire 30 times per control? what event being fired not documented serkan unchecks radio button? i can add control if need, simple control. hi fred,   thanks post. what’s detailed version of tfs 2012? created custom button using version of vs? what’s “open query in preview window” mean? please provide detailed steps here. try open work item other clients , tfs server machine, check result. and can share control here. if have further research of issue, please share experience

anybody know how show serial a,b,c, ... and set report size b3 (17" , 11") . correct , can print b3 size paper ? i appreciate help. hi init-user, question 1: show alphabetical serial no. in rdlc report from description, show me want add serial numbers? if possible, please post example show expected result. if want add alphabet in front of each value of row group, suggest use numeric values replace alphabets. in visual studio 2008, can refer steps below: right-click on textbox of row group , select “expression…” set expression to: =runningvalue(fields!fieldname.value,countdistinct,nothing) & ". " & fields!fieldname.value question 2: reset physical page size report from description, mean have reset page size in report properties dialog , want print report b3 size paper? in reporting services, can customize physical page size report. want print report b3 size paper, suggest customize page size in report properties dialog to: page

hello all   i builded 3d model , let rotatetransformed in wpf,and want the animation pause you download demo : http://www.jz322.com/wpf3dtest.rar if can please send email me : tmobile@126.com     // geometry creation    mgeometry = new geometrymodel3d(mesh, new diffusematerial(brushes.yellowgreen));             var tf = new transform3dgroup();             mgeometry.transform = tf;             //vector3d v3d = new vector3d(10, 0, 0);                         //a = new axisanglerotation3d(v3d, 0);             //tf.children.add(new rotatetransform3d(a));             doubleanimation da = new doubleanimation(30, 90, new duration(timespan.fromseconds(10)));             da.autoreverse = true;             rotationy.axis = new vector3d(0, 10, 0);             this.registername("rotationy",rotationy);             sb = new storyboard();             storyboard.settargetname(da, "rotationy");             storyboard.settargetproperty(

i need control data logger pc via serial port. have limited programming experience , decided give small basic try automate process. have installed small basic 1.0 , smallbasicserialport, copied smallbasicserialport dll , xml files sub folder named lib. unfortunately not know here, cannot find instructions or settings refer serial communications. don't want spend time trying working , rather move platform if proves big issue. pity find small basic easy work far. appreciate advice this, if use programming platform. i've been used rs232c communication on dos-basic or decimal basic windows. year started use smallbasic. (because simple , interesting.)  and i'm  remaking programs smallbasic. i have executed serial communication (rs232c) smallbasic. goes well. this written assumption not informed serial communications. there important points serial communications. 1)first of all,  confirm whether personal computer has 1 or more  serialport(s). (confirm per

hi all, this may normal want make sure. i have encrypted data in table. can decrypt correctly without issue. here 1 row pkid =1 0x00f353374962954f9419c3641e96de610100000085a8516dbd9c95bbd256143ff1deb39825cbb8cc0cb8b164809303c335569fff9cca3d68543266f412b05c7022124bad0195f5229c7d24f89751d7527918b72f i executed below steps change master key. open master key decryption password = 'my0ldp@55word' go alter master key regenerate encryption password = 'mym0strecentnewp@ssword' go. everything executed successfully. below  encrypted data pkid =1  0x00f353374962954f9419c3641e96de610100000085a8516dbd9c95bbd256143ff1deb39825cbb8cc0cb8b164809303c335569fff9cca3d68543266f412b05c7022124bad0195f5229c7d24f89751d7527918b72f decryption working correctly. i notice encrypted data same old key , new key. normal. expecting different pattern in encrypted data after master key change.  thanks in advance, snaseer houston-tx read encryption hie

hi, getting issue replicating table , getting following error 'unexpected eof encountered in bcp data-file'. table consists of 8 int columns , 1 row. data going 2000 instance 2005. if appreciated [edited] forgot happening when creating snapshot thanks james hi, based table schema, doesn’t have xml data type field. try add useinprocloader parameter distribution agent , restarted agent. useinprocloader parameter improves performance of initial snapshot causing merge agent use bulk insert command when applying snapshot files subscriber. parameter not compatible xml data type and  cannot used character mode snapshots. additionally, if use parameter, sql server service account @ subscriber must have read permissions on directory snapshot .bcp data files located. if there more questions, please let me know. thanks. ***xiao min tan***microsoft online community*** SQL Server

hi, i can connect sql azure database via ssms,but when try connect sqlcmd. failed.here error msg: sqlcmd -s tcp:ux7mpolvl1.ctp.database.windows.net -u ksbsoft@ux7mpolvl1 -p xxxxxxx -d testdb msg 18456, level 14, state 1, server ux7mpolvl1, line 1 login failed user 'ksbsoft'. solved. the problem password. if password include special characters, example (%^&). cmd should (using ""): sqlcmd -s tcp:ux7mpolvl1.ctp.database.windows.net -u ksbsoft@ux7mpolvl1 -p " xxxxxxx " -d testdb Microsoft Azure  >  Azure SQL Database

  hi,   i have matrix defined in ssrs see top 20 elements of list per month , many months defined user via parameter history. trying use members:members define range on fly not understand why empty in following test:   params: @history set 2 , month parametert set 6   the main bulk of mdx is:   code snippet member [measures].[courant] membertostr([time].[month].currentmember)   member [measures].[history] "[time].[month].&[" + cstr(val(vba!mid([measures].[courant],18,1))-@history)+ "]"   set [setup] members([measures].[history]):members("[time].[month].&[" + [measures].[courant]+"]")     the select things show wrong 1 - code snippet select {[measures].[history],[measures].[courant]} on 0, {[setup]} on 1 [cube]   gives me empty line   2 - code snippet select {[measures].[history],[measures].[courant]} on 0, {[time].[month].[6]} on 1 [cube]     gives me expecting