Recent content by swhitten

SQLBill, Thanks for the suggestion. I started one this morning for the user who seems to be having the most errors, and of course she hasn't had any errors since I started it :( I am also running a DexSQLLog. I think I will just let both of them run for the next couple of work days and see if...

Can any one offer suggestions for anything else I can do from the Dynamics GP side or anything else I can point the network support team to? They are having no luck resolving this, the users are going crazy, and we are getting corrupt data in the database. THANKS!!!

Dynamics GP10 is running on SQL 2005 (9.00.4035.00 SP3). I am the support provider for Dynamics GP10, but they have another service provider for network/hardware. Several users get intermittent errors including: A SQL network connection error occurred and your connection was cleared. This...

Okay, this is getting me closer. Now I need to add other fields from IV30300 as well as additional created columns to my select statement. Not sure where to put these additional items in the new select statement. I need to add fields like: '12345' AS PartnerID, CONVERT(varchar, GETDATE()...

Thanks! I will test tomorrow.

I am writing a select statement to use in a view. The first column of data I need is retrieved with the first case statement below; I call that column TxnCode. Then I need to write data to a second column that depends on the TxnCode returned in the first column. The script below tells me...

I have a report parameter that allows the user to select which customer to report on. I linked it to the customer list in my database. The user would like to be able to see both the customer ID AND the customer name when selecting which customer to report. I can put the customer ID field in...

Crystal XI. SQL 2005. I am trying to write a new report off a SQL Stored Procedure. Wen I try to add the data to the report, it prompts me for all the various paramters for the stored proc. I click "set as null" for each, then click ok. Then I get this error: Database Connector Error...

Thanks. I am working on cleaning up my views; I think that's where the real slow down is occurring.

I have a view that returns approximately 5 million rows and is growing at the rate of several thousand rows per month. I'm using a reporting tool that crashes when I try to report off the view. I tested writing the view to a table and reporting off the table, and the reporting tool works fine...

Thanks. We had two dbs with issues. For one, we were able to finally get it resolved by rebuilding some indexes and some other things. For the second one, we ended up having to make a new db, run sql queries on the old db to export the data out to a file, then DTS the data into the new db...

We ran the advisor, and it found some torn pages. We went back to the original dbs and ran maintenance there - major issues. Trying to work on resolving them now. So in short, I think we have a data integrity issue with the original data/back ups rather than a restore issue. Thanks for the...

I have determined the difference between the two reports. Report 1, which works correctly and shows me my custom group name for the Group X Axis Labels, has only one set of data. On the data tab of the Chart Expert, I go to Group, and I see "on change of @value show sum of @sales. When i go...

In Group Expert - Options - Options, I selected Customize Group Name Field, and I have a formula as Group Name. The custom group name shows on the report as the label for the group. But when I create a chart, the actual group value is showing up as the X Axis label instead of the Group Name...

We are attemping to migrate a customer to a new server with SQL 2005 SP3. They are currently on SQL 2000 SP3. They have 11 dbs. We made SQL 2000 backups of all dbs. Then we successfully restored the dynamics db and 9 of the 11 dbs to the SQL 2005 server. Using Management Studio, we right...