Lun

 hello experts, my comapny uses sql server 2008 r2. not planning change our database sql 2012 : we want create our ssas/ssrs project using sql server data tools. use ssdt currenlt ssas/ssrs projects. can please guide me pros , cons of doing so?  thanks & regards, chaitali thaker you better answers in respective ssas , ssrs forums, current focus of forum around ssdt database projects aspects. ssas: http://social.msdn.microsoft.com/forums/en-us/sqlanalysisservices/threads ssrs: http://social.msdn.microsoft.com/forums/en-us/sqlreportingservices/threads ssis: http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/threads your question directly related capabilities of bi project systems ssas, ssrs , ssis, specificly around topic of multi-targetting support. this understanding respective multi-targetting support of sql server 2012 bi project systems hosted inside sql server data tools: ssas multi-dimensional projects support deployment down level s

hello, i'm writing since got strange problem.... use wcf services net.tcp, , decided use businness model login procedure (based on ria)...to keeping things simple not able reach webservice ... while debugging application.g.web file noticed svc called under /clientbin/project-authenticationservice.svc/binary getting following error : the provided uri scheme 'net.tcp' invalid; expected 'http'. parameter name: context.listenuribaseaddress i removed in iis'configuration -> webapplication -> advanced settings-> enabled protocol -> "net.tcp" , worked... first http .... can't use authenticationservice in web application uses net.tcp? thanks hi pponzano, please compare steps these 2 links.   http://www.42spikes.com/post/using-silverlight-4-and-nettcp-duplex-callbacks.aspx http://www.silverlightshow.net/items/wcf-net.tcp-protocol-in-silverlight-4.aspx best regards, jonathan 

hi! i'm having same problem person had in post except don't know goat "sqlexprnt.x86.enu" installation. http://social.msdn.microsoft.com/forums/en-us/sqlsetupandupgrade/thread/d759289b-e8a6-43f7-a9e3-d2346fc2690b/ i installed sql server express 2008 database. want add the management studio express. after running installation , follow steps, in "installation type window" i select "add features existing instance of sql server 2008". i select instance "by default called sqlexpress" , press next. the feature selection window appears , ssms not appears ther, appears the features already have. i runned installation , nothing: microsoft® sql server® 2008 management studio express (sqlmanagementstudio_x86_enu) http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b microsoft® sql server® 2008 express tools (sqlexprwt_x86_enu.exe) http://www.microsoft.com/downloads/details.aspx?fam

new thread. i tried following/have info on prior long thread on issue ... > extracted sp-1 > ran js script (info below) > re-ran sp-2, failed. (info below) > (dts9_hotfix_kb921896_sqlrun_dts.msp.log info below)   js script output below ===================================================================== d:\hotfix_2175\x86>cscript repairmspsource.js "d:\hotfix_2175\x86" microsoft (r) windows script host version 5.6 copyright (c) microsoft corporation 1996-2001. rights reserved. found patch located at: d:\hotfix_2175\x86\hotfixas\files\sqlrun_as.msp attempting repair local cache patchcode "{731ac539-10a2-4073-add2-49f74ed65ee6}" no action can taken patch has not been applied on local machine. found patch located at: d:\hotfix_2175\x86\hotfixdts\files\sqlrun_dts.msp attempting repair local cache patchcode "{8b7e2749-624e-4c61-92fc-2bc18307ff24}" d:\hotfix_2175\x86\repairmspsource.js(159, 17) msi api error: patchproperty,propert

we running powershell version 2.0 script in job on sql 2008 sp2 - 10.0.4064.0(x86) instance, on windows server 2003 r2 sp2.   using a script run microsoft best practice policies against 1 sql 2000, 13 sql 2005, , 15 sql 2008 servers, using invoke-sqlcmd command.  the script looks through servers , policies.  sql 2000 server contains 7 databases, sql 2005 servers contain total of  601 databasea , sql 2008 server contains total of 274 databases.   when run script, takes 7 1/2 hours complete.   if run 2 custom policies check 1) job failures(which 1 server level check per server) , 2)databases backups (1 each database), runs little on hour.    there anyway speed these up?  hear others have experienced , alternate solutions have found. you can deploy policy 2008 servers froom cms.  execute on target servers. tom sql server mvp toronto, on canada SQL Server

