Lun

hi, i kept getting error doing below , not find wrong. can take look? declare @geog geography; declare @geom geometry; set @geom = geometry::stpolyfromtext('polygon((101.672729 3.106615,101.674123 3.108650,101.674067 3.110243,101.672484 3.114602,101.672489 3.114701,101.676913 3.115032,101.677854 3.115422,101.679595 3.114258,101.682601 3.112739,101.686587 3.112115,101.688313 3.111350,101.694240 3.104536,101.695499 3.102511,101.696886 3.101461,101.695710 3.098697,101.695138 3.096237,101.695293 3.092493,101.698320 3.084698,101.702435 3.080928,101.703026 3.078771,101.702230 3.074790,101.703138 3.063713,101.704564 3.057330,101.705382 3.050862,101.702204 3.050689,101.698317 3.049582,101.690278 3.048998,101.679846 3.048987,101.673437 3.048943,101.673313 3.048761,101.673334 3.047441,101.673511 3.043867,101.672355 3.042247,101.672240 3.038895,101.671049 3.037673,101.664741 3.036156,101.664570 3.035070,101.649260 3.034952,101.636260 3.034944,101.635901 3.037785,101.632650 3...

hi, please tell me in case disk io more cpu time , vice-versa --cpu time more disk io and if disk io cpu disk io --377889  , cpu --89 and disk io more cpu cause problem in database... thanks disk i/o , cpu time independent metrics.  session can have large amount of disk i/o little cpu time , visa versa.  1 can't ascertain whether values abnormal since values cummulative since session established.  numbers reported sp_who2 provide quick high-level overview of session activity , not particularly useful in performance monitoring.  dan guzman, sql server mvp, http://weblogs.sqlteam.com/dang/ SQL Server  >  SQL Server Database Engine

how check network libraries has been selected when installing sql server. how can change without reinstalling sql server? in sql server configuration manager can enable , disable network protocols require. hth ewan if have found post helpful, please click 'vote helpful' link (the green triangle , number on top-left). if post answers question, click 'mark answered' link below. helps others experience same issue in future find solution. SQL Server  >  SQL Server Database Engine

prefix: don't have control on oracle side change or add code! need connect oracle db, call init procedure (format: package_name.procedure_name), run select statement. these 2 actions have done in sequence within same oracle session . tips on how either in siss or directly on mssql db? regards jacco can describe need results select statement? in ssis, use execute sql task 2 commands imagine, , connect either oledb source or ado.net source oracle. provider used to connect oracle partially dictates if procedures can run or not. procedure return results, or prep work within database? execute sql task can handle results sets , put them variables, won't insert server/destination. there property retainsameconnection = true on connection manager, means when 1 connection open, connection remains open , reused later component, , stays open until end of package.  scenario described @ http://blogs.conchango.com/jamiethomson/archive/2005/08/20/2048.aspx it helpful in kind of sa...

i trying install/configure tfs extensions sharepoint on sharepoint 2010 enterprise server (tfs not installed here).  when run config wizard, error shown below.  the account using install farm admin already.  the site trying access central admin site.  i can open ie , browse site without problem.  any idea?  thanks  ============= tf255329: following site not accessed: http://mycentraladmin:10000/. server specified did not return expected response. either have not installed team foundation server extensions sharepoint products on server, or firewall blocking access specified site or sharepoint central administration site. more information, see microsoft web site (http://go.microsoft.com/fwlink/?linkid=254457). don't worry.  i have figured out.  so experiencing similar issue , running separate sharepoint farm has multiple web , app servers, here need aware of: install , configure tf sharepoint extension on server has central admi...

hi all  sql20008 r2 on localhost w7 (x64).  oracle 11g connect   use oracle oledb  i have both 32 bit , 64 bit client (in path 32 bit first one)  i made dsv on oracle in bids , works ok.  i see oracle data explore data in bids 2008.    but whn process employee_d dimension got error  (sql tables dimension porocessed ok) :  errors in olap storage engine: error occurred while 'employee ref id' attribute of 'a0_employee d' dimension 'emis external v3' database being processed.    errors in olap storage engine: error occurred while 'person name' attribute of 'a0_employee d' dimension 'emis external v3' database being processed.    reading forum re-tried tricks impersonation info - 4 of them  it not worked out.        any ideas ? i found http://social.msdn.microsoft.com/forums/en-us/sqlanalysisservices/thread/1b10a45c-47cf-4d91-a8a4-d4cbeacec30...

hello, everybody: i using sql server 2012 , windows server 2012 essential. configure report service. seems working, however, when each time open ie access report website, popup login windows access site , "administrator" user name , password working. know how fix it? yhong hi yhong, ssrs uses windows authentication, our user name , password we're seeing our windows login. there no separate account report manager. if we're seeing prompt, might have user account control enabled , it's prompting because of that. or our browser not enabled windows integrated security. to avoid prompting login dialog, please add site intranet zone or trust zone using internet explorer. there similar thread, can refer it. http://social.msdn.microsoft.com/forums/sqlserver/en-us/b9c8e1d9-5f85-4019-910f-993121e00ede/ssrs-2008-report-manager-authentication-issues regards, alisa tang we trying better understand customer views on social support experience, partic...