Lun

i have following code: create table csvtest (id int, firstname varchar(40), lastname varchar(40), birthdate smalldatetime) go  bulk insert csvtest from 'c\data\tempfile.txt' with ( fieldterminator = ',', rowterminator = '\n' ) go   but error when try use it. error follows: msg 4861, level 16, state 1, line 1 cannot bulk load because file “c\data\tempfile.txt” not opened. operating system error code 3(the system cannot find path specified.). i tried adding name of computer address hoping work following error: msg 4861, level 16, state 1, line 1 cannot bulk load because file “\\ltsr397941\c\data\tempfile.txt” not opened. operating system error code 53(the network path not found.). we using sql server 2008 windows authentication. sql server resides on remote server have access. can tell me wrong situation. thanks vijaya can suggest alternative bulk load? i'll thankful.  ...

hello members, i have old database (approx. 80 mb of data , 80 mb of log) , optimize it. i know in mysql there application called mysqlcheck.exe provide me tool database optimization. ( run arguments : mysqlcheck.exe -a -r -o ) i know if there tool comes mssql 2000 , provide me same solution mysqlcheck.exe in mysql ? or can suggest me other way me optimize old database. thanking in advanced 1 me. hello, have had @ index tuning wizard?  can find in sql server profiler under tools menu.  i'm not familiar mysql tool mention above, can't comment if provides similar functionality however, purpose identify potential tables benefit (performance) additional/altered indexes being created or modified. cheers, rob SQL Server  >  SQL Server Database Engine ...

i trying fix intervals on graphs equally distributed, give me nice round numbers (ending in 0's , or 5's). report building contains 4 graphs varying stats. spending, volume. i've been trying work round function , floor or ceiling can not consistent results. pointers appreciated. thank you.   hi sarahtzt,   please refer link below, may enlighten in somewhere: http://social.technet.microsoft.com/forums/en-us/sqlreportingservices/thread/cac7cb6c-6f9d-43ed-ac73-bc42e8f9bf56   thanks, bill lu please remember mark replies answers if , unmark them if provide no help. SQL Server  >  SQL Server Reporting Services, Power View

the report expects 2 date parameters @datefrom , @dateto but when run either visual studio or online reportserver error msg an error has occurred during report processing. query execution failed data set 'datasource1'. procedure or function 'spspark_servicesitems' expects parameter '@datefrom', not supplied.  the spelling , case correct datefrom param i can run sp sql server without problem visualstudio 2005 sql server 2005   any appreciated. hi ghw123, thanks post , others’ replies. you said   that sp run normally   sql server without problem, can copy t-sql script directly query string textbox of dataset, specify query type text well, in way, unneccesary create report parameters mapping relevant parameter of sp, due when run sp in sql server, had replace parameters actual   values. otherwise, if specify query type stored procedure, can type in procedure name query textbox, , switch parameters tab, ...

hello experts there,   i need insert csv file data sql server 2008. there multiple tables created in sql server , need check conditions before data insertion , based on condition value, sql script should insert data in specific table. in other words need insert data 1 csv file different tables based on condition. is possible? if yes can please give me idea on how can that?   thanks in advance regards nipendra garg in case need create script read data csv , check condition , insert values in respective tables. if 1 time activity go ramasamy's suggestion else can design solution in c# or other programming languages. can google this,still m  mentioning below url: http://www.csvreader.com/csv_samples.php i hope helps.     cheers!!! vatsa SQL Server  >  ...

