Lun

we have our data mining web app on own 32-bit server along other web apps. have our sql 2008 database on 64-bit server along sql server 2008 reporting services. possible (or more recommended) have reporting services 2008 on third server itself? hi, it possible. see article http://www.microsoft.com/sqlserver/2005/en/us/special-considerations.aspx#reporting   , http://technet.microsoft.com/en-us/library/ms143736(sql.90).aspx  about question. thanks, jerry SQL Server  >  SQL Server Reporting Services, Power View

hello all, unable load client print control - asp.net report viewer, report manager reports print without issue on same machine our environment locked tight , admins can perform installs.  our admin hand installed required print components on various test machines. on machines using ssrs report manager render report, not have issue. on same machines, when access asp.net page embedded report viewer , print report encounter 'unable print' any assistance appreciated - covi   update, today chose 7 desktops hand install rsclientprint activex control components (locked environment).  after installs 'print' report manager or embedded reportviewer control. the solution here on web\app server applied 'reportviewer 2008 sp1' , reboot server.  issue resolved i have happy users :) SQL Server  > 

suppose table contains list of 10 tables.i want contains of 1st table..how can that?   declare @sql nvarchar ( max ) select @sql = '' select @sql = @sql + ' select * ' + quotename (table_name) + char (13) from excluded print @sql -- test execute (@sql) -- execute script   i assumed field name contains table names in excluded table table_name. if it's different name, use instead of table_name in above script. premature optimization root of evil in programming. (c) donald knuth naomi nosonovsky, sr. programmer-analyst my blog SQL Server  >  Transact-SQL

i followed example here: http://www.codeproject.com/kb/database/sqlserver2008databasemail.aspx   everything fine point: use msdb go exec sp_send_dbmail @profile_name = 'pinalprofile' , _ @recipients = 'test@example.com' , @subject = 'test message' , _ @body = 'this body of test message. _ congrats database mail received successfully.'   i substituted in own profile­_name , own recipients.   when selected script , hit f5, got this: msg 102, level 15, state 1, line 3 incorrect syntax near '@recipients'.     hi you don't need _ . sp_send_dbmail @profile_name= 'pinalprofile' , @recipients= 'test@example.com' , @subject= 'test message' , @body= 'this body of test message. congrats database mail received successfully.' vt please mark answered if i've answered question , vote helpful other user's find solution quicker

hi all,  my design issue i'm having follows: have main silverlight(page.xaml) contains toolbox user clicks on items , adds custom usercontrol element (equipment_controls.xaml) to page dynamically. implement popup menu these usercontrols(equipment_controls.xaml). should adding popup each of usercontrols?(equipment_controls.xaml) or should have 1 popup usercontrols? (page.xaml) , if there's 1 popup in main page how tell who's calling it?  hope clear. here popup system implemented, hope helps, message.xaml  <usercontrol x:class="silverlightapplication1.message"     xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation "     xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml "     width="400" height="300">     <grid x:name="layoutroot" background="lightgray" opacity=".3">         <grid.rowdefinitions>             <rowdefinition hei

good morning, i have simple sql query gets data oracle db , loads sql server db 2005. when i'm trying validate package i'm getting error says "cannot convert between unicode , non unicode string datatype". solution: used data conversion transformation , used alias columns default named "copy_filed name". changes data types dt_wstr dt_str, still getting same error message. there i'm doing wrong? thanks sv thanks no luck. sv if add cast source query, have deselect (changed) columns , select them again. otherwise metadata in source component will not refresh. please mark post answered if answers question | ssis blog: http://microsoft-ssis.blogspot.com | twitter SQL Server  >  SQL Server Integration Services

data source contains impersonationmode not supported processing operations.   also see documentation on explains works when , vice-versa: http://technet.microsoft.com/en-us/library/ms187597.aspx http://bi-logger.blogspot.com/ SQL Server  >  SQL Server Analysis Services

