SQL Server

Page 1820




  • Topics
    Replies
    Last post
  • A Simple Problem. But....
    by SunilKumar111
    8 Replies
    Last post by Rob Farley
      • Hi everybody, I have a requirement in which a user fetches some records from a table. I want that records to be locked for that user so that when other fetches records these should be records not fetched earlier. Currently I am using a stored proc in which I rerun the select statement to lock the records in temp table. Any better solution Thanks in advance
  • how do i save a file from the report viewer control
    by Karenros
    0 Replies
    Last post by Karenros
      • Hi, How do i save the file when the user clicks on export to Pdf in the report viewer control Regards, Karen
  • Generates Msg 107, Level 16, State 2, Line 2 - column prefix does not exist (Oh yes it does.. anyone got a solution ?)
    by DB007
    1 Replies
    Last post by Arnie Rowland
      • hi All, Following code generates error 107 (SQL Server 2000, SP3a): SELECT * FROM dbo . AssessmentItemHierarchy Parent INNER JOIN dbo . RaterCategory INNER JOIN dbo . RaterType ON RaterCategory . ID = RaterType . RaterCategoryID INNER JOIN dbo . AssessmentRater ON AssessmentRater . RaterTypeID = RaterType . ID INNER JOIN dbo . Assess
  • turn report auto-scroll feature off when toggling drill-down
    by vanekl
    11 Replies
    Last post by jbob
      • Is there a way to turn IE7's auto scroll off so that every time you drill down by clicking on one of the "+" toggle buttons the report doesn't recenter itself. We find this window jumping/scrolling highly annoying to watch. This problem does NOT occur in FFox, just Microsoft's browsers. We are displaying this report running on another server running Visual Studio 2005's ReportViewer cont
  • Dimension Design Question
    by Arun
    6 Replies
    Last post by Arun
      • I have a question about designing a dimension. I have a fact table with 2 bit columns "IsBalance" & "IsAttribution". Possible values are (0 , 1), (1, 0) and (1,1). Pl note that the fact table cannot be changed. I use SSAS 2005. I had created 2 dimensions (from named queries) called Balance (Members : 1, 0) and Attribution (Members : 1, 0) to implement the ab
  • formula in a query
    by Edwin Gutierrez
    12 Replies
    Last post by Edwin Gutierrez
      • fellows i am working in this formula (( 4 * dbo . Drillability . WEIGHTONBIT ) / ( POWER ( PD_Data . dbo . db_drill_hole_base . loaded_diameter , 2 ) * PI ()) + ( 8 * dbo . Drillability . RPM * dbo . Drillability . TORQUE ) / ( POWER ( PD_Data . dbo . db_drill_hole_base . loaded_diameter , 2 ) * dbo . Drillability . ROP )) * 0.006894757 AS SPEC_ENERG
  • Database Mirroring & Replication Considerations
    by rgnichols44
    1 Replies
    Last post by Vishal Gandhi
      • Hi all, Can a publisher be mirrored What are the implications, issues, gotchas Transactional, Merge or Transactional w/ Updating Subscribers is what I'm considering. Bottom line is I would like to use mirroring, but only one mirror will not suffice. Thank you in advance. Ray Nichols
  • MSResultSetGenerator does not work any more
    by Mathias Raacke
    5 Replies
    Last post by Mathias Raacke
      • I try to generate a typed result set. I first added a new data source to my project and then changed the custom tool property of the .xsd file from MSDataSetGenerator to MSResultSetGenerator. This was working a few days ago, but recently, it stopped working. I now get the following error when I right click on my .xsd and then "run custom tool": Error 102 Custom tool error: Failed to g
  • Reading XML file
    by Shlomi Meoded
    3 Replies
    Last post by Lisa Nicholls
      • Hello, I'm trying to read data from xml file (i want to use this file as enviornment config file). i tried 2 methods and failed in both of them: 1.a. I loaded the XML file to the report server 1.b. I wrote a custom code for reading the XML. i got #Error 2.a. I loaded the XML file to the report server 2.b. I used XML dataset for reading the XML file. thank you all
  • What are new in SQL Server 2008 Analysis Services release?
    by Helen999888
    2 Replies
    Last post by Adrian Dumitrascu
      • Hi, all here, Just noticed SQL Server 2008 is coming out next year. Anyone here have any ideas what are significant new product features in SQL Server 2008 Analysis Services compared to SQL Server 2005 Analysis Services Would be very interesting to know that. Thanks. With best regards, Yours sincerely,
  • stored procedure help
    by Brown Knight
    10 Replies
    Last post by Arnie Rowland
      • I would like to create a stored proc to Get The oldest employee at the time they were hired was [Firstname] [Lastname], who has been with the company for [X] years, months and days. i am lost on the learning process.
  • New to MDX. How to use "links" between dimensions
    by netterdotter
    5 Replies
    Last post by Deepak Puri
      • Hi, I'm very new to AS and MDX so I'm probably not using the correct terms here, sorry about that. I'm using a cube created by PerformancePoint Server. Among other things, I have the dimensions Project and Customer. Each Project has what PPS calls a dimension property which is linked to Customer. In AS I assume that this is added as an attribute in the Project dimension. What
  • Looping scripts
    by Tim123
    2 Replies
    Last post by jwelch
      • I have an application that manages the booking of rooms in several different buildings, and am trying to build an SSIS package to build a table containing records showing the total number of hours per day that each building is being used. Because two bookings in the same building can take place at the same time or overlap with each other, it's not a straightforward sum of the hours per booking.
  • SQL_2005_Express-"Help file not found" err...?
    by Stefan Viatchev
    2 Replies
    Last post by Mike Wachal - MSFT
      • Hei everybody, Can someone explain why I get this err. msg. on SQL express The installation went OK, no err, but when I press "Help" in SQL I get this message! Thank you! Stefan
  • Why doesn't the Execute Package Task support parameters?
    by Jamie Thomson
    9 Replies
    Last post by jwelch
      • [Microsoft follow-up] dtexec.exe allows us to pass values into a package using /SET and a property path. Why can't we do the same using the Execute Package Task And yes, I know about Parent Package Configurations, I use them alot. But I would still like the ability to pass values in. -Jamie
  • Using IN as filter
    by jschroeder
    3 Replies
    Last post by Jarret
      • What is the syntax for using IN as a filter in SQL it would be IN( 'A', 'B', 'C') but this does not work in Reporting services.
  • I don't believe ...
    by cgsdev
    5 Replies
    Last post by VDeepak
      • I don't believe ...that not exists a resource for put optional parameters for filter in Reports else WorkArounds !!!
  • problem in the membership and role functionality
    by NitinVerma
    3 Replies
    Last post by NitinVerma
      • i m using Visual studio 2005 sql server2000 and i have installed the membership database in my same database as for my rest of the tables my login page is placed with a login control database is having a user named : "bbbb" with password !@#$%^& (Shift+1234567) the code is working very well on my local host but when it is uploaded to the web server it is not
  • Checking User & Expire of Update Possibility (by Trigger), How to?
    by HSBF Lewe
    5 Replies
    Last post by Jens K. Suessmeyer
      • Hi, I have Table (RatesTable) every user can insert records to this table, and all users can see this records, this table contain the following columns: RateID , Service , Rate , DateTime , User Want I want is a code (trigger) in the database can do the following: If user perform an Update request the code will check: - if this recored inserted by the same
  • Expression - Compare dates
    by MrHat
    8 Replies
    Last post by MrHat
      • How can I check if: Date1 is newer than Date2 Thank you!
  • Custom error msg breaks my error handler
    by sadie519590
    7 Replies
    Last post by sadie
      • Hi, I added this line of code to my error handler script, in red. User: criptError is a package-level string variable User: criptError has a value assigned to it when another script encounters an error condition (which I define) I added "User: criptError" as a read-only variable to the error handler script task. Public Sub Main() Dim messages As Co
  • does Internet Explorer generate logs.
    by pratap_gemini
    1 Replies
    Last post by Andrew - T4G
      • Hi, I have an query. Does Internet Explorer generate logs files. If so where does the files get generated. Thanks in advance.
  • SQL Query
    by Dcoder85
    3 Replies
    Last post by Dcoder85
      • Hi, i have an SQL query as follows: -- SELECT GRAPH_INCIDENTS_LIST.INCIDENT_DATE AS [Date], Count(GRAPH_INCIDENTS_LIST.ID) AS [Count] FROM GRAPH_INCIDENTS_LIST WHERE 1 = 1 GROUP BY GRAPH_INCIDENTS_LIST.INCIDENT_DATE UNION SELECT [EventDate] AS [Date], t_Events.Count FROM t_Events ORDER BY [Date]; -- which produces results like: Date | Count 04/01/2006 | 1 14/01/2006 | 0 14/01/2006 | 14
  • SQL 2005 Pull Subscriber stuck "Uploading data changes to publisher"
    by Drewcasa
    4 Replies
    Last post by Hilary Cotter
      • I recently ran some schema updates on a SQL 2005 Merge Replication system with 7 pull subscribers. The updates included a new table and a foreign key between an existing replicated article and the new table, as well as some additional columns on other tables. Without thinking about the consequences, I ran the schema updates on the publisher first, and immediately saw errors because the foreign key
  • Move Log Files From C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG To E:\MSSQL Logs
    by JustinK101
    4 Replies
    Last post by JustinK101
      • How do I move the default log files placed in: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG to a different location I want to place them in a partition I have setup which stores log files Reason being is that this log directory is getting quite large, 600MB and I want to conserve space on my C:\ partition. Thanks.