Search results for query: *

Thanks for you reply John, Yes, this is something we can consider at the HO, but on the outlet where only an MSDE is installed, we might have to use the same server, but create a new database. Also, I am mainly looking for advice on some industry standards / white papers so that we can do a...

Hi, We are planning to develop a data archiving / warehousing solution for our product and looking for some white papers / industry standards that we can refer to rather than re-inventing the wheel To give you some back ground info., we have a Head Office -> Multiple outlets kind of a system...

Sorry, I should have it more clear. I am not talking about CAL's at all. I am talking about the SQL Server itself. We install MSDE 2000 on all our client machines by default and standard version on machine which need bigger than 2 GB databases (some usually go upto 100's of GBs) I have been...

Hi Our company has just been informed that we can not buy SQL Server 2000 licenses any more and will have to buy SQL Server 2005 instead. The issue is that our applications have not been tested with SQL Server 2005 and we do not want to ship our application with this version until we have...

Thanks a lot for that. Iefix tool seems to have fixed it. Thanks Again K.

Hi I have an issue with the Internet Explorer where if I try and open a link in a new window, it opens a new window but doesn't actually display anything in the window. But, if click on "Stop" in this new window, it displays the address in the address bar. If I then click "Refresh", it...

well, this article assumes the database is already attached to the SQL Server And, we are already running SP3 K.

you can try using the first option in Query Analyser

Yes, follow these steps: - From the SQL Server group, choose the SQL server you want to attach the database to (i.e. if you have more than one SQL Servers) - Right click on 'Databases' and choose All tasks -> Attach Database - Specify the location of .MDF file, and it will automatically pick...

I get this error while attaching database to the SQL Server: "Error 9003: The LSN (11772:1180:1) passed to log scan in database '<dbname>' is invalid." If it helps in any way. the title of the message box window displays this text: "Microsoft SQL-DMO (ODBC SQLState: HY000) Can any help...

- Write an sql script (.sql file), say attachdb.sql, with these commands: ------ Use Master sp_attach_db <your db name>, '<path to .mdf file>', '<path to your .ldf file>' ------ E.g. sp_attach_db Northwind, 'c:\temp\Northwind.mdf', 'c:\temp\Nortwind.ldf' - Now on Dos Prompt use this osql...

yes..the mother board auto detects when there is only one chip installed ot two. When using the single 512 MB stick it runs in the single side mode. I have tried installing two 128MB chips so that it operates in Dual chanel technology, and it recognises that properly, but still no luck..system...

Have also tried 400W PSU without any luck. Tried another HDD to eliminate that possibility as well. When i try installing W2K server using boot disk, it comes up with this same error plus this info: UNEXPECTED_KERNEL_MODE_TRAP K.

checked with Sisoft Sandra and it did not find any problem. The only thing it reported was that CPU speed is 800 Mhz while RAM speed is 400 MHZ so it would be a good idea to get a faster speen RAM and that CPU might be starving!!?? Does look like a heat problem because I am running motherboard...

Hi, We have a Head Office and Site sort of a system where our application runs on both HO and site and polls the data from sites every night. HO is generally Windows 2000 server or Windows 2003 server and sites on Windows 2000 professional. Number of sites could even go upto a 1000 in some...

Not sure about your code, but for detaching a database you need to be using Master database at that time. If any process is currently using the database you are using to detach, it wouldn't let you detach it just by using sp_detach_db. In the Enterprise Manager there is an option where it...

Well I have bought a 400w PSU but it still crashes. I have also tried it running it with just the hard disk, graphic card ,and memory...but no success. Would a Hard drive corruption cause this?...but the funny thing is that the chkdsk does show any issues with the hard disk either. K.

Are there any known issues with P4 prescott running with 300W power supply? I am experiencing a problem where my PC boots up (almost like a PC reset) without any warning..page fault etc. and it is totally random. Have tried checking memory, flashed Bios etc. Could Power supply be the cause...

Hmmm... I have run a diagnostic tool on RAM (memtest) and its all OK.. have tried upgrading BIOS and graphic accelerator card drivers. Have also even tried running motherboard monitor ..there are no issues with temperature control. The only other thing I can think of are: - I have got 300W...

I am having a similar issue. In my case its happening more frequently i.e. every 20 - 25 minutes. While working on anything is just restarts the computer. Have checked the heat monitor by runnning the comp all night on the BOIS Setup screen that displays the temperature. It does not go higher...