hi, all did set sql agent job run ssis package without rdp onto target sql box? to clarify: basically, have 2 environments: 1.  1 environment in client's boxes, have limitted permission.     ssis 2008 development on machine a, , sql database engine , ssis service on machine b. can log sql engine and ssis  through ssms, using domain user account ssisltduser, sqlagentuserrol.     given network share unc ( \\machinename\sharefoldername ), , proxy account packages run as.  no sql login, no local path. 2. feeling dificult troubleshoot, created environment in local machine, have everything. what want is, try or confirm whether can set sql job: 1. use domain user account, or proxy account 2. use unc store ssis packages 3. can import ssis packages sql msdb or file system. guess still have use unc checkpoint file. maybe why words seems inconsistent sometimes. thanks lot you seem understand protection level issue - yes, you're combo. i think understand you

i tryng second node in 2 node cluster start sql services , come in cluster.  second node configured , running in cluster when @ point, sql service and/or cluster service went down.  node not start...as in sql service fails , system log error is: "the disk associated cluster disk resource 'disk q:' not found. expected signature of disk bf17d33c. if disk removed server cluster, resource should deleted. if disk replaced, resource must deleted , created again in order bring disk online. if disk has not been removed or replaced, may inaccessible @ time because reserved server cluster node." and application log shows: error 2(the system cannot find file specified.) occurred while opening file 'c:\program files\microsoft sql server\mssql.1\mssql\data\master.mdf' obtain configuration information @ startup. invalid startup option might have caused error. verify startup options, , correct or remove them if necessary. i had edit startup parameters on se

i have database table called qlinks, 2 columns, url , name. table displayed on form called qlinks, in details view. when try save data after i've deleted row of table, o yellow po-up telling me invalidoperationexception unhandled. error " update requires valid deletecommand when passed datarow collection deleted rows." please try help, beginning programmer doesn't know much. code samples appreciated. in advance. ha, didn't expect reply after long. posted last year. sql 05 express doesn't seem work on computer. (i think has amount of memory have.) gave on 1 long ago. SQL Server  >  Getting started with SQL Server

from can see, 'varbinary(max)' data type not supported, , 'image' data type supposed go away.  there other way store large chunks (10mb 100mb) of data ssev db? if have use 'image' data type this, have code sample let me push array() of numbers 'image' field, , unload 'image' field array()? tia pat   sql server ce/mobile 3.0 supports ilockbytes in oledb provider.   dont know if ilockbytes exists in managed code! thanks, laxmi SQL Server  >  SQL Server Compact

i need deploy ssis packages on server. these packages stored locally on drive. how run manifest file can install these on server? anonymous here create create deployment utility you can deploy package on file system or sql server. have ssis 2008 or higher version? here package project deployment deployment of projects , packages to run manifest file deploy packages using deployment utility this reference. thank question. SQL Server  >  SQL Server Integration Services

