Search results for query: *

Yep, I guess that was their way of asking that question. It kind of caught me off guard but I called back and gave them a firm no and now they are actually troubleshooting my original problem. Thanks for the help.

Good question. I'm thinking they're referring to manually created triggers or procedures that aren't compatible with their latest version but we haven't created any.

Hello, Our software manufacturer wants us to check for invalid triggers and procedures against our SQL Server 2000 database. Can someone please school me on how this is done? Thank you. -Jeremy

It looks like that solved the problem. Thanks again!

LOL, thanks guys. I'll disable cached mode and monitor. Regards, Jeremy M. Mgr., Supply Chain and MFG Systems

Hello, I have a user on Outlook 2003 that's having some sync issues. Every day from about 1pm to 4pm her Outlook synchronizes off and on enough to bog down her computer when it's running. Nothing in her settings have changed and Outlook is running in cached mode. Does anybody have an idea to...

Thank you for the help. It turns out our IP address for our Citrix server was tied in with our domain. Once I redirected the DNS away from our ISP, the IP address was cut off. Regards, Jeremy M. Mgr., Supply Chain and MFG Systems

Thank you for the help. It turns out our IP addresses for our servers are tied in with our domain. Once I redirected the DNS away from our ISP, those IP addresses were cut off. Regards, Jeremy M. Mgr., Supply Chain and MFG Systems

Hello, we are in the middle of switching over hosting to the people who did our new website. I switched the DNS to point to their server and they updated our MX record which points to Message Labs, a company that checks our mail for virus and spam. Message Labs point their mail server to our...

Hello, We will be changing our DNS address for both our website and mail this weekend. Last time we tried this we had problems pushing the change through and had to revert back to the original DNS address. During the time our registar servers were pushing the address through, dialing in through...

Nevermind, turns out to be an external problem with our ISP. They didn't notice it for two days until I did a complete reboot of the entire system. The only reason they found it was because an alarm went off since I shut down the fire wall. The alarm on my Adtran TSU 120 still hasn't shut off...

Hello everyone, I'm having major problems here and I don't even know where to begin. First all my users are having problems accessing the server through OWA. I just found out they can't connect through Citrix either. Our network is being bogged and all I could find was a bunch of mail stuck in...

Thank you, worked like a charm! Regards, Jeremy M. Systems Administrator Disclaimer:This person recently stepped in a pile of $#!^ and inherited a sys. admin. position. Although he has a limited knowledge base in some areas, he promises to do as much research as possible before posting...

Hello, I have a subreport in my main report that I would like totals from and I don't have the slightest clue how to do this. The subreport brings in three fields into my detail line. I'd like totals for each group including a grand total for the report. My report looks like this in the...

Thanks lander215. That's what I was looking for. Regards, Jeremy M. Systems Administrator Disclaimer:This person recently stepped in a pile of $#!^ and inherited a sys. admin. position. Although he has a limited knowledge base in some areas, he promises to do as much research as possible...

Hello, I can't seem to get past this one. Is there a way to show a list of expired accounts or a utility that will delete them? Thank-you. Regards, Jeremy M. Systems Administrator Disclaimer:This person recently stepped in a pile of $#!^ and inherited a sys. admin. position. Although he has...

Worked like a charm. Thanks! Regards, Jeremy M. Systems Administrator Disclaimer:This person recently stepped in a pile of $#!^ and inherited a sys. admin. position. Although he has a limited knowledge base in some areas, he promises to do as much research as possible before posting. Please...

Thanks for your help lbass. I originally had the po lines table linked to the po, so I even tried reversing the tables and used a left join and I still have the same issue. I'm wondering if has to do with how I'm manipulating the time and date field. I'll have play around a little bit more, when...

Maybe I do have a linking issue, seems no matter what I try to insert into that field, it will only pull in the purc_order_line.promise_date. Regards, Jeremy M. Systems Administrator Disclaimer:This person recently stepped in a pile of $#!^ and inherited a sys. admin. position. Although he...

Yes, I've even created a smaller version with just those two tables. There's only one difference between my sales and purchase reports. On the sales report, either the line or order date was always entered. On the purchase report both of the fields on some orders are blank. Do I have to take...