Lun

i want setup database to new server machine. have backup copy of database files (data & log), lost master database existing server.   so have 2 ways of having database   1. restore backup 2. attach data files.   which 1 best option, when start afresh on new machine new master database. either method should work. prefer restore.   if file location (folder) different, may need add move option restore.   refer books online, topic: restore SQL Server  >  SQL Server Database Engine

new install of s14 on w12r2. not sure if relevant, default path changed during install wizard drive d:\, otherwise, nothing exotic. full admin on box , ntfs perms ok. attempting disable ip v6 , set static port 1433.  as title states, if attempt apply changes in sql config mgr error:  i not want go registry hacking (work-around) - want understand causing issue , how fix it.  edit: not apply recommended "fixes" provided below - not work (as of 9/19/16) hi cynep, did checked os team on regarding wmi error,because wmi wide , windows team might can further?. regards, s_no "_" SQL Server  >  SQL Server Setup & Upgrade

we got w2k8r2, sql2k8r2, 2 nodes, 8 instances, a/a c:\ = os+bin (local disc) d:\ = mount point container following mount points: data,log,tempdb,backup instance 01 (4 separate luns on san) e:\ = mount point container following mount points: data,log,tempdb,backup instance 02 (4 separate luns on san) etc untill instance 08 m:\ = mstdc (lun on san) w:\ = witness (lun on san) z:\ = backup (local disc) what best backup strategy? product use?   thanks vincent hu, microsoft contigent staff pointing out backup: http://blogs.msdn.com/b/john_daskalakis/archive/2009/02/27/9448408.aspx   i have backup on internal disk besides external backup solution, although pro's thinks ridiculous. anyway, means have have backup on both nodes instances, again means double up on storage usage. regards tonny /torpo hi tonny, if need backup solutions, recommend ola  hallengren's database maintenance solutions includes database backup/index defrag/integrity check functi

hi we has performance issue in db server hosted in virtual server. having sql 2005 ee sp2. there no blockings , open transactions in server. found below process(checkpoint) abnormal.   this checkpoint consuming more in cpu cumulative , io.  also found error in errolof sql server has encountered 69 occurrence(s) of i/o requests taking longer 15 seconds complete on file [d:\database\db.mdf] in database [db] (7).  os file handle 0x00000000000009cc.  offset of latest long i/o is: 0x0000094c000000 not sure prob. cn 1 on this. ... suspended                       sa   .   . master checkpoint        1125968 59460 that record found in error log says there activity on particular disk disk cannot handle. if it's san disk, may want add new disks raid solidify disk, or problem firmware of hba or hba itself; otherwise, if it's local disk may want move database faster san disk. ekrem Önsoy - mcdba, mcitp:dba & dbd, mcsd.net, sql server m

i've added check constraint table prevent bad data being loaded ssis. when run package using fastload variable destination table, rows being rejected not violate check constrant. the aim able re-direct rows in data warehouse exception reporting users can fix bad data @ source. the constraint added "date < 2012-06-25" last date in source data. when run ssis check constraints enabled, rows being redirected have dates of "2012-06-05" , earlier (note in case here, american style dates constraint wouldn't violated). a similar thing happened when tried test constraint on integer column, 3 rows should have been redirected, of rows violated key constraint. i set batch size 1 row check every line of data , still same problem. anyone seen before or have ideas what's wrong? if helps, source sql 2000 sp4 , destination sql 2008 r2. d: wow, boo boo on part. dates filtered correctly constraint, written output table wrong dates because datef

