Search results for query: *

I own several asp/jsp systems that tend to get, for lack of a better word, "clogged" with cache. When a problem is reported the first response is "Have you closed all browsers and cleared all cookies (CABACAC)?" Unfortunately many of my users will have a dozen sessions open with mutliple tabs...

We are migrating to a new SQL box and have to point hundreds of reports to the new server. Is there a way to script this? -If it ain't broke, break it and make it better.

I have a package that executes successfully, but throws up the following error: Error: The connection "050262" is not found. This error is thrown by Connections collection when the specific connection element is not found. Now, I may have set up connection "050262" at some point during...

I'm currently testing an application that extracts data from SQL to text files then FTPs the data. All of that works fine, but I need to determine if it is better to set the extracts up in sequence or if I can run them all at once OR where is the line that determines one process is better than...

I have a Dell laptop with Vista Ultimate on it. I've had this machine for about a year now. Roughly a month ago the thing started rebooting out of nowhere. It has never rebooted while I'm working on it. When I set it aside I will hear the reboot music and sure enough it is rebooting...

I have a very long and very complex stored procedure that produces a dollar amount given parameterized values. I have inserted into a temp table all values that will be passed to the procedure. This temp table has one more column that I need to populate with the OUTPUT of the stored procedure...

Ultimate version. A guy I work with is having issues with his laptop. He said the other day it locked up, went to the BSOD, but there was no writing. There were white squiggly lines moving around on the screen. He couldn't C-A-D and had to hard boot. Just a few minutes ago I saw it happen...

I've searched and searched and cannot find a solution to this problem. I simply cannot believe it is that difficult, so I'm going to put out here for you guys. I have a database with 400 tables. I need to dump all of the data from each table into seperate delimited, text qualified flat files...

Hi all, I have 100 facility databases spread across the country. I've been charged with implementing the following solution: - Each facility db will be replicated to a master db (warehouse of sorts). All facilities have the same table structure and data will be "merged" into one master...

I'm not a programmer, so I'm betting there is an easy solution for this. I have a table similar to the following: ID Name RelatedID RelatedName 1 A 1 <TBD> 2 B 3 . 3 C 3 . The relatedID field...

Hey all, I have a stack of old IDE hard drives I need to go through to find some really old work files. I purchased a USB to IDE converter and have connected to my Vista Ultimate laptop. Vista recognizes the device and loads the necessary drivers, but I do not see it in Explorer. I then went...

Hey all, I've been called to a client's site that is installing a "database independent" solution. Of course, that means more work for my client. They are running into tons of performance issues and asked me to fix them. Unfortunately, most of the issues are caused by this "database...

Something tells me this is going to be an easy one. I hope it is because I have spent the past two hours trying to figure it out. I'm trying to update a table based on the value in the RefNum column. I thought the best way to do this was a simple CASE statement, but I've been running into a...

Here's the deal, I have two machines on the same network with the same mask and gateway. Both machines can ping all machines on the network and both can access the internet. However, one machine wrkstn1 can ping wrkstn2, but wrkstn2 cannot ping wrkstn1. Both machines have the exact same...

I'm having problems getting SSRS to run on my laptop. I'm studying up for the 431, so I installed SQLEval. I got to the chapter regarding SSRS and decided it was time to install IIS. I did so, went into Reports Config, and got a message saying there was no Report Server. I checked and SSRS...

My wife is sick and needs to be able to VPN to the office. She cannot and her tech gave her the, "Don't know" answer. Here's what is going on, she cannot connect to the VPN address. What's weird about this is that she can log onto the company's website, but cannot ping it. For example, I can...

I have a POS from Action Systems called Restaurant Manager (version 15) installed in my lounge. Before I post my HUGE laundry list of issues I'd like to make sure there is at least one person familiar with the system. Let me know if you know it. -If it ain't broke, break it and make it better.

I had a user associate their LNK files with IE7. Now every application attempts to open in IE. Of course, that causes problems. I thought it would be as simple as unassociating, but I seem to be only able to associate to a different program and not able to remove the association all together...

I've got a system that needs to be backed up every 5 minutes. The vendor's database structure does not allow me to replicate. SQL Standard is installed so I cannot log ship and there is no upgrade path to SQL Enterprise. The vendor suggested I back up my LDF normally each night then back it...

My machine has been running fine for a couple of years. Recently it has started shutting off. Shutting down like some simply pulled the plug. I'll be chugging along and -bam- it powers off. I've kept a close watch on CPU temp to see if that might be causing it, but it appears to be 50-52C...