Lun

i'm using dacfx public model try , manipulate dacpac file before deployment. @ moment i'm using bits , pieces tutorial ( http://blogs.msdn.com/b/ssdt/archive/2013/12/23/dacfx-public-model-tutorial.aspx ) copy existing dacpac new dac pac - without alterations. tsqlmodel model = newtsqlmodel(originaldacpacpath); tsqlmodel deploymodel = newtsqlmodel(model.version, tsqlmodelextensions.clonemodeloptions(model)); var = model.getobjects(dacqueryscopes.all); foreach (tsqlobject tsqlobject in everything) { string script; if (tsqlobject.trygetscript(out script)) { deploymodel.addobjects(script); } } addobjects call throwing dacmodelexception following message:  "error sql46021: trigger not allow database name specified." think exception thrown when try , add next item after bad item has been added,  can't figure out object causing problem. have order objects being added new dacpac?  or doing wrong? i'm ...

hi, please help  trying create new maintenance plan getting error " while trying find folder on sql ole db error encountered error code 0x80040e14(ould not find stored procedure 'msdb.dbo.sp_dts_getfolder'.) hello, see msdn: maintenance plans . you don't have permission create maintenance plan, therefore got error. olaf helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * wenn ich denke, ist das ein fehler und das beweise ich täglich http://olafhelper.over-blog.de SQL Server  >  SQL Server Database Engine

i know can  create xaml controls dynamically using createfromxaml method.   but    createfromxaml method takes parameter xaml control syntax possible  to send parameter xaml file name.    or if other way how cretae dynamic controls using xaml file .    here explain problem in detail:     have 1 main.xaml file in file creted 1 canvas in want show different xaml files , 2 buttons first , second .    when clicked on first button first.xaml file loaded  in canvas ,and when clicked on second button second.xaml is loaded  in canvas  if  solution please let me know.   as chad says, don't pass filename. created simple example of here: http://blogs.sqlxml.org/wpfe/downloadxaml/ xaml: http://blogs.sqlxml.org/wpfe/downloadxaml/download.xaml js: http://blogs.sqlxml.org/wpfe/downloadxaml/eventhandlers.js take @ that. uses downloader object load techy.xaml file part of wpfepad example (which uses downloader object). didn't add progress bar because didn't have ...

i developing 1 portal.i have bing map,where user able specify location of property.once user specify exact area(logi , lati) need save same longitude , latitude when user search region ready registred us,will displayed same location pointing in bing map well.   how can store selected longitude , latitude db?  i using html , java script code behind.   or please tell me whether possible directley store selected area(latitude , longitude) in sql server 2008 r2?   please me urgent me.  thank in advance. hi, please check spatial data type in bol .  thanks, janos there 10 type of people. understand binary , not. my blog | hire me SQL Server  >  SQL Server Data Access ...

hi all,    having file name t001_2014_07,how file name , create table same file name in runtime,pls me, thanks do know table structure same? the starting point read file name variable. (for each control flow task work). from there can either use script component create sql creating table or can use variable concatenation. either way, build sql command creating new table , assign code variable. in data flow task, can select table name from  variable selecting target table. likewise, data source task can set pull table name variable. if need further assistance, please post. :-) SQL Server  >  SQL Server Integration Services

hello, i'm facing problem when trying data out of excel files, hosted on sharepoint, using ace.oledb provider. have remote analysis services instance (in tabular mode), , i'm trying deploy tabular model excel data source. however, each time try add, these errors: ole db or odbc error: unspecified error. a connection not made data source datasourceid of '2065ab89-2ecb-4ea2-8fc9-ff55cbd98801', name of 'excel projects-83431-83301'. an error occurred while processing partition 'mira_2916b1ff-19e1-4427-a50c-542299fcf55c' in table 'mira_2916b1ff-19e1-4427-a50c-542299fcf55c'. the current operation cancelled because operation in transaction failed. tried again same file, no explicit credentials defined, , happens: ole db or odbc error: failure creating file.; 3436. a connection not made data source datasourceid of 'b98fddeb-2eb2-409b-a059-b1bdd2d6efbf', name of 'excel projects-83431-83301 2'. an error occurre...

i have 2 fields 1 called incident number , called problem number, incident number field populated whereas problem number field not be. wish calculate percentage of incident number fields have problem number field populated. can provide me expression show this? thanks roisin lautman =sum(iif(isnothing(fields!problem_id.value), 0, 1))/count(fields!incident_number.value)  may work. remember mark answer if post has helped you. SQL Server  >  SQL Server Reporting Services, Power View