hello, query ssas cube via excel. of time works without problems. excel not send account name (active directory) along query. log file of iis (excerpt): cs-uri-stem s-port cs-username cs (user-agent) sc-status /olap/msmdpump.dll 80 domain\ username msolap + 10.0 + client 200 /olap/msmdpump.dll 80 - msolap + 10.0 + client 401 2. line: same client, same client ip, no account name logged (status 401 in iis). have idea be? i believe normal part of http ntlm handshake (see https://www.innovation.ch/personal/ronald/ntlm.html) involves 1-2 401 responses before 200. i'm not sure why seeing 401 after 200, lag in logging or multiple requests happened 1 after other , you've grabbed end of 1 request , start of another. http://darren.gosbell.com - please mark correct answers SQL Server  > 

hi friends, have question: i'm trying connect analysis services 2008 using microsoft excel 2010, when put "server name" , user , password, appears following error: "an error encountered in transport layer" i created group called administrators in anlaysis service cube , added user.  testing users , appears same error. regards , help greetings aleds       check document in resolving connection issues http://msdn.microsoft.com/en-us/library/cc917670.aspx it sounds bit like users may not in trusted domain.(ssas needs able map credentials trusted windows account) http://darren.gosbell.com - please mark correct answers SQL Server  >  SQL Server Analysis Services

hi.  feeling ive not understood fundamental im having issues using crecordset / odbc mfc access data in sql server 8 database. i open database without problems using dsn sql native client.  opens fine , updateable.  record set out using dynaset flag.  problem occurs.  if use dynaset record not updateable.  if use cursorlib database, doesnt support dynaset anyway. now, question - should using dynaset anyway?  trying develop multi-user database application.  problem im looking @ have customer records screen.  if 2 users both @ record, both try update record, how stop happening.  best way lock record 1 starts edit it. i thought using locked field user locking record, run problem of system crashing , leaving record locked perminantly. ive looked time , time again in books , online cant find answer problem?  dynaset seemed better snapshot can details on updates other users.   any information great.   thanks   adrian adrian ,   let’s figure out first why dynaset not

hi, i using customcontrol for implementing business rules validation in workitems customcontrol prevents displaying workitem form properly. in 1 of custom control have validation wheather current user in "assigned to" filed.  if user not matched throw exception "you are not authorized view" shown message box user tfs workitem.   is there other option show message box and same time hide workitem safely? hi, i'd rather suggest employed intended user interaction api display validation error. that, make control implement the iworkitemuseraction interface. here couple of threads explaining how implement interface , raise validation errors: http://social.msdn.microsoft.com/forums/en-us/tfsworkitemtracking/thread/fd9ec233-cbaf-45a6-9780-ea5553eefc64 http://social.msdn.microsoft.com/forums/en-us/tfsworkitemtracking/thread/2a0041c3-c22a-4abd-a3ce-11fc981949c5/ also, here's blog post on how implement interaction between work item controls: http://blogs.msdn.com/

i have parameter containing 2 values when choose first value , run (view ) report after if download on pdf pdf name need name of particular selected value if choose second value , run report after download in pdf pdf name needs second value name example have parameter report type has 2 value msa. rsa when choose msa after running report download in pdf name needs msa.pdf if choose rsa value , download in pdf name of report needs rsa.pdf if create query returns filename, datadriven sub. allow use column specify file name. more info here: http://msdn.microsoft.com/en-us/library/ms159150.aspx however, self-explantory, suggest going report manager , setting up. note available in enterprise not standard edition. mark SQL Server  >  SQL Server Reporting Services, Power View

have application using sql server msde 2000 databse components earlier. upgraded use sql express 2008. after change facing issues in uninstalling databse components during application uninstall. there 2 problems: 1. msde 2000, databse instance automatically uninstalled during removal of application "add/remove programs" in control panel. 2. sql express 2000, doesn't happen automatically , databse instance left on is. created batch file uninstall ( using msexec /x {product code of instance}. not remove instance cleanly , installer fails following exit code. sqlsetup.log ====================================================================== 01/30/2009 15:14:22.140 setup launched 01/30/2009 15:14:22.203 attempting determine media source 01/30/2009 15:14:22.250 media source value not specified on command line argument. 01/30/2009 15:14:22.296 setup launched media directly default value current folder. 01/30/2009 15:14:22.343 media source: c:\e6cef40f7d6f728467c73ca63

i new ssis.  trying develop package create new xml file ("b") xml file ("a") , xslt file.  generated new xml file ("b") when examined contents of new xml file, see birthdate fields , other fields null.  wrong files?  have attached portions of relevant files below. xml file "a":   <xml xmlns:s='uuid:bdc6e3f0-6da3-11d1-a2a3-00aa00c14882' xmlns:dt='uuid:c2f41010-65b3-11d1-a29f-00aa00c14882' xmlns:rs='urn:schemas-microsoft-com:rowset' xmlns:z='#rowsetschema'> <s:schema id='rowsetschema'> <s:elementtype name='row' content='eltonly'> <s:attributetype name='c0' rs:name='school-year' rs:number='1'> <s:datatype dt:type='int' dt:maxlength='4' rs:precision='10' rs:fixedlength='true' rs:maybenull='false'/> </s:attributetype> ... <s:attributetype name='c9' rs:name='birth

hi, we have sis package single 'execute process task' executes sqlcmd.exe follows -s <sqlinstance> -d <dbname> -q <storedproc> -o <outputfilename> the output csv file containing output of 30 queries each headed query name , footed blank row. the stored procedure creates contains 30 queries, each selects hard coded string as query title followed subsequent select of columns different tables. columns aliased name followed commas in single quotes give comma separators along lines of - <columnname> <alias>,', ',',  the net result single csv file of 30 queries, opened in excel, gives 30 different width tables 30 queries generate. this works fine but, on odd occasion 1 of queries encounters invalid character - '?' in column attempting cast int. in instance, csv file gets created , contain output error error message itself. the problem ssis package completes , reports dt_ser_success (0) (probably b

hello, at moment working on little project include build service our company tfs 2010. our tfs behind firewall, not able enable connection between build agend , team foundation server. talked people, having idea realize port forwarding , service bus on azure. have done little quick diagram visualize planning strukture: at moment try figure out need's done, , how done. know has realized above descibed way, not able find informations on how done team foundation server 2010. for me important know, how implement it, or if there better ways. thank help. best regards, jan then suggest take question azure service bus forums:  http://social.msdn.microsoft.com/forums/en-us/windowsazureconnectivity/threads though i'd consider fight rules instead of trying break them using service bus or other tunneling tools circumvent security in place. can try set ports port number allowed organisations policies. my blog: blog.jessehouwing.nl

what do wrong / miss here? i downloaded "carousel_silverlight2bet2.zip , run successfully. however: change spinning "silver.png" icon own .jpg image. why can't add images images folder , change name of image in .xaml file (see below 12-20)? ! have 2 clientbin folders hold  .xap file. (why, run vs2008? )! a) in sliverlight project; .dll etc files             ps: strangly enough not see clientbin folder in vs2008 'solution explorer'! see it,however, in windows explorer! b) in web project; holds .xap file both .xap files have same timestamp , see 'silver.png' when un-ziped! when change image img_0.jpg (see line 14) get, @ run time error follows: image error 4001; message: ag_e_network_error where should , correct procedure? thanks time / hints ed 1    < sl2cbcontrols:carouselpanel x:name= "panel" 2    width= "{binding width}" height= "{binding height}" grid.row= "0"   3   

what domain permissions need have in domain accoun start sql (mssqlserver) service, don't have problem asigning, example sqladmin user with  domain administrator permissions , , works. don't want user a domain administrator thank you. if local administrator, , change service account sql server configuration manager, correct permissions assigned service account.  definately don't need administrator rights. this posting provided "as is" no warranties, , confers no rights. SQL Server  >  SQL Server Setup & Upgrade

hello, please trying count set calculated measure, when set called directly in row , returns fast, when try count set calculated measure(so can slice dimension) query keeps running forever, please ideas. the queries below select {} on 0, nonempty ( {([transaction].[rpc count].&[1],[transaction].[account id].[account id])} , {([account].[paymentstatus].&[0],[account].[account id].[account id])} )  on 1 sax ------------------------------------------------ with member measures.lil as count( //exists nonempty ( {([transaction].[rpc count].&[1],[transaction].[account id].[account id])} , {([account].[paymentstatus].&[0],[account].[account id].[account id])} )) select  {measures.lil}on 0 sax thanks hi i4qr1a, in scenario, first query applies set of members on rows. second 1 count aggregation on set. however, since 2 sets use different hierarchies, supposed throw error below: so can count number of members

i have got 2 stored procedures sp1 , sp2 return results. 1- sp1 returns dataset like: period     gross      net       return     difference   q1          2              6             7           -4 q2          4               4            2             0 q3          1              9              3           -8 q4          2              1             2            1   ...          ...               ...           ...         ... ...          ...             ...            ...           ... 2- sp2 returns dataset pivot of sp1 dataset i.e.                    q1  q2   q3   q4 ... gross          2     4     1     2    ... net              6     4     9     1   ... return         7      2    3     2   ... difference   -4     0    -8    1   ... question: how possible place onto report exact copy of resultset that sp2 stored procedure returns? note have result of sp1 if required purpose. thanks   hi arkiboys , in ssrs, can use horizon

i have ssis package running last friday, monday failing error code  0xc00160ac.  the sever 2008 r2 64x , sql server is microsoft sql server 2008 (sp1) - 10.0.2573.0 (x64)    after research, error appears related running 2005 package in 2008, running in 2008 when working.   i have not been able find on error, suggestions appreciated. thanks tim   here error: executed user: atlas\mas500admin. microsoft (r) sql server execute package utility  version 10.0.5500.0 32-bit   copyright (c) microsoft corp 1984-2005. rights reserved.     started:  2:16:30 pm   could not load package "\msdb\sage mas 500\sage mas 500 mas500_app_fast fast_imp_cadxl" because of error 0xc00160ac.   description: no description found     source:   started:  2:16:30 pm  finished: 2:16:30 pm  elapsed:  0.031 seconds.  the package not loaded. solved @ last! should run problem, resolution reinstall ssis.  not being dba, not in position this, once done, well.   thank

can in writing code reading each record in ssis  excel sheet  example : query : select * table record in () records present in excel sheet requirement : each record should queried.     hi ,   requirement not clear. still if trying create ssis package load data excel file sheet refer below link. https://www.simple-talk.com/sql/ssis/moving-data-from-excel-to-sql-server---10-steps-to-follow/ best regards sorna SQL Server  >  SQL Server Integration Services

we have customized workflow process of test cases 'approved' state can no longer changed testers during test run. we accomplished this by setting rule on field microsoft.vsts.tcm.steps read only. however there times when test case approved , being run error found test steps , test case must set state of 'new' test case can edited. finding if remove 'readonly' rule on transition 'new' state test steps still in readonly state. is there 'writable' rule not seing , how can toggle between readonly , writeable test steps? anyone have ideas on how accomplish this? Archived Forums V  >  Team Foundation Server - Project Management & Work Item

i have older asp web application (not .net)  connects access database , reads tables.  .mdb file resides on web server, along asp page.  access db going away, , tables have been re-created in sql express.  need figure out how connect , read tables either existing non dot.net asp application, or new php application. i have read post faq: how connect sql express "downlevel clients"(access 2003, vs 2003, vb 6, etc(basically not using .net 2.0 or new sql native client)) some more fundamental questions are: 1)  can upload the sql express mdf file iis server, , connect stand-alone file (like access mdb file)?  *** note: sql express not installed on server, standalone mdf file uploaded) 1)a)  if yes, additional code need?  unsuccessful in using following connection string set conntemp=server.createobject("adodb.connection") connectionstring="data source=.\sqlexpress;integrated security=true;user instance=true;attachdbfilename=sonnys_inventory.mdf" conntemp.op

