Search results for query: *

In MS SQL I used a program that would report on what tables, stored queries, etc. were being accessed when a window was opened. Is there something similar in DB2? I want to make a Crystal Report of a work order. I can open the work order on the screen, but have no associated report. I would...

I simply printed off a list of the mailbox sizes, and when the Exchange server went down, gave it to management. Then came the fixes and defragging, and when the users complained I just told them to see Joe, or Steve, or Bill, who had 5 gigs of happy birthday messages and stupid movies and...

Oh definitely. However, those sizes should be closer together than 4 = 95. The end result is a 4.5 GB physical file size, after some more maintenance. Significantly faster to backup 4.5 GB rather than 95. If I didn't have offline folders I wouldn't have had to visit each desktop either...

I ended calling MS, and we agreed on doing the Exmerge rebuild. Including visiting each machine to repair the Outlook settings it only took 3 hours. Much better and the EDB is now down to a manageable 9 GB. Thanks for the input.

I deleted my event logs this morning so that I could crank up the logging level on IS and monitor. Yeah, I don't know how 5 GB gets me 25 GB, of course I don't know how 5 GB got me 95 either! In any event I'm thinking Exmerge and recreation is the best move at this time. I'll have to look...

I'm thinking at this point, with only 5 GB of data, the best bet is to take the store offline and Exmerge to PSTs. Delete the store, create a new one, and import the PSTs. Good idea? Bad idea? It would probably take a hell of a lot less time, and the users are now getting cranky. (Although...

My deleted item retention time was 30 days. I turned it off two days ago as I wasn't sure if that was causing the problem. I deleted my log this morning, but it told me that I would have a 25 GB store after defragmentation, which would be in excess of the 18 GB limit. It told me that it would...

My SBS 2003 Server has an out of control priv1.edb. The file is 95 GB in size on disk, but when I view the mailboxes in administrator and add everything up there is only 5 GB of data. I attempted to perform an offline defrag, but ran out of time (9 hours) during the night. Mail becomes slow...

I'm having the same problem. Here's how I'm tackling it. I log in as myself (an account with lots of privileges). I setup a SQL trace to observe activity against the SQL server (from me only), then pause it. I get the Smartlist to the point just before I will activate the lookup, unpause the...

Shouldn't be a big problem, the ability to run SQL scripts is built into VB. You'll just need to make a database connection. I would just basically make a front end that runs a script with a button push, or if you desire something that automatically runs and exits using a schedule. (say AT)

Oh! Let me see if I understand you. You want a user to be able to say, run a VB app, that will update some back-end SQL data? I'd be careful when messing with GP data through a custom front end, but it's certainly something that can be done. I mostly use my VB apps to pull reports up that...

I wouldn't use VB, SQL stored procedures will likely do what you need to do. What I have done to figure out my triggers is this: Run a SQL trace, looking for a specific user. With you logged in as that user, get your GP to the point just before you want to trigger. Start the trace and begin...

Hmmm.... SY00800 doesn't really have anything in it if the user has no open windows. Removing the user from the ACTIVITY table doesn't allow them to log back in. There's got to be a way to do this, that doesn't require third party add-ons, and allows for user level control. If anyone has...

I'm thinking that I want this to be a manual process. I'm going to try and code in a "Logoff" option in the file menu that will put the user back at the login screen and delete their SY00800 entry. For security I'll set it so they can only log themselves out. I'll get back to you on what I...

I've got an issue with licenses and logons. I've got a limited budget and want to find a way to allow my users to partially back out of the system, so that they don't need to perform a complete load up of GP everytime they need access. I've got some users that are constant. (5) I've got some...

Exactly. I hate the multiple layers, but know deep in my heart, that protecting my system from the users is paramount. ;) At least this way I have one set of reports they *can't* touch, and that's the set in the GP dir of the accounting server. With users having only read rights to the...

I use something like this: I have a file on my GP server, in the GP dir, called Update_Reports.bat. Looks like this: copy *.vba reports /y copy forms.dic reports /y copy reports.dic reports /y copy wsrepts.dic reports /y Whenever I complete a new report I test them, then copy to this server...

Thanks! Some tables were updated, so hopefully nothing bad happened in the interim.

I found the problem, I used the "file or filegroups" restore option, as opposed to "device". Once I selected the file through the device options it immediately restored and worked correctly.

The restore *appeared* to have run, however the database has been saying "Loading" for the past hour and a half. Is this normal?