i'm having trouble finding quick way update on large amount of data to a remote database. in situation, data taken table, , updated external service (ncoa, corrects address data), , sent in sdf text file. need take data , update orginal table data in sdf file. problem orginal database on remote server, and i'm not allowed import data tempoary table there update join on tempoary table (which quick.) currently, i'm using c# ado.net connect database, load sdf locally, pull data each record, build update command, , execute each 1 separately. extremely slow (~4 records updated per second), , there can on million records need updated, method not acceptable. have tried pulled multiple update commands in single command object before executing it, doesn't improve speed @ all. does know how can quicker bulk update remote database this? thanks, brian2344 yep - should if create staging table data, bulk insert or bcp staging table, create appropriate indexes on staging table, , u...

questions sql instance        internet firewall security.  desire close off ports sql database internet , maintain connection through vpn , subnet access. can done? this database accessed server running cognision  application , never accessed clients or individuals outside of our network directly. one of issues face upgrading 2008 r2 azure sql instance. have stored procedures refer tables different database. these stored procedures fail during deployment azure. here explanation see it: azure sql database not allow cross-database external references. includes blocking export databases three-part references… question : possible reference tables different database in stored procedures, views, triggers, etc.? if so, how? should syntaxes since 3- or 4-part identifiers not supported? -regards, hi jon, internet firewall security.  desire close off ports sql database internet , maintain connection through vpn , subnet acce...

hi all i have spnt last 3 days searching forum solution porblem. have tried setting clock , suggestions list in other threads. can done fix issue. im developer , not desktop support technician, , want simple way resolve this. i noticed made comment on thread ssdt installation failing due validating certificates, i'm guessing question related that? the problem mentioned in other thread resolved in october, few days after surfaced. need download more recent versions of ssdt - if go download page , latest version there not run issue. can download from  http://msdn.microsoft.com/en-us/data/hh297027 , or install 1 of visual studio 2013 editions include ssdt - ssdt included in full versions, in "visual studio express 2013 web" edition , _think_ in the "visual studio express 2013 windows desktop" edition. if still run problem, 1 thing have noticed people running administrative installs have had similar issues validating downloaded packages. happe...

this updated version of 2d flight simulator. here improvements: *new startup screen *smoother controls *improved framerate *sound effects! (more on way soon!) mcm221 enjoy! give suggestions! chase morell nice. doesn't work online. have import it. zock77 Learning  >  Small Basic

i'm in process of migrating existing sql server 2000 has the following collation set / sort order : sql_latin1_general_cp850_cs_as.   i know corresponding collation set / sort order is sql server 2005.  looking @ option when installing there doesn't seem option 850 multilingual , case sensitive , accent sensitive.  when selecting sql collations 9used compatability previous version of sql server).   if select latin1_general , check case sensitive , accent sensitive give me desired results ?   ant appreciated...   actually base sql_latin1_general_cp850 code page can used many country , language specific collations in 2005 per link below , no sql_latin1_general_ covers generic western europe code page 1252 , not complex languages covered cp850. in second link copy code page 1252 , cp850 , see difference. hope helps.   http://msdn2.microsoft.com/en-us/library/ms180175.aspx   http://czyborra.com/charsets/codepages.html   ...

hi all i have report 25 rows, when gave filter in tablix on 1 of column, gets 15 rows. now have expression column “count” should give total at bottom.   at total wrote expression =sum (count expression), giving total 25 rows rather 15 rows. so how total 15 rows. royal ps ps, instead of giving filter on tablix if can have same filter on data set correct results. let me know if have queires thanks, sandip please "mark answer" if resolves problem or "vote helpful" if find helpful. SQL Server  >  SQL Server Reporting Services, Power View

i trying use variable xpath when query statement on xml document in sql server 2008. have tried declare @str varchar(8000) set @str = 'acord/insurancesvc/persautopolicyaddrq/producer/producerinfo/contractnumber' select @mydoc.query(@str) returns msg 8172, level 16, state 1, line 11 argument 1 of xml data type method "query" must string literal. , have tried declare @str varchar(8000) set @str = 'acord/insurancesvc/persautopolicyaddrq/producer/producerinfo/contractnumber' select @mydoc.query('sql:variable("@str")') returns acord/insurancesvc/persautopolicyaddrq/producer/producerinfo/contractnumber have ideas on how can it? thanks! michael dynamic sql: declare @str varchar(8000) set @str = 'select @mydoc.query(''acord/insurancesvc/persautopolicyaddrq/producer/producerinfo/contractnumber'')' exec (@str) know, stinks. rbarryyoung ...