i using transaction replication in environment.   question: @ time when batches completed application team, daily take  5  to 10min apply commands replicated database, but last 1 weak taking 2 3 , half hour. can suggest might reason , solution ? resone think  there more indexes on replicated databae production in replicated mdf , ldf files both on same serveranything else ?  environment on both servers prod replicated __________________________ sql server 2008 r2 standard windows server 2008r2 enterprise cpu 64 (hyper threading enable) 64 gb memory hi imran, could confirm doing reindexing/update stats on both distributor subscriber? were able find slow? publisher distributor or distributor subscriber. need find first. unless added indexes in last week should not have caused huge slowness. but, there increase in amount of transactions in batches. take @ article explains how find slowness. http://blogs.msdn.com/b/chrissk/archive/2009/05/25/tran

hi, i tried place 2 of c# clock controls on page without luck. i figured duplicate clock code in index.html file, , give second object different name, , see 2 clocks.  does have idea how this?  like, maybe 1 clock reading est, , other reading gmt.   thanks you have create 2 silverlightcontrolhost div's. using same 1 in code above. way second 1 replaces first one. something this: < body > < div id= "silverlightcontrolhost" class= "silverlighthost" > < div id= "silverlightcontrolhost1" class= "silverlighthost" > < script type= "text/javascript" > createsilverlight('silverlightcontrolhost', 'silverlightcontrol'); </ script > < script type= "text/javascript" > createsilverlight('silverlightcontrolhost1', 'silverlightcontrol1'); </ script > </ div > </ body >  

