Search results for query: *

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

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?

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

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

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

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