hi all, i have sql script selects images taken specific users. want create package extract these images , place them in appropriate folders, based on user names. for example, data follows: i want package create folders based on user names (the user name part of image name). , in example, folders created user1 (3 images), user4   (2 images), user5   (1 image), user6   (4 images). please assist regards hi zimiso, append foreach loop container(same configure before one), within use execute process task zip folders following  zip contents of folder in ssis . feel free ask if there's question. if no further question, kindly mark solution answer close thread. thanks.   msdn community support please remember click "mark answer" responses resolved issue, , click "unmark answer" if not. can beneficial other community members reading thread. if have compliments or complaints msdn support, feel free contact...

what best way configure variables @ run time using external source?   have package need run for different time periods for auditing reports, , want able configure date range @ run time without changing , rebuilding dtsx pack.  john schroeder package configurations you.  see: http://msdn.microsoft.com/en-us/library/ms141682.aspx phil brammer | http://www.ssistalk.com | twitter: http://twitter.com/philbrammer SQL Server  >  SQL Server Integration Services

suppose have decision trees mining model 25 inputs.  when use mining model view in bids, shows me 4 of inputs used in model.  if i'm happy model, , setup ssis package training , process model, if on time 1 of inputs no longer becomes useful in model, discard input , go next useful one? yes. retraining model (actually, mining structure) via ssis (or other way) discards old patterns , replaces them patterns specific new data. metadata stays same (the list of columns, content , usage , algorithm , parameters) bogdan crivat / http://www.bogdancrivat.net/dm SQL Server  >  Data Mining

hi, how select max row/date per group. planing @ report design level(i.e, trying put filter condition in group properties). pl me in regard. thanks aneel hi aneelchandra, seems select max value in each group, right? if misunderstand, please let me know. can use filter achieve target, please take following steps of sample reference. 1. add row parent group without select “add group header” , “add group footer”, and   then new group display in “row groups” pane , named group1. 2. right-click “details” in “row groups”, , select “group properties”. 3. change “filters” tab, click “add” button add filter following: expression: [salesamount] (select data field choose max value it) operter: = value: =max(fields!salesamount.value,"group1") after   completer steps above, result need. if have question, please feel free ask. thanks, ei...

