Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Steffi1013

    Upgrade SQL Server 2005 32 bit to 64 bit

    Can someone point me in the direction of an in-place upgrade from 32 bit to 64 bit SQL Server 2005 Standard?? I am having a devil of a time finding documentation for this
  2. Steffi1013

    Upgrade SQL Server 2005 32 bit to 64 bit

    Are there any gotchas or anything like that? Or is it as "simple" as running the 64 bit cd?
  3. Steffi1013

    Upgrade SQL Server 2005 32 bit to 64 bit

    I have a server with the following specs and want to know if it is possible to do an in place upgrade from SQL Server 2005 32 bit to SQL Server 2005 64 bit... 2008 Enterprise but not R2 64 Bit OS with 32 GB of RAM SQL Server 2005 Standard 32 bit
  4. Steffi1013

    Sort in Report Manager

    Is it possible to sort in Report Manager while in List view? I have SQL Serve 2005 Reporting Services and am tryng to have all th folders show in the list view first and then the individual reports afterward.
  5. Steffi1013

    List all Reports with Shared Data Source

    Perfect! That will give me what I am looking for -- I was hoping to be able to write a query that would give me the same thing, but this will definitely work. Thanks!
  6. Steffi1013

    List all Reports with Shared Data Source

    This doesn't show if the report is using shared datasource. It shows the name of the datasource that was used when creating the report in VS. What I am trying to figure out is if there is a way to see if the Report is using a shared datasource (the first option under data sources in Report...
  7. Steffi1013

    List all Reports with Shared Data Source

    Is there an easy way (or not so easy way) to get a list of all reports that use a shared data source and the name of the data source?
  8. Steffi1013

    Query all Stored Procedures

    Thanks everyone! This gave me what I needed.
  9. Steffi1013

    Query all Stored Procedures

    I am a little confused as to what you are suggesting? Are you recommending I script out all the procedures before searching for that string inside the procedure?
  10. Steffi1013

    Query all Stored Procedures

    I am looking for a way to query all my stored procedures in a certain database to find out if the string "set transaction isolation level read uncommitted" has been put in them... does anyone have an easy way to do this?
  11. Steffi1013

    If Statement

    So how would I convey that in an sQuery or Stringbuilder??
  12. Steffi1013

    If Statement

    Stefanwagner: Could you explain in depth a little more about your idea of using UNION?? The programmer ran the first select and then the other and I want to use all the information from the second select EXCEPT if the EMPLOYEE (id) = 12345 in the EMPLOYEE table. If EMPLOYEE (id) = 12345...
  13. Steffi1013

    If Statement

    Thx for the explanation! Now back to the original problem... since I am trying to do an if statement in the second statement that would reference the first if statement - is it best to put it in a method and then call it unconditionally the first time and then call it conditionally in the...
  14. Steffi1013

    If Statement

    What is the difference between sQuery and Stringbuilder/Stringbuffer?
  15. Steffi1013

    If Statement

    My thought is that I may need to create a function with the first "select" statement and then call that method with no conditions and then in the second "select" statement, call the method conditionally? Am I on the right track?
  16. Steffi1013

    If Statement

    Here is the second statement that pulls the employee table that if in this statement the emp id = then I want it to grab the EmpName from the first query Statement stmt = null; ResultSet rs = null; String sQuery = ""; try { stmt =...
  17. Steffi1013

    If Statement

    I am attempting to modify someone else's code and I need to do the following... If employee id is 611481, then use the EmpName field in ReportMenu for the employee name, not the LAST_NAME, FIRST_NAME fields in the EMPLOYEE table. The code that already exists is: String sQuery = ""; try {...
  18. Steffi1013

    Report Manager to Access data inside firewall

    How hard is it to configure Report Manager to access data inside a firewall from outside the firewall? We have Report Manager running on a webserver outside the firewall right now and need to access Lawson Test data inside our firewall.
  19. Steffi1013

    Difference in Versioning on SQL Server 2005 x64

    That is quite interesting that an upgrade changes the mode to 8.0 even though it is a 9.0 server. I don't have a test server that I can test this... when I ran the original test, I did not have this issue. But when the production upgrade package was created and ran - it changed the mode. I...
  20. Steffi1013

    Difference in Versioning on SQL Server 2005 x64

    This server was built as a SQL Server 2005 x64. I did detach and attach a 2000 database from another server to this one, but that should not have changed the compatibility setting from 9.0 to 8.0. The only thing that was done was a Great Plains upgrade on this server and I still don't see that...

Part and Inventory Search

Back
Top