SQL Server

Page 2368




  • Topics
    Replies
    Last post
  • GLOBAL CUBE slicing and security challenge
    by Lohic Beneyzet-Jouy
    1 Replies
    Last post by Lohic Beneyzet-Jouy
      • Hi Guys, Context I'm working with SSAS 2005 SP2. I'm quite new at it and I'm struggling with an interesting challenge. I have to create cube files so that Sales Representatives can browse their data offline. A Sales Representative can see his own sales data but also the sales data of the other sales representative with whom he is sharing customers. For this purpose, I want to use the C
  • Tranferring huge data to various tables
    by sureshv
    5 Replies
    Last post by jwelch
      • Actually in my transformation i am transferring huge amount of data. i have been using oledb command finally to dump my incoming data to respective tables. For Example : if you have two tables table 1,table 2 in my incoming data i have a lookup and check for two unique columns with that of the unique columns in the table 1.if the record does not exsist i try inserting a record into
  • Reading Messages with ADO .Net c#
    by Anokneemous
    2 Replies
    Last post by Anokneemous
      • Hello, I am trying to figure out how to properly read a single message(poll) at a time from ADO .Net in c# 2005. I am assuming i need to write a sproc that does a receive, but I wanted to validate if there were already any examples of this already I have been reading quite alot but don't see this exactly as an example anywhere and it is probably easier then my brain is allowin
  • SSEUtil.exe legal to redistribute?
    by lushdog
    9 Replies
    Last post by lushdog
      • Hi. I've been tasked with creating an installer that will either install SQL Express or connect to an existing SQL server. Then I'm to run an .sql script to initialize a new database. I'm using SSEUtil.exe as there will be no SQLCMD if the existing SQL server is on a remote machine. Can I package SSEUtil.exe into my installer Is this legal If not, is there a standard SQL Server client I can use
  • How to enumerate the databases on the server
    by General E Pist
    5 Replies
    Last post by Arnie Rowland
      • Given that you have an interface with a connection to SQL Server Express, is there some T-SQL script or statement that can enumerate the available database names on the server For example: CString clQuery; clQuery.Format("SELECT SERVERPROPERTY('Databases')"); m_db.Execute(clQuery); or something of the sort
  • Update Statment on large data
    by Hossam Abdel Wahab
    10 Replies
    Last post by Hosam Abdel Wahab
      • Hi all i have 2 tables and i need update some fields on the first table if the key fields Exist in the second table else if not Exist i insert record as new my problem summerize in 2 issue (how to manage situation with if ..else) , the 2 tables have more than 20,000,000 Milion performance and duration Kindly if any one has good idea's i will
  • Conversion error
    by Chris Holt
    2 Replies
    Last post by Chris Holt
      • I am getting the error message Error converting data type varchar to float when running the following query: Code Snippet select top 175816 AV.intItemID, AV.intAttrID, -- AV.vchValue, CAST(AV.vchValue AS float) AS Test, 0 from tblAttrVals AV join tblAttributes AA on AA.intAttributeID = AV.intAttrID and AA.intDataTypeID in (2, 3) and (1 = isnumeric (AV.
  • Sorting alphanumeric data
    by bkirkman
    6 Replies
    Last post by daveboo
      • I have data that is stored in a varchar(20) column that looks numeric but can be alphanumeric. For instance: I've tried this: 1a 11a 2a 3 5a 6 1 I want the order to be: 1 1a 2a 3 5a 6 11a SQL I've tried is: Code Snippet SELECT * FROM ( SELECT '1a' AS place UNION ALL SELECT '11a' UNION ALL SELECT '2a' UNION A
  • DISTINCT COUNT WITH NULL VALUES (GRAND TOTAL)
    by freadomfee
    14 Replies
    Last post by Deepak Puri
      • Hello, I have a DB of professors and information related with them. I created the cube, it consist of: Measures: Measure group Professors: Amount of projects (COUNT proj_id) Amount of pulications (COUNT pub_id) Amount of e_books (COUNT book_id) -------------- Measure group Projects: Distinct amount of projects (DISTINCT COUNT proj_id) -------------- Measure gr
  • Hold group constant across time?
    by Frank2808
    4 Replies
    Last post by Frank2808
      • Hi eveyone, My users asked me a question today that I wasn't sure of so I was hoping you guys could give me some advice. Is it possible to make the cube hold a group constant across time For example, I want to take all of the customers that were here in December 2006 and see how they performed during the year. Is that something I can do in a cube Obviously, I could create a seperate cube
  • Modify report elements at run time
    by Chuck Traywick
    4 Replies
    Last post by Chuck Traywick
      • I have a report that is embedded in a .net 2.0 web form. It works. I would like to be able to modify some of the elements in the report as the web form loads. I have tried the following code that did NOT work: Dim myImage1 As New Image myImage1 = Me .ReportViewer1.FindControl( "Image1" ) myImage1.ImageUrl = "Images/small_info_logo.jpg" Does anyone kn
  • Can't uninstall or reinstall nonfunctioning sql server
    by rwbogosian
    14 Replies
    Last post by Mike New
      • In previous post in the Getting Started section, I discussed problems trying to run queries on multiple databases: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=299240#299240&SiteID=1 Nobody could help with the problem. I eventually got a query to run after several attempts at deleting and recreating databases. Then, I was hit with the following error message: Class does not s
  • How can I change the default location of full text catalog?
    by Shih-Chao Lin
    3 Replies
    Last post by Shih-Chao Lin
      • Our current full text catalog default location is C:\Program Files\Microsoft SQL Server\MSSQL.5\MSSQL\FTData, we want change the default location to c:\data\MSSQL.5\FTData, so all the FT catalog will be created in this new location. Can anyone tell me how to do it Thanks ShihChao
  • dev and production server - cache issue
    by SteveNovoselac
    7 Replies
    Last post by Darren Gosbell
      • i have two servers, both running SSAS, my production server recently became really slow performing lookups, just in one cube. I cant seem to find the root cause. I took a backup of the production and loaded it exactly as production but on a different server. I can query the cube in development fast. Looking at profiler, it seems the one cube with performance issues isnt looking up things in cache
  • Susbtitute Between for any Expresion in MDX
    by sancho
    5 Replies
    Last post by Darren Gosbell
      • Hi all I have the following sql: select sum(price), article_id from Fact_Sales where @date between StartDate and EndDate and I try to translate this sql to mdx. Of course, this table is a valid-price product with start-date and end-date validity. PK is article_id and StartDate, I know this is not the best design but some times you didn't select the design. Someone ca
  • Replication problem in SQL Server 2000
    by Mortsdeh
    5 Replies
    Last post by Mortsdeh
      • Hi all SQL Server experts! I have created replication on my two servers (production and backup servers). I used wizards to create it and then generated SQL script for deleting and creating replication. For another task I came across the command sp_removedbreplication 'dbname' and I tried to use that for removing replication more easily on the servers. It seemed to not remove everything on the p
  • Key time column for time series algorithm
    by Helen999888
    2 Replies
    Last post by Helen999888
      • Hi, all experts here, Thank you very much for your kind attention. I am confused on key time column selection. e.g, I want to predict monthly sales amount, then what column in date dimension should I choose to be the key time column Is it calendar_date (the key of date dimension) column or calendar_month Thanks a lot for your kind advices and help and I am looking forward to
  • sql2005 - replication monitor issue HELP
    by FrankLi
    4 Replies
    Last post by FrankLi
      • Hello, I have setup sql 2005 transactional replication system with three machines (publisher, distributor and subscriber). Couple weeks later, publisher with publications is disconnected from replication monitor (under My Publishers ¨C show X on the publisher machine name). I didnĄŻt change any things. Can you help for this please Thank you for any help!!
  • SQL Server Management Studio
    by Jimmy Koo
    7 Replies
    Last post by Amariddh
      • Every time I open the SQL Server Management Studio, I need to key in the server and login credential in order to connect to the server. Is there any way to register the server like the Enterprise Manager for SQL Server 2000, so that I don't have to connect to the server every time I open the Management Studio Thanks.
  • IO Completion Listener Worker appears to be non-yielding on Node
    by RJDBA
    2 Replies
    Last post by Jerome Halmans
      • I am getting this message in the event log "IO Completion Listener (0xe0c) Worker 0x00000000040601C0 appears to be non-yielding on Node 0. Approx CPU Used: kernel 0 ms, user 0 ms, Interval: 15016." Soon after this, the sql server stops. I am using SQL Server 2005 service pack 1 This has happened twice. The during this time the CPU goes very high and after that the sql server service stop
  • Visual Studio (Business Intelligence Development) problems when connecting to database
    by Luskan
    0 Replies
    Last post by Luskan
      • Hello, is anyone experiencing problems when conneting to the database Me and my colleague experience the same error. The last time i was able to connect to a database from Visual Studio was last friday may 11. Since the the application (VS) is "not responding" when connecting to the database (Sql Server 2005). Any suggestions Thanx for your help!
  • Unable to install MS07-004
    by Karl Kelly
    2 Replies
    Last post by Keone
      • Im getting the error message "The version of Internet Explorer you have installed does not match the update you are trying to install." For MS07-004 KB929969, ive gotten it on several servers running Win Server 2003 SP1. Ive done all patches up to this point
  • How to avoid blank pages( Converting to PDF format)
    by shamen
    4 Replies
    Last post by shamen
      • HI All, When I view my reports in PDF format, I can not view the whole report on a single page. Thats fine with me. But the problem is report is appear on every other page. not on continuous pages. How can I avoid blank pages Thanks
  • Calculated Fields in the report
    by shamen
    9 Replies
    Last post by shamen
      • I'm supposed to create a report like shown below. Credit Tier Jan-07 Feb-07 Mar-07 AA 0.00% 0.00% 0.00% A 0.00% 0.00% 0.00% B 0.00% 0.00% 0.00% C 0.00% 0.00% 0.00% Time columns go up to Dec 07. But I did not show all the columns. The values are
  • Object reference not set to instance of the object while trying to sync.
    by Dipesh A.
    6 Replies
    Last post by Dipesh A.
      • Hi, I am trying to configure web syncronization using the wizard for a merge replication. However when I am trying to add users (in authentication mode), I get an exception "Object reference not set to instance of the object ". Please let me know if you have any inputs on this. It will be highly appreciated..