Thank you VERY much Corran007!! You have saved me from adding more disks to my server - I found a table which was eating LOTS of disk space, and it turned out to be redundant, so I deleted it and have freed up loads of space!
Mike
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"...
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...
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...
All of the columns except one are the same.
The one that may be different is the project manager assigned to the project.
However, we are taking the view that once we are left with only 1 occurrence of each project, these will be printed out for checking by each project manager, and any errors...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.