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!

  • Congratulations strongm 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. robertfah

    Search Stored Procedures

    @GMM 1.) At the time, we were only concerned with SP's but I like your suggestion; makes more sense. 2.) This is true...not too sure of a way around it in SQL. I can do it in C#, but haven't figured it out in SQL....gives me something to work on, lol. @SQLScholar GREAT program....I use it a...
  2. robertfah

    Search Stored Procedures

    This works well on SQL 2008 but not on SQL 2000 as sys.procedures and sys.all_sql_modules do not exist.
  3. robertfah

    Search Stored Procedures

    For years I've been looking for a way to search all the SP's in a specific DB for a specific string. In most cases, it's usually when I'm cleaning up our database and find a table that I think is no longer in use. I then need to search the SP's to make sure the table isn't in use. I believe I...
  4. robertfah

    Accessing .cs variable from .ASPX page

    BTW, I meant to mention that txtWebLogin AND the RequiredFieldValidator are in an EditTemplate of a gridview.
  5. robertfah

    Accessing .cs variable from .ASPX page

    I need to access a variable from my code behind in the .aspx page and it's not working. Here's what I'm trying: .aspx page - RequiredFieldValidator <asp:RequiredFieldValidator ID="rfvEditWebLogin" runat="server" ControlToValidate="txtWebLogin"...
  6. robertfah

    Self Join SQL

    SQLScholar - thanks a bunch, works like a charm!
  7. robertfah

    Self Join SQL

    I've got 2 tables that I need to get data from...my users table looks like this: Users Table ------------- UserID FirstName LastName WebLogin WebPassword Active UserAlternates Table --------------------- UserAlternateID UserID AlternateUserID Users Table Data ------------------ 1, John...
  8. robertfah

    Generate SQL Script to create table and it's data.

    I need to write a method that will take a table name as a parameter and generate the SQL statement for creating and inserting the data. What I'm trying to do is copy a table and it's data to another database but I only need the SQL to do so. Any ideas?
  9. robertfah

    Is Order By that costly?

    PK_Issues clustered, unique, primary key located on PRIMARY IssueID it appears as if that's the only index. Here's the results from DBCC SHOWCONTIG: DBCC SHOWCONTIG scanning 'Issues' table... Table: 'Issues' (530816953); index ID: 1, database ID: 10 TABLE level scan performed. - Pages...
  10. robertfah

    Is Order By that costly?

    ggm, cantor - here's the actual execution plan (or part of it): I am working on the SHOWCONTIG results...
  11. robertfah

    Why won't my SP work?

    Remove the extra '@' symbol from the variable and you should be all set.
  12. robertfah

    Is Order By that costly?

    I've got a large query that has many joins and returns roughly 13k records. I've noticed lately that there's a long pause within the program which this SP is executed, so I decided to run it in the Management Environment to see what's up. Here's the SQL: SELECT Issues.*, c.CustomerName...
  13. robertfah

    SQL to get user password

    Thanks RTag, but what if this isn't an option for me (it is, I'm just really curious if there's a built-in SP or if someone came up with something to do this)?
  14. robertfah

    SQL to get user password

    I've got a windows app that uses a Crystal Report to show data from our DB. My issue with it is that in code, it requires a Login name and Password for the DB. I do not want to hard-code this info for obvious reasons, so is there a way I can retrieve a password for a specific DB user with SQL...
  15. robertfah

    Any upgrading issues from SQL 2000 to 2008?

    Thanks guys...I ran the wizard and it fould Full-Text searches needed to be changed (but we don't use them so I think this is ok) and a few Keywords that have depreciated which will need changing. What a life-saver this app is. Thanks for the help! Oh and yes, we ran it in our Staging...
  16. robertfah

    Any upgrading issues from SQL 2000 to 2008?

    Pretty much what the topic says...we are preparig to upgrade our SQL Server 2000 to 2008 and was curious if there are any hurdles that I should be aware of?
  17. robertfah

    Show complete exception error

    Kostarsus, Thanks for the help, it pointed me in the right direction. Within the project, if you right-click and choose Properties, then the Publish tab, then Application Files, there's a dialog box that appears. Makes sure to click the "Show all files" checkbox in the lower left corner. The...
  18. robertfah

    Show complete exception error

    I've got some code that stores any errors to our DB and emails us when it happens. Here's the simple call: catch (Exception ex) { if (System.Diagnostics.Debugger.IsAttached) System.Diagnostics.Debugger.Break(); else...
  19. robertfah

    Best approach to this SP

    What is the best practice/approach to writing a SP that returns either a single row or all rows based on the 1 parameter passed in? Lately we've noticed a need to retrieve either 1 record or all records from tables within our DB (Customer(s), Location(s), Room(s), etc.). So for customers, we...
  20. robertfah

    Select Into Creates HUGE Varchar????? But Data doesn't reflect??

    Ah...yes, didn't take into account for the TRIM functions....now it makes perfect sense!

Part and Inventory Search

Back
Top