Search results for query: *

Hi – I’m wondering if it’s possible to run what might be called a “virtual” or a “software” phone with the NBX. Ideally I would like to use one headset for listening to music, for talking on the phone, and in a near future for commanding my Windows Vista operating system. It seems to make so...

Lately my SQL Server has been giving me these errors (Found in the Event Viewer under Application): --- 17310 : SqlDumpExceptionHandler: Process 3412 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. --- And right afterwards (within a second...

Hey all. I would ask you guys, but it seems I have a hundred questions ;) I'm looking for paid Windows 2003 Clustering advise. We're willing to pay on an hourly basis and probably only need a few hours consultation. I've tried Ingenio, but they don't really have anyone listed that knows...

Hey all. I have a list of URLs and need to get the domain (something.com, one.co.uk, etc.net) from that URL but am having a tricky time because there is an ever growing list of available extensions. It also complicates things having extensions with more then 1 dot like ".co.uk". It also...

Hi all. Every time I connect to my web host's SQL server I can connect and do everything quite quickly. However, when I initially open the "Databases" folder it takes upwards of an hour before all databases are displayed in EM. (Simply freezing EM while it downloads all this data.)...

Hey all. I'm trying to speed up a search I'm running with about 400,000 records. The full text catalog is about 140 MB in size and takes up to 4 or 5 seconds to process most searches. So I'm trying to put the full text catalog into a RamDrive called RamDiskNT by CenaTek to speed up the...

Hi all, I'm currently using Full Text Indexing for some moderate searches right now (around 50,000 records). I'm wondering if there are any good resources on the Internet or books I can buy that have loads of information on building an extremely robust search engine? I'm looking into this...

It is really annoying that the money and smallmoney datatypes store four decimal places. Is there an easy way to only have it store two decimal places? Currently I'm converting the datatype every time I use it because my applications only use and need two decimal places (like most everyday...

I have a field called 'rating' which is of the datatype Varchar. I am trying to sort it, but am having two problems. One is that when I "order by rating desc" I find that a rating of 1 or 10 is listed last because thats how it is alphabetially sorted. When there is not a rating I...

Just today I created a script that automatically backups all databases (including any new databases that might have recently been added.) I would be curious if anyone sees a problem with doing the following: Step 1: Get all devices from master..sysdevices that are backup devices (Status = 16)...

Hi, I have a view that takes about 4 seconds to run. However, I would like to only update the view once every 10 minutes so I can query off of that view and have the SQL query only take milliseconds instead of 4023 milliseconds. Is there a way to do this with a view? Or should I maybe be...

Is there no way to set up ODBC logging with the referrer field still? I know back with IIS 4.0 and SQL Server 7.0 you had no way of changing the log format with ODBC logging as you could so easily do with the extended logging options. If it is still the case, Microsoft has really screwed this...

I am in the process of co-branding part of my site, and it will not be hosted by me. So I would like to add a few lines of JavaScript to record all of the links that leave the co-branded site to anywhere else on the Internet. I'm thinking of using JavaScript to listen for a link to be clicked...

I'm getting into writing quite a few stored procedures from within Enterprise Manager. However, if I want to reference a table, I can not switch between views, tables and other stored procedures while a stored procedure is open. Is there a way around this? Or how do you guys write stored...

Sorry if this post seems simple, I'm a bit confused. I have a few books sitting here in front of me and I'm trying to learn how to administer MS SQL server. From what I can tell (unfortunately neither book explains it very well) if I want to create a new database and add a user to it I can do...

From what I can tell, Enabling Process Throttling does not have any effect on Cold Fusion pages, is this correct? The reason I have come to this conclusion is because I am the only one using a development server, and I check "enforce limits", but the processor jumps up to 50% on heavy...

Hi, I've been playing around and trying to learn SQL server a bit over the past 6 months or so. I'm curious: If I am going to be using a dedicated server as a SQL server for a few different web sites of moderate size, what is my best way to go? 1.) SQL 2000 Standard 2.) SQL 2000 Enterprise...

Hey all. I work from home and have told the guys I live with not to mess with my computer because every time they do, something goes wrong. Anyway, tonight a lot of stuff is acting wierd. These are simple things such as the fonts being a different size in Internet Explorer, icons on the...

I have searched high and low, and can't quite figure this out. Any help would be appreciated. I have X number of text boxes on a page. It is always changing, but I do have the total number stored in a hidden text box titled 'loops'. The text boxes are named in the fashion of: quant1 quant2...

Hello all. I had a copy of Windows go really corrupt to the point where it simply won't start. Safe mode, normal, nothing works. So I installed a second copy of Windows in hopes of being able to recover all my old files. I can access all programs and files that were placed throughout the...