hi, can tell me difference between parsing , compling query.  the parseonly parse query syntax(my understanding) example:(msdn link - > http://technet.microsoft.com/en-us/library/ms178629.aspx) set parseonly on go select * table1 go set parseonly off go and option noexec complies query. getting same result. (msdn link -> http://technet.microsoft.com/en-us/library/ms188394.aspx) example:  set noexec on go select * table1 go set noexec off go does compliation not found object not found error? what difference between above 2 options? regards harsh harsha, i getting explained. may executing whole script single shot. may add "go" between statements. create table test_planforharsha(col1 int) insert test_planforharsha select 1 go set noexec on go select * test_planforharsha go set noexec off go --check caching select '2' roundnum, usecounts, cacheobjtype, objtype, text sys.dm_exec_cached_plans cross apply sys.dm_e...

hi, i've been trying read service broker in sql server 2005 - introductions don't seem useful  so though i'd post here , see if i'm correct. how broker service interatc .net?? can application wait messages sql server (new database created instance) , act upon them?? or not meant this? can't seem find on web kind of information... thanks dale yes, can used service broker .net, however, there no .net library, namespace or class model explicitly using service broker code.  consequently, has used same way other sql facilities (usually) used before linq:  you either execute t-sql service broker commands directly, or write stored procedures, , execute stored procedures .net. so, if want app code wait new messages on sb queue, execute receive command , wait complete. -- rbarryyoung , (302)375-0451 blog: movingsql.com , twitter: @rbarryyoung proactive performance solutions, inc. "performance our middle name." please! remember vote all helpful replies h...

we have couple of apps need access data resides in oracle. traditionally, have using linked servers using oracle credentials provide data access sql oracle.  i wondering if possible use windows ad linked server credentials. in case, let's assume usera connects database, , usera need run queries against oracle. in past usera able via linked servers linked server configured connect oracle using oracle username/password. is possible configure linked server connect oracle using windows authentication while user connected sql server sql native user. how can happen? have map sql native account windows ad account has permissions within oracle? thanks this boil down question: oracle support connections windows authentication sql server does? in case, go it. long there no double-hop issues work. if oracle not support windows authentication, not work. a connection on linked server other client connection far remote data source concerned. ...

  hi, i have migrated 2000 2005. when try process cube fails on dimension. try process dimension following error. here details:   <batch xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine ">   <parallel>     <process xmlns:xsd=" http://www.w3.org/2001/xmlschema " xmlns:xsi=" http://www.w3.org/2001/xmlschema-instance ">       <object>         <databaseid>analysis services project1</databaseid>         <dimensionid>destination country</dimensionid>       </object>       <type>processfull</type>       <writebacktablecreation>useexisting</writebacktablecreation>     </process>   </parallel> </batch>  processing dimension 'destination country' completed successfully.   start time: 12/5/2007 9:03:37 pm; end time: 12/5/2007 9:03:37 pm; duration: 0:00:00   processing dimension attribute '(all)' completed successfully.    start time...

i have downloaded ms sql server 2008 express. @ end of down loading got message "installation successful". may have mis-read writing - down-loading successful. files there in program folder. i not sure if have done installation. not see exe file. cannot use server. how can use it? how can connected server? s.zaman   you should have 1 executable start setup. please retry download this microsoft® sql server® 2008 r2 sp2 - express edition http://www.microsoft.com/en-hk/download/details.aspx?id=30438 many & best regards, hua min SQL Server  >  Getting started with SQL Server

hi, i trying export data sql table csv file. i have column "message" of length 2048 in sql table. when loading data, data in "message" column splitting , loading next row. please give me solution. thanks please refer text qualifier character , try once. regards, rsingh SQL Server  >  SQL Server Integration Services

hi, i don't see source control option in tfs, when checked tools --> options. has 4 elemenst (geeneral, fonts , color, format, validation). do see source control option disable automatic checkout? thanks lijo   hi lijo, first, if using vs 2010 , tfs 2010, install visual studio 2010 team explorer (in default, has team explorer), connect 1 tfs , can open team project. ok, change tools menu > options > source control, select 1 source control pulg-in , edit "environment" settings. by way, not forget check option "show settings" below "options.." dialog. http://msdn.microsoft.com/en-us/library/7f33da8d.aspx note settings collections scope number of pages appear in navigation pane of options dialog box. can choose view possible pages selecting show settings.   sincerely,   bob bao [msft] msdn community support | feedback us get or request code sample microsoft please remember mark replies a...

have ssis package set through visual studio process flattened xml file. when process xml file in data flow, creates 16 different outputs. none of these outputs has foreign key can relate tables with. there anyway combine these tables 1 output, or process pulls data xml file 1 table? in advance. prabha hi prabha, your xml file has have root element it'll come out single piece output. i guess may need pre-process add root programmatically. or ask generating end produce proper xml file. arthur myblog twitter SQL Server  >  SQL Server Integration Services

i using sqlserver 2008 r2 , quering database through jdbc driver. when query db through jdbc unexpected character non ascii 8 bit characters (ie > 126). the data type of column quering nvarchar(25). for example, value in db '0°f' query returns '0ºf'.  i  character degree symbol.  if @ char values, 30 c2 b0 46, c2 char value Â.  non ascii 8 bit characters have tested additional Â character. my database has support unnicode store text multiple languages japanese, chinese, european languages etc. can explain why getting unexpected character , way prevent it. any light thrown on issue appreciated. ian i don't know java can tell unicode string encoded utf-16 takes 2 bytes per character, total length of pval should 6 bytes , not 4 , individual numerical values code should have give should have been either 48 0 176 0 70 0 or 0 48 0 176 0 70 because high order byte each of these characters should 0. in case, solution easy i've see code: string...

i trying deploy cube on remote server first time. i used deployment wizard build xmla script ran on server. the datasource set use network credentials login. works fine when run cube locally. however after running xmla script , try process cube, error : there no logon servers available service logon request. i don't know windows security, , stumped next. not sure if doing right first bi project, there better way deploy , update cube? or recommended settings. any appreciated. thanks jon hi, i hope have proper admin rights when perform above mentioned steps. try following , see whether works you. if create "cube" user local user have select server name locations box follows; also copy , paste " %windir%\security\logs\winlogon.log " in run command , open log file. scroll way down bottom of log , see further details. if continue " no mapping between account names , security ids done " error copy log file information analyse ...

i have inherited report based on data cube. once report runs 2 of columns allow me click on details , opens new report drill down dollar amount. i'm trying figure out how drill down enabled/linked (so can support it)!. know setup this? arrow in picture below points column containing detail can drilled down on. right-click control in design view , choose text box properties. select action tab. should see go report selected report specified , parameters values passed. SQL Server  >  SQL Server Reporting Services, Power View

hi currently i'm working on porject related charts, has sl , windows forms version. lot of code reusable in both versions, can't create class library both projects cause sl not support class libraries windows forms , vice versa. solution found add file link both projects. works fine told adding files link bad habbit. :) well, other possibility have common code both sl , windows forms. and next question is, in sl version paint line, rectangle directly canvas. there benefit if i'll using path this? add lines path object , path object canvas? kind of other optimization, drawing speed point of view, can use in order paint lots of lines , rectangles gradients? thx take @ following article.  may of use in regards sharing code.  haven't tried it, can't sure looks good: http://msdn.microsoft.com/msdnmag/issues/07/07/sharecode/default.aspx Silverlight ...