i working on sql service broker application , trying determine best design use.  i trying decide if better use centralized message forwarding service ( or dynamic routing service) distribute messages correct target ssb service.  i intending have different sql databases contain data different clients.  each database have service can accept these messages, given message relevant 1 of database.  so question better put logic deciding client ssb service foward message through , funnel message through service?  or better have wcf web service @ message contents , determine client ssb service submit message to? what best practice ssb , distributed handling of messages? any direction appreciated. theregit - mcse, mcdba, mcts: web i wanted let know purchased book pro sql server 2008 service broker apress. ( http://www.amazon.com/pro-server-2008-service-broker/dp/1590599993 )  reading through book reading blueprint wanted accomplish.  highly recommend it.  after reading through

while exporting sql data excel, issue occurs, can me how fix this? hello, did use sql server 2012? issue may caused bug in ssms 2012, please refer follwoing connect , workarounds solve issue: https://connect.microsoft.com/sqlserver/feedback/details/772761/dtswizard-in-sql-2012-sp1-no-longer-recognizes-nvarchar-varchar-data-types-when-source-is-a-query regards, fanny liu fanny liu technet community support SQL Server  >  Getting started with SQL Server

i getting error when using   transferring data oledb source  to excel destination i using dynamic file connection means each time new file generated @ desination folder getting error given above path stored in variable @[user::path] :c/admin/ for creating excel file using expression excelfile path: @[user::path] +(dt_str,4,1252) datepart("yyyy",getdate()) +right("0"+(dt_str,4,1252) datepart("m",getdate()),2) +right("0" + (dt_str,4,1252) datepart("d",getdate()),2)+ right("0" + (dt_str,4,1252) datepart("hh",getdate()),2)+right("0" + (dt_str,4,1252) datepart("mm",getdate()),2)+right("0" + (dt_str,4,1252) datepart("ss",getdate()),2)+".xls" now when clicking on exceldestination component mapping getting error ================================= error @ insertingdatafromexcel destination [excel destination [113]]: ole db error has occurred. err

hi must prepare replication between 2 servers. 1 serwer (a) production serwer , second serwer (b) serwer used reporting , archiving data. once week  data implements criteria must deleted  serwer not serwer b. best scenario this. think transactional replication how can delete data publisher , leave on subscriber? thanks. either delete through stored procedure , replicate execution of stored procedure , make stored proc on subscriber no-op, or change delete command none in sp_article statement. 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-server-2008/dp/1430215941 SQL Server  >  SQL Server Replication

we building series of cubes , trying find elegant way of dealing aged data (i.e. removing it).  documentation on subject seems sparse.  ways looking @ doing either load data fact partitions drop after period of time or alternatively trying 'discard' data cube partitions.   q. possible delete dimension data in cube only?  xmla 'drop' command appears force relational source dml , not possible e.g. when using processadd load data or when using named query.   q. if set dimension errorconfiguration.keyerroraction = discard record , run processadd on partition, loaded data in partition discarded there no associated record in the dimension? q. there way 'split' existing partitions?       q. possible delete dimension data in cube only?  xmla 'drop' command appears force relational source dml , not possible e.g. when using processadd load data or when using named query.   you cannot delete data dimensions, can add, update or rebuild them scr

hi,   i have used expression in report title textbox control. have created few hidden fileds in body of report. based on few conditions trying display title different values hidden fields. most of time title coming blank, when there single record or less 2 or 3 records, title coming fine. not able find exact reason unpredictable behavior. we using ssrs 2005 (sp2) any in regards appreciated.   regards kishore okey, workaround is, can create 3 parameter in report , logic can put outside (report calling code/program) and call report these parameters. you can assign parameter header textbox. not sure work requirement. thanks bipin. p | ernst & young ssc SQL Server  >  SQL Server Reporting Services, Power View

hi friends, i unable drop user , getting below error mesage, restored db different environment/ msg 15138, level 16, state 1, line 1 database principal owns schema in database, , cannot dropped. hallo maddy, you'll find owners of schemata following query: select s.name, p.name sys.schemas s inner join sys.database_principals p on (s.principal_id = p.principal_id) before can drop database user have drop owned schema or change owner of schema alter authorization on schema::schemaname newowner more details authorization here: http://msdn.microsoft.com/en-us/library/ms187359.aspx uwe ricken mcitp database administrator 2005 mcitp database administrator 2008 mcitp microsoft sql server 2008, database development db berater gmbh http://www-db-berater.de SQL Server  > 

hi, i have ssis package connecting analysis services. following error: source: process cube analysis services execute ddl task description: connection cannot made redirector. ensure 'sql browser' service running. the environment: --------------------- two named ssas 2005 instances on windows cluster ssis 2005 windows server 2003 x64 sp2 no sql database engine my findings: ------------- verified sql browser service (bs) running using admin > services verified sql browser service (bs) running using sql server configuration manager unable see bs in sql surface area configuration? any help? thanks i moved post ssas forum, seems more of issue ssas environment setup ssis. can connect ssas other tools successfully? john welch | www.mariner-usa.com | www.agilebi.com | ssisunit.codeplex.com SQL Server  > 

the alert explorer powertool enables creation of email notification tfs on various events, among others upon assigning work item me. the sent email in such event, contains link work item assigned me, link web access form of work item, i.e. clicking link opens work item in tfs web-access within internet explorer. i wonder if there's possibilty create email notification, within link point work item within visual studio, i.e. clicking link open visual studio (if not open) , focus within visual studio on work item assigned me. way more natural progammer upon getting notification work item assigned him, work item directly within develop env (i.e. within visual studio) rather locating manually after work item presented in web-access. if there such possibilty, can find simple instructions how implement, better yet example showing how to. thank u. i don't have examples share, should able using tfs api.

  recently 1 of developers has left our company , forgot check in couple of files including project file well. as result, every time needs amend project have message like cannot lock item $/ehealth/hr/hr.admin/hr.admin.vbproj.vspscc check-out.   this item checked out developer2 in workspace dilshodkh.   how can override lock – don’t need change , account deleted ad?   thanks in advance   just in case if has similar issue goto tfs server http://localhost:8080/versioncontrol/v1.0/repository.asmx select deleteworkspace link supply name of workspace holding locked files owner account press invoke button delete workspace after - lock entire project if no more active locks enywhere - owner of whole project. check in , happy.   Archived Forums V  >  Team Foundation Server

does microsoft officially support same server replication of db 2 different instances?  from previous forum postings see can done question more if microsoft support in production environment? thanks, vic yes, microsoft keep in mind there limitations, example workgroup edition has 25 merge subscribers , 5 transactional subscribers , sql server express can't publisher. 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-server-2008/dp/1430215941 SQL Server  >  SQL Server Replication

i want create website replicates outlook's calendar functionality.  (a scrollable month view centered on current day, week view , day view) my question is, should use silverlight this?  wpf, webforms? should use asp mvc this?  what pros & cons?  are there third-party or open source code packages may have functionality out of box?  it need ajax rich...will need use javascript packages?  what ones? lots of questions, but, appreciate knows can me started on right track... thanks http://forums.silverlight.net/forums/t/18805.aspx http://forums.silverlight.net/forums/p/115210/316773.aspx http://www.vectorlight.net/silverlight/controls/calendar.aspx Silverlight  >  Programming Silverlight with .NET – General

hello experts, i createing one task (user control) in ssis. have property grid in gui , 2 buttons (ok & cancle). propertygrid has properties sourceconnection, outputconnection etc....right able populate connections in list box next source , output property.   now question guys depending on source connection should read text file associated connection manager. after validation should pick header (first line of text file bases on record type) , write new file when task executed. have following code reference. please let me know going in right direction or not.. what should go here ? ->under class a public override dtsexecresult execute( connections connections, variabledispenser variabledispenser, idtscomponentevents componentevents, idtslogging log, object transaction) {   //some code read file , write new file return dtsexecresult .success; }   public const string property_task = "customerrorcontrol" ; public const string pr

  hi there, i'm writting small program in visual c++ (mfc) can interact pervasive sql database. i connect sql database using odbc link. i have been able run  standard sql queries using crecordset to retrieve records tables , display them on listcntrl etc  with no problem. example (so undersatnd better trying do) /////////////////////////////////////////////////////// crecordset rs(&cdatabase); cstring cs; cs = "select stockcode stock stockcode= '               1'" ; if (rs.open(crecordset::forwardonly, cs)) {     for ( int = 0; < rs.getodbcfieldcount(); i++)     {         rs.getfieldvalue(i, cstring);     } } ////////////////////////////////////////////////////////////   one of tasks able delete dertain records table (based on criteria, ex: stock code = 10) i can't seem code work, have read msdn , tried implement that. "invalid argument value" error. following is code  ////////////////////////////////////////////////// c

i installed sql server express trail 3 times each new instance. came know need have default instance. un-installed sql server express , tried install again. still says have installed instances , if select default instance option buttons un-checked , disabled. tried delete folders related sql server installationa dn tried still see same thing. please me in istalling default instance.   thank you. sql server express installs "named" instances called sqlexpress. jens k. suessmeyer. --- http://www.sqlserver2005.de --- SQL Server  >  SQL Server Express

hi, i'am having problem getting powerpivot excel workbooks show snapshots in powerpivot gallery. i've done steps of post "http://social.msdn.microsoft.com/forums/en-us/sqlkjpowerpointforsharepoint/thread/a90495b1-70e6-40d4-8a23-9e926cc30ed7" gemini.log different: 12/4/2009 3:16:05 pm :  teste pp 5.xlsx -  added in  poerpivotfiles  located at  http://win-g2nc9iudq1l  by   sharepoint\system  .  . 12/4/2009 3:16:05 pm :  teste pp 5.xlsx - refresh/update loop succeeded! (vti_snapshots)  . 12/4/2009 3:16:08 pm :  teste pp 5.xlsx -  updated in  poerpivotfiles  located at  http://win-g2nc9iudq1l  by   sharepoint\system  .  . 12/4/2009 3:16:08 pm :  teste pp 5.xlsx - pending operation detected  . 12/4/2009 3:21:05 pm :  teste pp 5.xlsx - success: getsnapshot self-terminated (after 299.615137 seconds)  . 12/4/2009 3:21:05 pm :  teste pp 5.xlsx - parsing .info file (c:\windows\temp\28741a2b_3f7e_48b4_b284_53fd8e2e8703.info)  . 12/4/2009 3:21:05 pm : error: tes

hi all!,                i'm new mvvm pattern. i'm using silverlight 3.0, prism 2.0. i want consume wcf service mvvm pattern. how can achieve this?. please me. thanks in advance, k.navaneethapperumal hi, http://forums.silverlight.net/forums/t/214404.aspx http://forums.silverlight.net/forums/t/212764.aspx hope help. regards Silverlight  >  MVVM / ViewModel Pattern with Silverlight

hi i using sl4 , business application template.  i have folder on server contains files (jpgs, word docs, excel docs etc) and directory store holds paths of these files.  this list displayed on 1 of silverlight webpages.  possible for user select file want , download it?  if so, what need achieve this? if not, approach need take? folder of files acquire new files regularly, may on daily basis, needs quite flexible. any appreciated. thanks adam make sure have located files in sub folder of web application. example: web application's location c:\myprojects\myapp, example place files in c:\myprojects\myapp\files. then note url shown in browser application. http://localhost/myapp/mysite.aspx. can build path files combining information, e.g. http://localhost/myapp/files/ "root" folder of files repository. to avoid run problems when move application server, there various methods dynamically retrieve path of current web application. starters, can leave

when attempt uninstall ms sql server 2008 native client windows 10 machine presented error "this action valid products installed." i suspect that there earlier attempt @ uninstalling client failed complete there pieces of client still left, not detected windows installer , prevents following uninstallation attempts succeeding. how resolve this? hi tom, please run msiinv.exe , smartmsizap tool clean sql server components(including sql server 2008 native client) left behind on machine. detailed steps process, please review similar blog . however, if issue still persists , have 1 instance on machine, please perform following steps manually uninstall sql server 2008 components. 1. make sure have administrative rights on computer. 2. uninstall existing sql server 2008 , components control panel. 3. backup registry. 4. delete following keys in regedit: --hkey_local_machine\software\microsoft\microsoft sql server --hkey_local_machine\software\microsoft

i had "twice" have surface exchanged due freezing problems. has nothing sleeping issues. experts @ store in mission viejo ca. told me second time appears application problem. 1 of operating files being wiped out? told last time (over month ago) developmental manager in store working on issue , me cause. called store yesterday , talked manager. told me person assigned task call me in 15 min. of sunday 3rd have not heard anyone? big red flag. issue no 1 wants talk about. in mean time cannot load application onto surface in fear freeze again. each time gets exchanged costs me several hours info lost. bought business tool me in field perform work. use excel spreadsheet , after 6 hours of input (saving every 5 min.) surface froze again. time came after restart. after $1000.00 cost unit, insurance, , of other stuff, nice if tell me issue before fails again in middle of project , loose 6 hours work?? there lot of smart guys @ microsoft, have believe has answer, share?  

hi, now trying upgrade sql server 2008 express edition sql 2012 enterprise edition. on machine 2 instances exists(default instance in stopped + named) task upgrade named instance. while upgrading through wizard, there no option\page\phase select instance name. if begin upgrade both instances upgrade?. (microsoft sql server 2008 (sp1) - 10.0.2531.0 (intel x86) express edition). please suggest.  syed jakeer your os may 64 bit, sql server express instance not. (microsoft sql server 2008 (sp1) - 10.0.2531.0 ( intel x86) express edition). SQL Server  >  SQL Server Setup & Upgrade

1)sys.sp_check_log_shipping_monitor_alert is system store procedure created automatically after log shipping setup? if automatic, store procedure do? it runs every 5 minutes on server. cause fail? 2) lsrestore job executing job history.anything need ? 1)sys.sp_check_log_shipping_monitor_alert is system store procedure created automatically after log shipping setup? i guess so.to check, go server on logshipping not configured .go msdb ..programability..stored proc..can fin proc ? easy way check if automatic, store procedure do? read below link does http://sqllearnings.com/2012/04/10/log-shipping-alerts-do-you-know-how-it-is-generated/ it runs every 5 minutes on server. cause fail? 2) lsrestore job executing job history.anything need ? it must not executing ,i guess must executing long time.it can happen if heavy logging operation index rebuild,huge dml.sometiimes due network flip ,i have see, restore job keeps on running when has restore huge log re