hi, i using following code access database via domainservice value val = null; context.load(context.getvaluequery(), lo =>         {           if (!lo.haserror)             val = lo.entities.firstordefault();           else             messagebox.show(lo.error.message);         }, null); but val stays null , returning entitiyset has 0 rows. tried using no lambda expression accessing loadoperation result same. i.e.:          loadoperation <value> op = context.load<value>(context.getvaluequery());         value csv = op.entities.firstordefault(...

i have stored procedure call @ beginning of each ssis package save metadata table , read id of created record. here body of proc:   insert into tbl ( pkgname ,   pkgstartdt ) values ( @pkgname , @pkgstartdt ,)   set @pkgexeckey = ( select pkgexeckey from tbl where pkgname = @pkgname and pkgstartdt = @pkgstartdt )   i call proc execute sql task transactionoption set “supported” the task located inside container transactionoption set “required” , isolationlevel set “serializable”   if run packages in parallel (i reuse stored procedure @ beginning of each package) getting deadlock error: “transaction (process id 79) deadlocked on lock resource , has been chosen deadlock victim”. pinpointed deadlock stored procedure (see above) although see reason why deadlock can happen in proc, not understand why happening isolation level container set serializable.   pleas help make index cover both columns create index ix_1 on tbl(pkgname, pkgstartdt). ...

does know if running sql 2008 r2 on windows server 2008 r2 if can enable tls 1.2 connections between sql server , sql 2008 r2 odbc client? enabled tls 1.2 in iis 7.5. network trace same system tweaks showed sql connection being negotiated @ tls 1.0. enabling tls 1.2 iis 7.5 can found here: http://derek858.blogspot.com/2010/06/enable-tls-12-aes-256-and-sha-256-in.html the big difference between tls 1.0 , 1.2 use of sha-256 hashing instead of sha1. nist has recommended phasing out of sha1 in favor of sha-256.     i looking answer of same question - have ever found out if sql server 2008, or 2012 is capable of doing tls 1.2 ?  i puzzled, iis can done while sql server on same box continue respond tls1.0 in handshaking process.... SQL Server  >  ...

i had load data sql server data base tables. used store procedure load data .the stored procedure gives 3 columns when run it so source sql server i had create table in excel , load data 3 colums i had create excel table 3 colums. create table `new table` ( `column a` varchar (9) ,  `column b` varchar (8) ,  `column c` varchar (254)  ) when data conversions , when load data first 2 columns getting loaded properly.the third column loading in fashion '0123 have 0123 getting '0123 in third column. when did data conversions had used each of these options( dt_wstr , dt_ntext) . when use these options above mentioned issue '0123 not 0123. please can 1 me this   thank you,     when changed colum c data type int in template new table   and when did data conversion 8 bit unsigned integer in data flow task.  i able eliminate single quote problem. thank help     ...

hi i have multiple sql server , want ensure time sync between them. all servers have common sntp. but want check sync.   any options try welcome. hello there, a link given bbelow sql server performance monitoring perfmon http://knol.google.com/k/sql-server-performance-monitoring-with-perfmon# hope helps. regards, phijo mathew philip. phijo mp SQL Server  >  SQL Server Tools

one of databases in status of suspect, i want drop , recreate database. but says database in use. and can't find session using it. i execute sp_who , there's no related session info. so, can teach me how drop suspet databse ? hi bedik,   sql server marks database suspect if of device files database unavailable when attempts start.   please see following article http://support.microsoft.com/kb/180500   if no body using sql server can stop , start , close connections , able drop this---but cautious --make sure sql server not in use anyone.   let know if has answered question   thanks   SQL Server  >  SQL Server Database Engine

hello,     wondering if somone provide me sample select an auto number query. example have table called people 2 columns first_name, , last_name. there isn't unique id correspond table dynamically make 1 during return of query. i know possible in full version of sql 2005 using select row_number() on (order last_name), first_name, last_name people but within sql mobile there way? so if there 5 rows in table return 1    john    alpha 2    john    beta 3    john    cat 4    john    delta 5    john    echo john no sql server mobile/everywhere edition not support row_number() , there no similar function :( thanks, laxmi SQL Server  >  SQL Server Compact

in ssms when try connect database, connect window opens portion of title bar showing "connect se..." , close button.  if press f4, "browse more".  clicking gives me another minimized title bar can resize that window.   after select server, second window goes away, first "connect" window remains minimized.     how can connect window reset proper size?   tia,   tim   hi tim,   what display settings? using large fonts or other accessiblity setting or 3rd party accessibility software? post screen shot of you're seeing?   thanks, dan SQL Server  >  SQL Server Tools

i tried install sql server 2008 r2 in windows server 2008 r2 and i "exception thrown external exponent",  tried  installing 10 times same result ( both data center , enterprise). really frustrated.  appreciated <input id="d36d104b-3cfe-41e3-abd7-686a8bd00fa2_attachments" type="hidden" /> hi sunil, this appears may due windows os build version deployed. please check not using debug version of operation system. for example: "windows 2008 enterprise copyright 2007 microsoft corporation. rights reserved. debug" we recommend normal , non-debug version of operation system. check computer properties , ensure windows edition not listed debug edition. if have problem, please feel free let me know. thanks, maggie please remember mark replies answers if , unmark them if provide no help. can beneficial other community members reading thread. ...

hi, i want import rss feeds cnn or yahoo news daily in ssis aggregates , puts sql server. but unsure of how import rss feeds ssis. if 1 knows article or has idea of how implement this,please assist me. thank :) hi, i've not had experience quick search on google produced following link: http://drsql.spaces.live.com/blog/cns!80677fb08b3162e4!1188.entry cheers jeff sql server mvp / wardy solutions, solutions architect SQL Server  >  SQL Server Integration Services

during developing, use svn source control. free us, , want konw information tfs: 1). during developing, whether use tfs svn in vs manage project? 2). how install tfs, have 1 computer? 3). primay differences between tfs , vsts? know use vsts in vs. hi test888888, thank posting here. q1: yes, use tfs in visual studio. add project version control in tfs, , there 2 types of version control in tfs: git , tfs. for more information version control, refer following link: https://www.visualstudio.com/en-us/docs/tfvc/comparison-git-tfvc q2: if have 1 computer, need to: check requirement of tfs before install. set appropriate version of sql server. download , install tfs , run basic server configuration wizard. about install of tfs, learn more following link: https://www.visualstudio.com/en-us/docs/setup-admin/tfs/install/get-started q3: the primary difference between tfs , vsts is: vsts in on cloud. tfs on-prem, need install , configure tfs on s...