hi guys, have looked @ other links in similar thread, deal dividing 0.i have formla =iif(sum(fields!onhand.value) = 0,0,sum(cdbl(fields!onhandvalue.value))/cdbl(fields!onhand.value)) but when 2 values are 11492/1.0416 i get  11 033.026113671300000000000000000000 this comes through infinity on report. i have change th text box formating number 2 deciimals. still same result. any ideas why? hi lancockcroft, generally, issue occur when denominator equal 0 in reporting services. , based on test, create dataset 2 fields, contains value 11492, b contains value 1.0416. use expression (=fields!a.value/fields!b.value) in table, returns 11033.0261136713 result. so think may infinity value not returned 2 values, may returned 2 values. please double check again. , can create sample dataset, test yourself, tell results. create table #temp (a float, b float) insert #temp values    (11492,1.0416) select * #temp if there other questions, please feel free ask. thanks,

hellow! i'm using tcp socket on wpf server, , use sockets on silverlight client networking. is transport of messsages via sockets  secure? (i.e. there integrity , privacy?) the encryption made automatically, or have implement it? you should ask question in http://social.msdn.microsoft.com/forums/en-us/silverlightweb/threads//1?accessing+web+services+with+silverlight . wcf ria services forum, not general wcf forum. might answer here have better chance in web services forum. Silverlight  >  WCF RIA Services with Silverlight

