Recent content by robertfah

@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...

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

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...

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

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"...

SQLScholar - thanks a bunch, works like a charm!

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...

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?

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...

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

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

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...

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)?

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...

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...