i receiving 50 spreadsheets per week import sql database via ssis. the mapping table have 10 columns, ideally spreadsheets have 10 columns, wont. have maybe 5 columns, 10. fine, take can get. the data flow task throws error when there missing mapped columns, unless missing folks know. solution idea: i thinking of solution use derived column task map each spreadsheet column derived column desination table, goal of checking within derived column task: if spreadsheet column exists, use value derived column mapping sql table, otherwise place null or 0 value in sql table, spreadsheet column not exist. ideas ? dave no - can't use derived column accomplish this.  what can do, however, configure connection manager not have header row, , configure excel source read full 10 column range (like "a1:j1000"). my next question "how columns presented" in spreadsheets may or may not have columns?  in same position?  order?  named same? ...

hi,        using ssas 2005 , trying find top 10 consumers. have created named set gives me top 10 consumers specific month. want filter region wise etc. if drop set in excel , if i use region filter want see top 10 consumers region. have tried not working. can 1 advise in first place if possible or not.   hi,   i think named set u creating static, static named sets not take consideration current execution context while evaluating set. in ssas 2008 dynamic named sets supported. dynamic named sets evaluated consideration of cueent execution context.   ssas 2008 can solve problem. mona SQL Server  >  SQL Server Analysis Services

i had problem installing microsoft sql server 2008 r2 express.  there file not found in installation package.  didn't take note of file because wanted try run installation again.  that, wanted uninstall files related.  i'm unable remove microsoft sql server 2008 r2 setup because of: dialog box: title : microsoft sql server 2008 r2 setup (english) icon : yellow triangle exclamation mark text: warning 26003.  microsoft sql server 2008 r2 setup support files cannot uninstalled because following products installed: sql server 2008 r2 common files. ----- i can't find installation in order remove it.  removed manually sql directory find.  run registry cleanup.  i'm still stuck fact can't reinstall sql server 2008 r2 express. advice plz. hello, please try manually uninstall sql server following resource: http://social.msdn.microsoft.com/forums/en/sqlexpress/thread/4d6158a1-b601-428c-aad4-a1716e76de1a     ...