scenario we have existing live ssrs server , new ssrs server.  new server superior existing server regards cpus and memory. the target databases similar in data not identical (as live database moving , have not been able set full copy of live system).  there less data in new databases. we testing performance of 1 of our more complicated reports on new ssrs server.  doing both running report in browser on ssrs server , within our application on client machine. data retrieval on average twice fast.  processing time on average ten times slower.  rendering time on average 4 times slower. we celebrating right processing , rendering times showed same improvement data retrieval time.  however, instead @ loss why processing , rendering taking long. existing environment 2 x intel xeon e5420 (4 cores) 2.49 ghz 8gb ram windows server standard sp1 ssrs 2008 standard edition sp2 new environment 1 x amd opteron 6172 2.10 ghz (12 cores) 8gb ram windows server 2008 r2 stand

hi pros, i have error under system log clustered db servers. cluster resource 'sql server (dbname)' in resource group 'dbname' failed. (18:06:30 event id: 1069) the sql server agent (dbname) service terminated unexpectedly. has done 1 time(s). (18:07:01 event id: 7034) both services auto recovered @ 18:07:16 , 18:07:17 respectively. the cluster service brought resource group "proddb" online. (18:07:17) under apps log, there number of errors well. checkqueryprocessoralive: sqlexecdirect failed [sqsrvres] printodbcerror: sqlstate = 08s01; native error = 40; message = [microsoft][sql native client]communication link failure [sqsrvres] onlinethread: qp not online. this first time, happens, cluster.log replaced. advice? looks affected sql agent resource , caused whole group restart. i'm not finding severe issue sine group has been recovered , brought online there 1 note : - sql server agent resource not essential run engine , run scheduled jobs should con

we have sqlserver 2008 database generates far many logs, switched simple recovery mode, continues write around 100 gb per day ".ldf" after shrinking database. how can stop database writing many logs? not simple recovery mode for? hi dsm0wman,   please refer books online how resolve issue long running transaction cause log filling up:   managing long-running transactions: http://msdn.microsoft.com/en-us/library/ms366331.aspx   in addition, output, query long running transaction below: create procedure [dbo].[dbm_trapmessages_deletestale] @date datetime as begin set nocount on ; declare @chunksize as int declare @catchcount int ; declare @msg varchar ( max ), @sev int , @st int declare @rowcountvar int set @chunksize = 10000 set @catchcount = 0; set implicit_transactions off set transaction isolation level read uncommitted set rowcount @chunksize nextchunk: begin try delete traps from ( select top 10000 trapi