Search results for query: *

Hi, I have a database in MS SQL 2000 Server that I need to run the dbcc checkdb (db, REPAIR_ALLOW_DATA_LOSS) I have tried putting the whole instance in single user mode with sqlservr -m and just the db in Enterprise Mgr. Which in it's self works. But when I try to connect with Query Analyzer...

Hi, I need some help to install a test database on the same SQL server. I need to bring the data along from the live database as well. I did it once successfully but I can remember and we have too many people using the db now for me to make a mistake. I have tried to create a new db and...

Hello, We're using ASP to show reports to our affiliates. Right now, we have a report page that has 3 tables on it (there is one html table per query). We would like to have a single query that groups rows by RegTime and shows the value for each of these three queries on the same row. For...

Hi, I need help with a simple join. I'm not sure where I'm going wrong but help would be appreciated. Table Structure:: Table1: ZipCode Table2: ZipCode Table 1 - sample data ZipCode _______ 12345 12346 12347 12347 78943 78942 Table 2 - sample data ZipCode _______ 12345 12346 12347...

Hello, We have lots of servers that several admins have to connect to. I was wondering if there is a way that I can create an ASP page for our Intranet that would give them a way to click on a hyperlink and Launch their local Remote Desktop application and connect them to the server from the...

Thank you. That worked great.

I need help with a select statement please that deals with combining some columns and a range I have 2 tables that contain phone numbers: Table1 has the following columns AreaCode Prefix Suffix Table2 has the following columns AreaCode Prefix LowRangeSuffix HighRangeSuffix How do i write...

Yes, thank you. I did move it once I got an error. I am going to be using this solution. I appreciate you taking the time to suggest it. Warmest Regards, Steve

Thank you. That worked great. Regards, Steve

Hello, I have some text files i need to deduplicate. I have started with the following code but I'm getting an error and don't know where to go from here. File 1 text file contents: steve@123.com steve@234.com steve@123.com I'm wanting to check if the string already exists in the File 2...

Ah, Yes. it was a permissions issue. Thank you. I was blinded by the obvious. :) Steve

Hello, I have a Windows 2003 Server, IIS, ASP installed/enabled all in a default installation and no special tweaking. FSO isn't working on correctly and I'm sure it's something simple. Here is a simple test that returns "false" when it should return "true" because I have verified that the...

I was in the middle of responding to your question about the alternative method and when I clicked Submit Post the page redirected to an tek-tips administrative page saying there are issues with my account or something. I've been using tek-tips for 4-5 years without any issue so I'm not sure...

Ah YES!!!! That worked like a charm!!!!! George, Thank you very much for your help through this. I appreciate it very much. Warmest Regards, Steve

No, I haven't tried. My concern is that they run this in a 3rd party program. They are given a textbox to put their query. I'm not sure how that application will deal with something that is not a select statement. I am pretty focused on getting it working this way to get people off my back. I...

Hi George. This is Steve. My EchoAlertcom handle isn't working all of a sudden. I've emailed them but I need to keep convervasation going in the mean time. I like the first approach better for how we're doing things. So if we can stay with that way I would be greatful. I am getting that same...