hi all, declare @sid varchar (10) set @sid = '2301001001' create table #temp ( sid varchar (10), bid varchar (10), pid varchar (10), dt datetime , est varchar (8000) ) insert into #temp values ( '2301001001' , 'hour' , 's21' , '2005-01-01 00:00:00.000' , 'a' ) insert into #temp values ( '2301001001' , 'hour' , 's21' , '2005-01-01 00:00:00.000' , 'd' ) insert into #temp values ( '2301001001' , 'hour' , 's21' , '2005-01-01 00:00:00.000' , 'dh' ) insert into #temp values ( '2301001001' , 'hour' , 's22' , '2005-01-01 00:00:00.000' , 'a' ) insert into #temp values ( '2301001001' , 'hour' , 's22' , '2005-01-01 00:00:00.000' , 'd' ) insert into #temp values ( '2301001001' , 'hour' , 's22' , '2005-01...

i have datagrid in have few columns , want more column dynamic how can this. thanks will bind dynamic property on runtime dynamic column. you can this datagridtextcolumn column = new datagridtextcolumn(); column.header = title; column.binding = new system.windows.data.binding(fieldname); return column; more info: http://elegantcode.com/2010/03/08/silverlight-datagrid-populate-dynamic-columns-from-a-child-collection/ sharker khaleed mahmud Silverlight  >  Programming Silverlight with .NET – General

in 1 report have 5 tables different number of rows etc. there possibility or way make columns inside of equal? problem when report being exported .xls file there columns not visible or merged. is there quick way avoid or way sit in front of ssrs report few hours , somehow manage set manually praying good? you can wrap tables inside rectangle  containerand make sure max width of table aligns rectangle width uniform. please mark answer if helps solve issue visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/vmblogs SQL Server  >  SQL Server Reporting Services, Power View

can please give me thoughts on error have below.  thanks. event viewer the sql server (***) service terminated service-specific error %%-2146885628. error log: 2013-01-08 08:23:42.89 server      rights reserved. 2013-01-08 08:23:42.89 server      server process id 872. 2013-01-08 08:23:42.89 server      authentication mode mixed. 2013-01-08 08:23:42.89 server      logging sql server messages in file 'c:\program files (x86)\microsoft sql server\mssql.1\mssql\log\errorlog'. 2013-01-08 08:23:42.89 server      instance of sql server last reported using process id of 2700 @ 1/8/2013 8:18:22 (local) 1/8/2013 1:18:22 pm (utc). informational message only; no user action required. 2013-01-08 08:23:42.89 server      registry startup parameters: 2013-01-08 08:23:42.89 server        -d c:\progr...

