Search results for query: *

Is there anyway to run depreciation via a scheduled SQL job? Our depreication runs hours and hours and the users are frustrated waiting and wiating for it to end. It'd be great if we could just run it one night in the background. Rick

I have also come across another 3rd party tool for password strengthening: Ethotech - Enhanced Password Security Anyone have any experience with that?

Thanks Jaz. I have been looking into Omni Tools and have contacted our re-seller about pricing. I have also considered the dex.ini change which is free. However, it also adds more management to code deploys and the like. i have not yet seen a tool that will track invalid logins to GP, so...

Two questions, any insight would be great. We have GP 8.0 Remembering Last Userid When you log into Great Plains (on terminal server), the dex.ini file remembers the last person who logged in and populates the user name field with that user id. this is in direct violation of our SOX audits...

Hi, Our fixed asset system has created a monster table FA00902 and I was hoping to maybe purge out and archive some of the earlier transaction data in there. This data seems to be related to transactions involving adding/dep/retiring assets. Does anyone know the implications of removing some...

Bumping this post. Wondering if anyone else out there has had any more experience with running on VM? SQL server on VM and terminal server client on VM.

We also have 1GB ethernet too. Its funny you mention teh temp file, which means lots of disk I/O right? We are running our client machine on VMWare, so i imagine that will add some overhead. Whenever we have an issue, VM is always blamed by our consults...but nothing has proven a real issue...

Looking for suggestions on diving in on the workings of great plains. we recently upgrade a 6.0 version to 8.0 sp2, we also upgraded and moved the server from nt4 to win2003, double the amount of ram, double the processor speed (at least), but are getting performance on par with the old system...

No, you need to synchronize the users back to the master database on your server. SA is inherent to the server so it will always be ok. Example, you have a login with username "joesmith". joesmith either does exist in your destination server, or does not. if he does not, you need to add him...

I have only done Integrations from other databases, never tried a text file, outside of testing the Fixed Asset integration with 8.0. It seems pretty straightforward though. The ACCESS integration would probably give you more power because I imagine you could have more power over querying...

Thanks David. I agree, but unfortunately we use GP in sort of a strange and illogical way, and most of it is customzied. In fact, most of the processes are long running. Not responsible for its design, but I am now responsible for supporting it going forward. My question was more along the...

Thanks Poli, I will give it a try!

we use a custom integration that was built for us by a consulting firm back for version 6.0. It runs slow because integration manager actually goes through the same logic as adding data through the screens. is ACCESS located on the same server? i would think if you went right from ACCESS, it...

^bump

if you don't mind...i'd like to look at it for consideration. we have solved a slow down but it was an application specific issue, however, performance still seems to be lacking... thanks!

oh, and also wanted to mention... win2000 client to win2003 server odbc over tcp/ip anyone using named pipes? does it help?

was wondering what sort of overhead was added when running gp processes directly on the server versus running on a clinet installation on another machine? i can run a process that takes 1 minut 15 seconds on the server, but when i run it from the client it is closer to 3 minutes and 30 seconds...

we *think* we figured it out...just in case anyone is interested. the auto procedures for our custom tables were never dropped and recreated. this is apparently a step in the upgrade process. without the procedures, apparently dynamics and SQL are tyring to execute ad-hoc queries to read...

turned off activity tracking...didn't help the situation much... yes, we upgraded toward the high end recommendation (win 2003 server, dual xeon, 2GB of RAM). client is installed on win2000. we exepected to atleast match performance of the 6.0 GP system running on NT4! But we are not. Get...

aquila125, can you elaborate? I am seeing a similar issue with TCP DSN on Win2003. Did you create a user dsn for every user that connects to the SQL Server?