im trying import .bacpac file have uploaded storage account(standard). but when im trying select storage account none of accounts show up, list list empty. im using standard storage account in same resource group. have tried using classic storage account no luck. im following guide: https://azure.microsoft.com/en-us/documentation/articles/sql-database-import any suggestions? hey tomas, using new azure portal that's mentioned in doc following ( portal.azure.com) or older azure management portal (manage.windowsazure.com)? can reach out me @ vinsonyu[at]microsoft.com? thanks, vin Microsoft Azure  >  Azure SQL Database

trying create sql database , failing continuously , not succeeding. tried different locations southeast asia , westus in case regional issues no luck. says below " could not submit request create database 'settlements'. not sure if doing wrong. neways above isnt useful.  hi, apologies inconvenience. are trying create database management portal ? edition [basic, standard] database choosing? subscription [pay go] do have ? regards, mekh. Microsoft Azure  >  Azure SQL Database

hi chaps, i need compare 2 role playing date dimensions within calculation. i have dimension [order date] , dimension [product active]. both are linked same measure group contains orders, order date directly , product active dimension attribute of product. in order evaluate "an order" order date needs compared product active date. in sql terms order date <= product active date. what best performant solution compare such 2 dates (maybe there generic article discusses >= , between etc between dates) business intelligence professional you can use filter function , compare on keys. http://www.ssas-info.com/analysis-services-faq/27-mdx/76-how-compare-members-from-different-dimensions-that-have-the-same-key-values you can use  [].[].currentmember.membervalue <= [].[].currentmember.membervalue within filter function  some example of filter having here http://www.databasejournal.com/features/mssql/article.php/3662721/mdx-clauses-and-keywords-use-having-

