Search results for query: *

We have certifications for managers that consist of several classes. We have a DTS package that compares the Certcode for the manager and if they equal a particular code it inserts the appropriate classes needed to complete the certification. Once they have completed all the courses, the...

We have a canned program that recently went to SQL. They apparently did not do a good job of indexing everything before and it definately did not get any better. They even separated out the indexes in the database so we have Program.mdf (28 gb)Program_indexes.mdf (21 gb) and Program_log.ldf...

After installing SP2, I have been having problems using the SQL Server Management Studio = Job Activity Monitor. If I try to add a job or ran an existing job manually I receive the following error: Could not load type 'Microsoft.SqlServer.Management.SMO.Agent.JobBaseCollection' from Assembly...

I have a report that is using a table that contains classes taken by the employees and then a subreport in that report that uses a table that has certification that the employees have. On the subreport - I have the expiration date of the employee certifications. On the detail line I have a...

We are having problems with a Sharepoint database. When someone trys to upload anything bigger than 1 meg we get an error message in the event log Event ID 17052 Error 17803, Severity 20, State 12, Insufficient memory available. We have over 34 g left on the drive where the ldf file stored...

I have 3 tables that I would like to use to create a view. I may not be able to bring the third table in and that would be okay, but it would be nice to have all the information in a view for another department to use. I want all employees that are active from the second table. The first...

I am trying to run a dos command to populate a database in 2005. When I installed SQL2005 I took all the default prompts. I later changed the connections to Allow Remote Connections to this server. The command that I am supposed to run is sqlcmd -S .\%INSTANCENAME% -E -d %DBNAME% -i...

We are using version 8.5. Early last week I was able to export a report to text. On friday I was not able to export it - it shuts crystal down. Today I did a reinstall and it works fine on my computer, however, we also have it installed on a citrix server Windows 2003 Server and it is also...

I have a report that is grouped by Date and then by Location. In the database there is a field EndingGallons. In the report I need to get the Ending Gallons from the prior day. Since I am grouping by Date first and not location, when I try to pull in the previous({EndingGallons}) it does not...

We have Crystal XI and Crystal 85 installed in isolation environment on three citrix servers. We have a few different data sources, but the primary one used is Envoy. If I open one of the reports that use the Envoy ODBC on two of the servers it is fine. The third server opens the report...

We have a report that was created in 8.5 and we have the report ran through distribution. We have it installed on three citrix servers that have 8.5 installed on it. We are now installing on another citrix server and rather than having 8.5 installed, we have Crystal XI installed. (It also has...

I saw a a thread that mentioned:"In the Control Pannel you should see a "SQL Server 2000 Licensing Setup" icon. It's in there. " I do not see anything about Licensign Setup in the control panel (Windows 2003 Server). Is there something that I can run in Query Analizer?

We replaced the fuser on our Laserjet 1300 and since then it seems like it takes awhile for it to warm up and start printing. Also we usually print UPS labels and they have not been a problem, however, since the fuser has been replaced it leaves toner specks all over the print out. It seems...

We have an Interaction Client installed on our computers for our new phone system. This phone system has some crystal 9 reports. I have instructions that indicate if I want to modify these reports that I need to install their U2lininsupporta.dll into the %CommonProgramFiles%\Crystal...

I have a report that I used the distribution expert 8.5 to create an executable. When I open the executable and click on Export Option, I get an error Print Engine Error Error in File N:\Reports\timepunchscsv.rpt: Parameter has invalid structure size. I have even taken the parameters out of...

I have a table named CardPerspective and a table named Objective. I have the tables linked by a field called PerpectiveKey. When I enter data into the form Perspective_ObjectiveData it saves the data on the CardPerspective table. When I enter data into the form ObjectiveSubform, in the...

I have several reports that were created in 8.5 using the CR Oracle ODBC. When I try to run this report in 11 or create a new report, if I use the CR Oracle ODBC connection it comes back with an error message that we are not licensed for the Merant Oracle 8 driver. I would call the number...

We have someone wanting to create a database that will record what coupon numbers she has sent to a store. She will need to fill in the Store ID, Store Address, Date Sent and the numbers on the coupons that she sends to the store. They will always be sending in groups of 25 and the numbers will...

I have a report that I created in 8.5 that combines several fields together to create a field to be used with Active Directory. The end result is about 199 characters in length. If I export to Excel it exports the entire field, however, if I export to TXT it cuts off most of the field. I...

I have a report that has several tables joined The first table supplies a location, date, product the second table provides # units @ end of day - (only has this info if any were received or sold) the third table provides # unit sold the fourth provides # new units put into stock The report...