0 i added new dimension cube.it has partitioning. and throwing error below.: sending deployment script server... error -1056964601 : internal error: operation terminated unsuccessfully. error -1056571392 : ole db error: ole db or odbc error: invalid column name 'ea_project_group_sk'.; 42s22. error -1054932978 : errors in olap storage engine: error occurred while processing 'bienn_03' partition of 'audit trail' measure group 'hmi modifiedfinance' cube hmi_finance database. error -1055129594 : server: current operation cancelled because operation in transaction failed. deploy complete -- 4 errors, 0 warnings ========== build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== deploy: 0 succeeded, 1 failed, 0 skipped ========== how fix can start reading new column? thanks if using query binding in partitions need update of partition queries bring in column new dimension. http://darren.gosbe

i installed visual c# 2008 express , installed sql server 2008 express.  when in c# , try add item, don't see option add sql server 2008 database, see sql server compact edition database option.  have add sql server 2008 database project. thread resolved in thread below. http://social.msdn.microsoft.com/forums/en-us/csharpgeneral/thread/60a075dd-09ba-4e75-9f8f-e0a3b31dd129 asp.net mvp, mcpd web c#, mcts tfs, mcitp bi , dba SQL Server  >  SQL Server Setup & Upgrade

hi all, i trying move service other server azure. service has 3 main parts: - sql database (where information stored) - android app (generates information , stores in sql database) - web page (shows data stored in database) i have allready succesffully made changes in android app use azure mobile services, , tables data alredy shown in sql database. now trying implement web page. this, followed tutorials (http://www.windowsazure.com/en-us/documentation/articles/web-sites-dotnet-deploy-aspnet-mvc-app-membership-oauth-sql-database/ and http://www.windowsazure.com/en-us/documentation/articles/web-sites-dotnet-get-started/) not access tables used mobile service. examples use tables using schema "dbo", , tables under schema (with name of mobile service). i have tried following (without success): create new login , user azure sql database default_schema 1 of mobile service change default schema in web project (using solution: http://social.msdn.microsoft.c

is there's way change location of server ? i have received azure invitation code , found "usa - northwest" not available anymore creating azure project... have sql azure database in 1 datacenter , windows azure projects in ! sql server empty (i've created database, , cleaning scripts create tables) don't have "migrate", deleting , recreating server ok. hi mcarbenay,   there migration tool available shortly migrate azure app usa-northwest to region. please review http://blogs.msdn.com/windowsazure/archive/2009/08/04/migrating-from-usa-northwest.aspx  for more information. thanks, abi Microsoft Azure  >  Azure SQL Database

hi, does know how pull information usb port sql server directly ? you can using labview middle man , labview can insert data sql server directly. refer: http://www.ni.com/labview/whatis/ you can install driver convert usb port com port , labview can read weight information , insert data sql server. refer: http://www.ni.com/toolkits/lv_db_conn.htm thanks! SQL Server  >  SQL Server Tools

i have table orders .where there million rows in .i need add pationed index on order store data in 1 of 2 files based on new islocked field.but when checked table there non clustered index on islocked column.islocked field consists of 1 , o's.can guys suggest me best approach. create table [ orders ]( [ orderid ] [ int ] identity ( 1 , 1 ) not null , [ orderno ] [ varchar ]( 50 ) null , [ accountno ] [ varchar ]( 20 ) null , [ completedate ] date null , [ lastupdatedate ]) date null , [ accountid ] int null , [ iswarranty ] [ bit ] null , [ isemailaddressfound ] [ bit ] null , [ islocked ] [ bit ] not null , [ linkorderid ] [ int ] null ) but there a create nonclustered index [ ix_islockedaccountid ] on [ coe ].[ orders ] ( [ islocked ] asc , [ accountid ] asc ) include ( [ orderno ], [ completedate ], [ lastupdatedate ]) with ( pad_index = off ,