hello, on windows 2008 r2 ps1 server, ms sql server 2005. running installation (*.msi), performing sql script writes value registry key: - running user administrative rights, logged in - writing registry succeed; - running during session 0 (no logging in) as temporary user, impersonated administrator - writing registry fails - "access denied". what cause denial? any suggestions appreciated, sergy s. first of all, thank attention , time. appreciate that. additional information regarding issue: the msi log error is: "error 27506: error executing script _105_set_login_auditing.sql. line 26. regcreatekeyex() returned error 5, 'access denied.' (22002)" the script 26 line is: "exec xp_instance_regwrite n'hkey_local_machine', n'software\microsoft\mssqlserver\mssqlserver', n'auditlevel', reg_dword, 3" (please assume there no syntax errors in quotation marked text - it is typed manually, since c

i have number of flat file connections in ssis package , using config file.   need change value of connections \\servername\folder\folder\abc_039.tab \\servername\folder\folder\abc_139.tab  - i've changed in config file, saved & restarted, doesn't pick in connections.  i've changed connections directly, , works until save, reverts _039.tab again.   ideas?  i've switched off package configurations, changed connections directly, , again, revert when save.  found answer - within connection properties, had set expression read , set folderpath part of filename, appending _039.tab that.  obviously, @ run time overwriting had set. SQL Server  >  SQL Server Integration Services

hi guys, i unable post anything on create.msdn.com forums trying luck here... i trying write image captured to a sql ce database , read in image on control, getting black image. help? here did far [column] public byte[] itemimage { { return _itemimage; } set { if (_itemimage != value) { _itemimage = value; notifypropertychanging("itemimage"); notifypropertychanged("itemimage"); } } } public void addnewitem(stream image, string url) { byte[] bytearray = null; using (memorystream ms = new memorystream()) { writeablebitmap wb = new writeablebitmap(200, 200); wb.savejpeg(ms, 200, 200, 0, 60); bytearray = ms.toarray(); } shopitem item = new shopitem { count = 1, ite

suppose,we generate x template in excel, need send user.they send data based on template.once data , load database.suppose if user forgot send data.we need remind user. schedule everytime process in ssis please suggest me, how control flow , data flow works? how can remind user? the file size of template , out data daffer, right?   so, file size using script task using length method of system.io.   if file size equals template's size, warn user.   tell me if got ur requirement correctly or not. SQL Server  >  SQL Server Integration Services

we have 3rd party application, connecting database hosted on sql 2005 cluster. having issue couple of users getting error messages below. error: sqlexecdirect: "srvterm [08s01] [microsoft] [odbc sql server driver]communication link failure" the 'srvterm' table in database. odbc connection on users pc has been confirmed connect database. we have had network issues fibre cables though had resolved issue, however, error has remained couple of users. is network issue or application\database issue? any grateful. the communication link error typically network issue can occur if connection terminates abruptly due unexpected error access violation in sql engine.  check sql server error log rule out.   since error occurring a few clients, expect probable cause problem in network connectivity. -- hope helps.   dan guzman sql server mvp http://weblogs.sqlteam.com/dang /  

i have report needs exported excel. prints in landscape , page size 17 width * 11 hieght , 1 of standard page sizes in use. i set right properties in page size , set orientation land scape in report properties ,interactive sizes , page sizes both set 17 , 11 . but when  the  report exported excel not recognizing  orientation , page size.other page sizes have tested works 11* 17 doesn't .waht noticed moment page size set 11 * 17 , paper size set tabloid..... is it  causing exported page not recognize page type   no takers ?? ka SQL Server  >  SQL Server Reporting Services, Power View

hi everyone, i wanted create temporary time limited link ( url ) allow user download data link , expire after 24 hours.in regards workflow follows create temporary link , email user link download data 24 hours link . user clicks on link after 24 hours , should link expired. now question is, as emailing user url , can work out programatically when user clicks link ? my second question , how make link expire after 24 hours ? can me ? appreciated. regards, josh i don't think there ready-made solution that, shouldn't hard implement (wcf) service , database @ server side - if client can deal redirections. when need create link page (say, http://a.b.com/c/d ), you'd create random link in service ( http://your.service.com/path/redirectingservice.svc/getlink/abcdef ), store in database new row following information: original link (a.b.com/c/d), expiration date (now.adddays(1)), random link (abcdef). you can return link service ( http://your.service.co

hi guys, i have researched extensively , cant find exact result looking for. i have 3 fields of names in sharepoint list , set parameter based upon these names. i want maintain unique values , not join them i.e. name 1, name 2 current fields example: name field 1 name field 2 name field 3 person 1 person 3 person 5 person 2 person 4 person 6 what want parameter be: person 1 person 2 person 3 person 4 person 5 person 6 i need user of report able select person want in parameter , able filter 3 columns based upon parameter. i quite new this, aware may not make sense, please gentle :) hi dg85, in reporting services, parameter available values can specified in 2 ways, 1 specify manually , 1 values query. when select values query, can specify 1 dataset , 1 field. in scenario, want parameter available values multiple fields cannot achieved in reporting services currently. thank un

hi all, i'm trying measure display except dimension payment method = direct debit or renewal payment method = direct debit i.e. payment method    renewal payment method    result direct debit            cash                                       null direct debit            direct debit                            null cash                        direct debit                           null cash                        cash                                    1 (i'll replace 1 calculation on measure) cash                        cheque                                1 its counting how many still have converted payment method direct debit. i thought might this; iif([payment method].[payment method].currentmember [payment method].[payment method].[direct debit],0, (iif([renewal payment method].[renewal payment method].currentmember [renewal payment method].[renewal payment method].[direct debit],0, 1)) which hoping follow logic; if payment method = direct debit, measure = 0, else if r

hi, i need adding data share point list through silver light controls/datagrid. have share point list employees , want add data custom list through silver light registration form having silver light controls. can me  hi shraddha,                     check these links forum.where had suggested approaches. http://silverlight.net/forums/p/22091/77622.aspx http://silverlight.net/forums/p/21200/74097.aspx Silverlight  >  Programming Silverlight with .NET – General

hi, i have foreign key relationship between 2 tables [location] , [user].  the [location] table has fields [id] , [description]. the [user] table has fields [id],[firstname],[lastname],[location_id]. binding datagrid follows:   datagrid1.itemssource = dc.users; dc.load(dc.getallusersquery());   in previous application using linq sql , not using ria, i able bind field in xaml datagrid using notation somelike following: < textblock text= "{binding location.description}" margin= "4" />  this not appear work when using ria services entity data model. possible ria services? i have gotten around problem "include" arrtibutes in metadata of data service know if possible? thanks in advance. this work in ria i'm using quite heavily.  if have include attribute in metadata , include table name in query e.g. this.context.users.include("locations") should ok.

hi folks i have database contains monthly tables contain sales data  each month want extract sales data previous months table.  i.e  on 1st of march 2013  i want  schedule ssis package run load february data database. on april 1st want load march data , on.  i.e tables in database have name structure follows  sales_2012_11 sales_2012_12 sales_2013_01 sales_2013_02 sales_2013_03 what best way connect previous months sales table? because needs be scheduled package, want avoid having update table name in select statement in source connection manager.  any suggestions welcome regards stevo if data in different tables make the source table (or complete source query) dynamic. create ssis variable type string , add expression. like: "sales_" + (dt_wstr,4)datepart("yyyy", dateadd("mm", -1, getdate())) + "_" + right("0" + (dt_wstr,2)datepart("mm", dateadd("mm", -1, getdate())), 2)

hello, have ssis package load flat file sql server 2008 db...the package work fine in bids , when automate in sql server agent job works fine file not deleted in location folder supposed be. suggestion on this? support when people report works fine in bids fail in sql agent, means permissions thing. check sql agent service account has proper permissions delete location. if network share, may need specify share permissions along folder permissions. if not solve issue, can respond error message? todd c - mscts sql server 2005 - please mark posts answered appropriate. SQL Server  >  SQL Server Integration Services

hi, i have 1 table 10 columns, want update columns,(i mean u don't know particular column) which column may come update u don't know want update columns using oledb command how have write query regards arjun mallis actually, new coming data may file, table etc. in case need use transformation , ole db commmand. if records new, insert  them destionation table, , if records existing, update destination table. following link helpful on this: http://www.simple-talk.com/sql/ssis/implementing-lookup-logic-in-sql-server-integration-services/ thanks, hsbal SQL Server  >  SQL Server Integration Services

hi ,, having problems uri containing % sign. setting uri mediaelement source property, , trying start the mediaelement. generates mediafailed event. same problem uri containing single quote.   q: uri containing % or single quote invalid uri ???    hi stevie, the % sign has special meaning in urls because used called url encoding. don't think single quote required encoded. if want use % sign part of url, need replace %25. single quote can encoded %27. complete list, see here . can encoding programmatically using urlencode method of silverlight. Silverlight  >  Silverlight Controls and Silverlight Toolkit

we had our dba leave , after reports started failing.  the subscriptions stuck in pending status.  i created new subscriptions 1 of reports , scheduled @ 1:30pm.  right after status of subscription changed pending status.  i manually ran sql agent job subscription created , nothing changed.  we in sharepoint integrated mode.  i new ssrs , sharepoint.  any leads on how fix issue? thanks time , idas cbarus did check current service account access on report server ? can schedule subscription credentials , see results.thanks, SQL Server  >  SQL Server Reporting Services, Power View

i have run exec xp_msver on sql server management studio please can tell me edition of sql server 2005 using... is enterprise edition or express edition. thanks in advance regards, pranav 1    productname    null    microsoft sql server 2    productversion    589824    9.00.1399.06 3    language    1033    english (united states) 4    platform    null    nt intel x86 5    comments    null    nt intel x86 6    companyname    null    microsoft corporation 7    filedescription    null    sql server windows nt 8    fileversion    null    2005.090.1399.00 9    internalname    null    sqlservr 10    legalcopyright    null    © microsoft corp. rights reserved. 11    legaltrademarks    null    microsoft® registered trademark of microsoft corporation. windows(tm) trademark of microsoft corporation 12    originalfilename    null    sqlservr.exe 13    privatebuild    null    null 14    specialbuild    91684864    null 15    windowsversion    170393861    5.1 (2600) 16    processorcount    1    1

  hi,   in package have 50 data flow tasks ole db sources , destinations in them. every time when insert error between source , destination occurs want handler write errand records log table.   1 solution attach ole db command log writer procedure error output of each ole db destination. have make 50 times cause have 50 dataflow tasks.       use 1 general handler whole package.       logic be: dataflow (ole db source->ole db dest) on record insert error , package error handler writes record log table.       idea? thanks!!     greetings no planet! hi you can 1 thing, put 50 data flow tasks in sequence container in control flow , generate 1 event log handler sequence container. inside sequence container, if want run 50 data flow tasks no matter 1 fails, join them via completion precedence constraint.   SQL Server

hi,       1 pls tell me out page settings report  showing in 3 pages. did page settings a4 landscape seeing in print layout showing in 7 pages. pls me solve issues ot report in 3 pages. thanks, abdul2010 hi abdul2010, from description, there might 2 main reasons affect number of pages. first, without page settings, paper size letter , orientation portrait default. when change them a4 , landscape in report properties, report height reduced fewer rows can displayed in page , more pages required display whole report. second, reportviewer omit margins settings in report properties in preview layout, never in print layout.   so causes increase of page number in print layout. another concept in ssrs divides pagination logic pagination , physical pagination setting interactive size property. property controls page breaks on web pages. more information, can refer to: http://blogs.msdn.com/b/bwelcker/archive/2005/08/19/454043.aspx hope helps. if unclear, please let

is sql server import , export wizard included express versions of sql server? i'm running sql server express 2005. thanks. no. here topic discussing situation: http://social.msdn.microsoft.com/forums/en/sqlexpress/thread/944ca507-0c06-4494-bd3a-601b047ee1db ----------- starwind software developer ( http://www.starwindsoftware.com ) SQL Server  >  SQL Server Tools

hi all, i facing problem on publication database, updating identity check constraints fails on publisher. i have 2 tables in publication database  --> book , book_log , book table has insert/update/delete log triggers book_log, both have identity(1,1) pks. and users access server db_owner . occasionally below error happens: the insert failed. conflicted identity range check constraint in database 'library', replicated table 'dbo.book_log', column 'book_logid'. if identity column automatically managed replication, update range follows: publisher, execute sp_adjustpublisheridentityrange; subscriber, run distribution agent or merge agent. statement has been terminated. source: .net sqlclient data provider targetsite: void onerror(system.data.sqlclient.sqlexception, boolean) helplink.prodname: microsoft sql server helplink.prodver: 10.50.4000 helplink.evtsrc: mssqlserver helplink.evtid: 548 helplink.basehelpurl: http://go.microsoft.com/fwlink he