hi, the project broken. don,t try lots problem now. ef 5 using system; using system.collections.generic; using system.linq; using system.text; using ifsolutionfx.data; using ifsolutionfx.model; namespace ifsolutionfx.sql {     [system.diagnostics.codeanalysis.suppressmessage("ifsolution.design", "ca1063:implementidisposablecorrectly",         justification = "inherited idbcontext interface, exists support using.")]     public partial class ifsolutionfxdbcontext : dbcontext, iunitofwork     {         /// <summary>         /// method sets database appropriately available model objects.         /// method sets data tier.          /// shared or model level requirements (data validations, etc) on m...

we have silverlight application connects ria services.  the website hosting silverlight application , ria services in separate virtual application directories (www.somedomain.com/website, www.somedomain.com/services) hosted on iis7.  everything works fine until migrate setup load balanced environment , call ria service fails.  if turn of web servers off except 1 in load balanced environment works.  has else run or have ideas how solve it? what's error message? have added clientaccesspolicy.xml boxes. sl app can't access service on box without existance of clientaccesspolicy.xml  Silverlight  >  WCF RIA Services with Silverlight

we have added tfs @ proxy.config , have added proxy service account “tfs valid users groups”.   this text getting when invoke queryproxystatistics: <?xml version="1.0" encoding="utf-8" ?>   <arrayofproxystatisticsinfo xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:xsd="http://www.w3.org/2001/xmlschema" xsi:nil="true" xmlns="http://schemas.microsoft.com/teamfoundation/2005/06/versioncontrol/statistics/03" />   there no errors in proxy event log. find enclosed warning message got in event viewer of proxy server. the warning message got “tf30063: not authorized access http://tfs-srvr:8080/versioncontrol . “ we have given full control access tfsservice account on data folder in cache path.   also when trying connect client thru proxy server getting following error: the source control proxy ‘proxyserver’ not responding, request sent main server. please verify settings. additional inf...

hi, we have physical servers today running sql server 2008 r2, , going migrate these sql server 2014 running on vmware. going perform clean install of machines on vmware, , want detach , attach database on new servers, or kind of backup , restore on new. im not familiar sql, have done detach , attach before 2005-2008, please provide me guides. either backup , restore or detach , attach.... or if should secure way ? there no problem downtime. /regards andreas both works, feel backup , restore graceful way do. prefer going backup/restore instead of attach/detach. this upgrade. upgrading sql server 2014: dozen things check http://thomaslarock.com/2014/06/upgrading-to-sql-server-2014-a-dozen-things-to-check/ SQL Server  >  SQL Server Migration ...

to loop through databases in of maintenance scripts, use dmo each... for each odatabase in oserver.databases well, snapshots show database , causing problems. without rewritting of these yet in or taking them direct queries, there easy way omit snapshot in dmo? thanks in smo can check database property this:   code block     if  dbdatabase.compatibilitylevel  =  compatibilitylevel.version90  then          if  dbdatabase.isdatabasesnapshot  then               ' here if it's snapshot         else             ' here if it's not         end if      end if       however, dmo not updated provide support features in sql server 2005 , beyond.  best served converting code smo.  if code written in vb or c# you'll fine.  if you're using vbscript you'll want take @ powershell, because smo doesn't have com interface necessary manage servers vbscript.   SQL Server ...

hello, i follow "adventure works racing community" demo from sql server 2008 developer training kit step-by-step walkthrough file:///c:/sql2008trainingkit/demos/adventureworksracingcommunity/demo.html/html/docset_e56c787b-c1ca-407d-828d-5865fe27042e.html#_toc227564958 it tells there: “5. open %trainingkitinstallationfolder%\presentations\adventureworksracingcommunity\adventureworksracingcommunity.pptx 6. (segment 3) restore data mining structure in sql server analysis service instance. this: a. connect analysis services in management studio b. right click on databases , click restore. c. backup file located @ %trainingkitinstallationfolder%\demos\adventureworksracingcommunity\bi\adventureworksracingdm.abf. d. name database adventureworksracingdm, , click ok.” ?? import of opening powerpoint 2007 presentation step (should buy , install ms office 2007 in order follow instructions?) i cannot complete step 6, receiving messagebox [1], telling me that, if correctly unde...

what's best way have silverlight media player play 1 video after -- rather asx playlist without using asx?  , able re-configure playlist order. part of reason i'd around issues have had asx , silverlight: i have working using asx, seem running issues windows media player seems handle more elegantly (for example, if video file missing, wmp intelligently skips past it).  there meta tags in asx silverlight not seem play nice (such repeat , base ref -- unless i'm doing wrong here).   thanks insight this... why can't maintain list in memory , handle mediaelement.mediaended? Silverlight  >  Silverlight Video and Media