Lun

  hi i'm new analysis services , intall application start learning it.  have manage create cube dimensions.  issue when ever trying view data within cube or dimensions giving me following error msg:   "unable browse cube sales. unspecified error"   any idea missing?  while creating cube, manage view data in creating fact table step, tells me have connection database.  using access database source database analysis service example "foodmart 2000".   many thanks k hi, did manage deploy , process cubes?   radim SQL Server  >  SQL Server Analysis Services

hi i want temproraly stop cacheing when test stp procedure, there "set nocount" also need determine execution time of stored procedure, managment studio thinks 0!!, think there stoping performance measurment there , default. thanks help set nocount has nothing caching. asking set statistics on , set set statistics time . if yes check this http://www.sql-server-performance.com/articles/per/statistics_io_time_p1.aspx madhu mcitp, mcts, mcdba,mcp-- blog : http://experiencing-sql-server-2008.blogspot.com/ SQL Server  >  SQL Server Database Engine

hi, experts here, i wondering if bad practice put user tables master database? pros, cons? any suggestions or discusstions please? thanks. i looking forward hearing you. best regards, yours sincerely,     yes, bad practise.   go through idea. master database   master database records existence of other databases , location of database files , records initialization information sql server. therefore, sql server cannot start if master database unavailable.   so happened master sure whole server in trouble.  better keep safe normal user.   regards SQL Server  >  SQL Server Database Engine

hi we have scenario following: iis 7.5 server in dmz separated internal domain. each application on iis runs under separate application pool. ms sql 2008 r2 server member of internal domain questions: is possible use applicationpoolidentity of iis server (e.g. "iis apppool\myappapppool") login sql server using windows authentication considering iis server not part of same domain , network sql server? if not, there way can use windows authentication logins iis server set upin manner (standalone, not part of domain)   p.s. this approach works fine on iis server member of same domain sql server.... hi zam6ak,   is possible use applicationpoolidentity of iis server (e.g. "iis apppool\myappapppool") login sql server using windows authentication considering iis server not part of same domain , network sql server? the login in sql server can created windows account. recommend ask in iis forum see account related applicationpooliden...

i new sql server experienced oracle dba.  have sql server 2000 database connect remotely sql 2005 database.  collation of msdb on sql server 2000 sql_latin1_general_cp1_ci_as , database im trying create view (call scottdb) in sql_latin1_general_cp1_cs_as.  there has not been problems in past doing sort of joins in the scottdb database.  created 2 new tables in scottdb (no problem), few associated indexes , new view joins both new tables existing table in database.  i receiving dreaded error:   cannot resolve collation conflict equal operation there nothing view, couple of easy little inner joins.  deleted tables , view, went machine directly in case 2005 management studio issue , received same error.  issue driving me wall.  can please talk me through best way fix it.  much appreciated scott   hi, you have collation statement before equal operation "casting" 1 coallation other. collation conflict prevent engine joining or comapring 2 values each other, example exp...

in sequence queries , sub-queries executed sql engine? which correct ? a. primary query -> sub query -> sub sub query , on b. sub sub query -> sub query -> prime query c. whole query interpreted @ 1 time d. there no fixed sequence of interpretation, query parser takes decision on fly hi accessguru, the query sequence depends on type of query use. post, confused b option, take nested sub query example. nested sub query can nested inside other sub queries, select statement nested within select statement , return intermediate results. sql executes innermost sub query first, , next level. results of sub query query conditions of primary query. in case, query sequence sub query-> primary query, option b right answer. more information nested query, please refer article: http://www.w3resource.com/sql/subqueries/nested-subqueries.php#sthash.o0wi3mau.dpuf . if correlated sub query, sub query uses values outer query. sub query evaluated once each row proce...

 all, i have downloaded , installed visual studio 2005 sdk 4.0, using tfs 2005. i creating new application, , can set reference microsoft.teamfoundation.workitem.  shows in list of available references, , bin directory contains multiple dlls , xml files. here's gets interesting.  intellisense doesn't recognize objects, if force creating object get: could not load file or assembly 'microsoft.teamfoundation.workitemtracking.controls, version=8.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a' or 1 of dependencies. strong name signature not verified.  assembly may have been tampered with, or delay signed not signed correct private key. (exception hresult: 0x80131045)   here's what's on machine: microsoft visual studio 2005 version 8.0.50727.867  (vsvista.050727-8600) microsoft .net framework version 2.0.50727 sp2 installed edition: professional microsoft visual basic 2005   77626-009-0000007-41187 microsoft visual basic 2005 microsoft visual...