Search results for query: *

We currently have a web application that takes in data via a form, passes it to a Crystal Reports report (x.rpt) and then that passes the data to the database into a stored procedure, which returns a dataset, the report acts on that, and then it is displayed in a Crystal Viewer object. In that...

We have a Windows 2003 server with shared folders on it. Users on the network get mapped to those folders on login, and their access performance is fine in regards to those folders. But when I come in via our Citrix VPN, it can take upwards of 5 minutes to click on a folder and have its...

I am using ASP.NET (VB) and have PageA with some input fields. I want to submit that page and have it spawn a new window with PageB (the reports), passing those parameters to that window, and have it run the report. The logistics are in place, but the spawned window continues to ask for the...

We have a database app that users login to and they authenticate via SQL authentication. So in the SQL Server (2000) database, there are the actual SQL users and the passwords are managed by the server. (not a separate table that we query, but an actual SQL Server user) I am now building a...

Is there a way that I can query all of the stored procedures and functions for LIKE '%ABC%' where "ABC" in this case is a unique string that all of our key procedures and functions have in their name - and then modify their permissions? I am currently having to go through manually when we have...

We have an ssl cert issued from a second tier group - not Verisign. They are supposed in the Windows updates and they have a root install program at http://www.quovadis.bm/root/ but when we run it, we see the same issues as before running it. If we use the Windows client installed on a machine...

When I right click on a stored procedure in Query Analyzer and select "Debug", I can enter the data and then it runs - but all of the documentation that I find on it says that it should stop at the first executable line and then wait for instructions from me (step into, step over, etc). But...

We have a Windows 2003 server that regularly loses its network connection. It was at first happening once a week, but now it is happening every night, so whatever the issue is, it is escalating. The event log mentions that the server thinks another machine either has its netbios name, or its...

We have a Windows 2003 server that regularly loses its network connection. It was at first happening once a week, but now it is happening every night, so whatever the issue is, it is escalating. The event log mentions that the server thinks another machine either has its netbios name, or its...

I am not an MCDBA, so there are likely many things that I do that are not technically correct, but work well enough to get the job done. I am a developer on a database project without a proper DBA position, so I get to play that role. The following happened, and I suppose it is a sign that my...

We have a user who has remarried, so her last name is now different. In the system we use user names of FirstInitialLastName, so "Bob Smith" would then be "bsmith". So in this case, we might want to change it to "Bob Jones" and change the login to "bjones". So I went in and changed her email...

We have Exchange 2003 Standard and when I went to installed SP2 on it today, it gave me the error "An error occurred while copying file setupmcl.exe. Cannot copy file to destination directory." I then continued the install and it failed, saying that there was an Access Denied error on the Win32...

We have an MS Access program that runs reports out of our database. It has the ability to write out to PDF. On every machine in the office except one user's machine, when you create the PDF from in the Access application, it works. It creates a file and in this case it attaches it to an email...

We have multiple users with mailboxes over 1GB and one over 2GB with 20K messages. I setup his Outlook to archive all of the messages over 12 months old out to a pst file with permissions only for him and the admin user on the network (so that it can still get backed up and be loaded if need...

We had an HD crash over the weekend and had to restore the info store from our backups. After which, everything internally worked great. But ever since then, the OWA and ActiveSync haven't been working. OWA originally was showing a "440" error with a timeout. We called in someone from our IT...

This is one of the more complicated and bizarre issues I have seen, so I am hoping one of you can help me out on this one. We have 3 users (UserA, UserB, UserC) who access a shared account, this account is used when sending out email to specific clients. Each of them has full permissions for...

I haven't seen this one before: 1) UserA (with Outlook 2003) gets an email that is sent to some people in our office, and also some from a client of ours 2) UserA presses "Reply to All" and everyone shows up in the message. The people in our office (and oviously therefore in our...

We recently had an issue where all power for our area (we are on an island, and the entire island was without power) was down. We needed to call each of our clients and let them know that we would be down for several days and not to panic (the nature of our business is that which could easily...

I have never seen this one before. I have a shortcut on my desktop which points to an EXE on a remote server. That server recently went to server heaven with a faulty motherboard, so it is no longer a valid shortcut. If I right-click on the shortcut (on my machine's desktop), it gives me an...

I am trying to move from a stored procedure which returns a single row and is called many times from the client side, to instead take the data from the client and perform all of the work server-side instead. To call the stored procedure many times from the client, getting one row back, for our...