Search results for query: *

What's the keypress sequence to get into CMOS set up mode? I need to change the disk boot sequence, but can't get into CMOS Many thanks!

I have a DTS which is scheduled to run at midnight each night. It is simply a T-SQL query which refreshes the contents of a transaction table with that days new transactions. However, there are occasions where I would like to run this DTS or the T-SQL query ad-hoc. I would like to provide this...

I am running IIS on Windows NT 4 Server. I have a copy of Crystal Reports 8 installed on the same server. I have an HTML page which links to a Crystal Report. The Crystal report is linked to an SQL server 'view'. I load up Internet Explorer and connect to the web page, click on the link and the...

I have Crystal 8 reports which are hosted on a web server, and are run via the Crystal Reports viewer. These reports connect to a SQL server database. When a report is first run, it requests the logon details to connect to SQL server. This isn't too bad for a simple report, as the login is only...

I have a Crystal 8 report which connects to a SQL Server 7 stored procedure. It works fine when I run it from my own desktop, but when I place it on our intranet, where it is run via Internet Explorer / Crystal Report viewer DLL, it returns an error; "Error detected by Database DLL&quot...

I have a Windows NT 4 server, with IIS installed. I have created a simple HTML page, with a link to a Crystal 8.5 .rpt file. With Crystal Enterprise installed on the server, the report will open in a Crystal Report Viewer through Internet explorer,(prompting for download of the viewer for first...

I have a Windows NT 4 server, with IIS installed. I have created a simple HTML page, with a link to a Crystal 8.5 .rpt file. With Crystal Enterprise installed on the server, the report will open in a Crystal Report Viewer through Internet explorer,(prompting for download of the viewer for first...

Does anyone know what impact MS Messenger will be having on my company's network bandwidth? Should I be preventing people from using it?

Can someone tell me, in simple terms, what is the difference between SQL Server Enterprise and SQL Server Standard?

Hi. I use SQL authentication on my SQL Server installation, and I need to distribute a Crystal Report to multiple users. I don't want them to have to enter the SQL user id and password each time they run the report. Is there any way I can store the user id and password somewhere either in the...

My company employs MS Exchange 5.5 on Windows NT4 Servers throughout it's 200+ sites. A public folder has been created on a central server, and is being replicated to all other sites. We have discovered that some employees can't see the contents of this folder. It seems that the pattern...

Is it possible to build a condition into an SQL where statement to perform a different selection dependant on the value of a selection parameter? e.g. Selection Parameter = JobNo Value can be either a job number or 'ALL' If I enter a job number, then my 'WHERE' statement must only select values...

Hi. I have a table containing project numbers which are numbered as follows 1000N 1000S 1000T 1000X through to 9999N 9999S 9999T 9999X The suffix letter indicates a department of the company. We have changed our reporting requirements to dispense with individual departments, and instead to...

Hi. I have a spreadsheet that staff are using as a Time Sheet. I also have an MS Access based time sheet application which has a table containing Activity codes. I want to create a combo box on my Excel time sheet which is populated by the Access data. Can someone tell me if this is...

I wonder if any of you have come across the problem of getting forms into a particular position on the screen. I am working on an application at the moment where it is important that each form opens in the same position on the screen. I turn off automatic centering and automatic resize. I...

I have Crystal Reports 8.5, and have developed a number of reports which would be useful to other users in my company. However, I don't want to have to purchase a Crystal licence for each user if I can help it - Is there any such thing as a 'report viewer' tool that these users could use to run...

Hi. I have a client database that has been input into by a few different people. Some have used upper case, some lower. I want to run an SQL script to change everything to Title case - i.e. JOE BLOGGS to become Joe Bloggs I have a script that will do this for a pre-defined value of a variable...

Help! I have a large number of tables where I want to copy the data from one database to another of the same structure, overwriting the existing data. I don't want to use the DTS wizard, as this will mean selecting each table in the list and changing the transform properties to delete data...

I have a corrupt database, but I am able to read the data in every table except one (670 tables) My most recent good backup is on a tape stored off-site and will take some time to collect. I am thinking that it may be quicker to create a new database, and copy in all of the good tables from the...

I am having a problem with a database on SQL 7. When I run DBCC CHECKDB ('dbname') I get the following results. Is there any way I can recover this database without having to restore from backup? Server: Msg 8966, Level 16, State 5, Line 2 Could not read and latch page (1:380136) with latch...