i'm trying find application / server /anything can me use sql. i need generate reports databases , have tried unsuccessfully download editor or application microsoft server, mysql , postgre allow me access tutorials , learn basics. aware there "free" options expire after 30 days looking genuinely free. would grateful can supply link client server / editor / application. am running windows 7 on 64 bit laptop. i think looking @ sql express advanced services has reporting services included can used developing reports , free use. see http://technet.microsoft.com/en-us/library/ms365166(v=sql.105).aspx    please mark answer if helps solve issue visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/vmblogs  SQL Server  >  ...

in near future want / design intranet application , should based on silverlight (version 4). there prerequisite, application should use corporate design of company. corporate design quite complex. templates (html / javascript) exist, there no enforcement use them. no problem realize design otherwise (for example asp.net masterpages ) for me main question is, how should start !? should write complete silverlight application or better mix asp.net . @ moment have no idea how realize corporate design silverlight. on other side think asp.net masterpages feasible. when mix asp.net, project type in visual studio should select ? or makes sense use 2 projects (asp.net , silverlight) inside solution ? i know, there silverlight navigation framework , have no experiences , not sure, if alternative asp.net masterpages. and last question: has experiences silverlight , company corporate designs ? thanks in advance hints , ! let me address last question first,  designing...

hi, i want draw earth polarr coordinate,is there chart recommand? thanks in advance. hi, you try use silverlight elements . silverlight elements includes polarchart control along 12 different polar coordinate chart series. each of these chart series polar versions of cartesian series familiar our chart control.  for more details,please check link below: http://www.mindscapehq.com/blog/index.php/2011/04/13/introducing-silverlight-polar-charts/   best regards, we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Silverlight  >  Silverlight Installation and Setup ...

first of want explain scenario have. in our organization have 2 servers, both in same network. 1.        server has enterprise edition of sql server 2005 sp2 installed on windows server 2003.   which has following services : -           sql server -           sql server browser -           sql server agent 2.        server b has enterprise edition of sql server 2005 sp2 installed on windows server 2003 has sql server integration services. our production database on server , deployed ssis packages on server b. real situation occurs want execute our ssis packages present on server b server haven’t install sql server integration services. , 1 more thing can’t install sql integration services on server because our client denied it. we have tried execute package using following ways: 1.        batch file dtexec command utility. 2.        run sql agent job file system , ssis package store options. but both ways failed. gives error – “description: product level insufficien...

i'm trying install sql server 2008 , error message saying microsoft visual studio 2008 must upgraded to service pack 1 before installing sql server 2008 installed update.  can me? hello, please read instructions given in following article: http://support.microsoft.com/kb/956139 hope helps.       regards, alberto morillo sqlcoffee.com SQL Server  >  SQL Server Setup & Upgrade

hi,  putting quick little demo app , want have popup.  have user control defined < usercontrol x : class ="myapp.favorites" xmlns ="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns : x ="http://schemas.microsoft.com/winfx/2006/xaml" xmlns : d ="http://schemas.microsoft.com/expression/blend/2008" xmlns : mc ="http://schemas.openxmlformats.org/markup-compatibility/2006" mc : ignorable ="d" d : designheight ="300" d : designwidth ="400" width ="200">   < grid x : name ="layoutroot" background ="white"> < stackpanel orientation ="vertical" grid.column ="0"> < listbox x : name ="mylist" itemssource ="{ binding }"> < listbox.itemtemplate > < datatemplate > < hyperlinkbutton x : name ="...

currently, using output & "         " &  .....to display parameters list; however, columns not aligned.  better way align columns .     hi benjaminluk , can please explain in detail regarding question can in asap. posting screen shot great. thank you SQL Server  >  SQL Server Reporting Services, Power View

hi guys, i want preface stating i'm not developer , barely passingly familiar how developers use msdn, answers may need bit dumbed down. apologies, job has kind of scope creeped until i'm operating @ edge of knowledge. i work business has been using visual sourcesafe 6 since forever, , decided switch tfs 2010. managed use vssconverter upload projects tfs. @ time our developers kind of using both, , didn't want upload collection in use in case of name conflict. created new collection , uploaded source safe projects that. a few weeks after i'd finished doing that, 1 of developers approached me , asked build controller assigned second collection. big problem me. don't have resources second build controller server, , apparently can't use 1 build controller across 2 collections nor have 2 build controllers per server. cherry on top if apparently difficult move data 1 collection , still maintain source control/history. i have been trying few things, , tfs ...