Search results for query: *

Does an end user have any recourse to prove if another person is accessing their email account? Are there audit trail settings that can be turned on through the Outlook client? I have a user who is positive her email account is being accessed by another person. (She 's finding specific...

A dept in my company just setup an ACT! server which uses MS SQL Server 2000 as the back-end. Unfortunately, it appears that ACT installs a hacked up version of SQL Server in that none of the GUI tools are installed on that server. We are not allowed to have the sa password either...

I have a SQL 7 server that references another linked SQL 7 server in SQL statements, that runs in a job once an hour. Job ran fine for awhile and suddenly started failing. When running the code manually I receive the following error: Server: Msg 7399, Level 16, State 1, Line 4 OLE DB provider...

I'm setting up two devices to handle the backup of my database: one for the database itself and one for it's transaction log. The database will be backed up once a day, and the device will be overwritten (INIT) so there is only one copy of the database at any given time within that device...

My company has just recently implemented the use of MS Project 2000 and MS Project Central. Once a project has been completed, is there anyway to eliminate it from view in Project Central's timesheet view? Thanks, WDFog

Hi, I'm currently using both MS Project and ProjectCentral as a timesheet tracking utility. All MS Projects are currently being stored via ODBC driver to a SQL Server database outside of the Project Central database. When updating one particular project, I receive an error that either the...

Is there anyway to read a transaction log? At this time, if I want to see sql commands issued during a procedure, I use the SQL Profiler tool. Was wondering if anyone knew of a method for reading the transaction log for sql events that have occurred. Thanks

Have written an ActiveX Document project on a Win98 machine and it does not run on a Win2000 machine, and vice versa. An activex document project created on the Win2000 machine does not run on the Win98 machine. Anyone have experience with this that would know what is going on here? Thanks...

I have a stored procedure that will be receiving parameters to build the WHERE clause of the SQL statement. I'm allowing users to select more than one item for each column so am having to use the IN clause. My statement looks like the following: EXEC (N'SELECT col1, col2 FROM Table1 WHERE...

I'm creating some reports in Crystal version 7 with SQL Server 7, and have found the running totals to be troublesome. (My data sources are stored procedures.) The simplest of requirements (sum everything) can leave out a number and cause an incorrect result. I read one of the FAQs posted...

Is there any method for exporting logins/users? I'm creating a copy of a database on a second server. All I have found is the option to export a list of users. I would like to maintain each user's password if I can rather than recreating the users manually on the new server. Thanks for the...

I have a database that I'd like to have a user administer for new users. However, I cannot set this one user up to be able to run the sp_adduser procedure without setting him up as a sys_admin or a dbo of that database. I thought of adding him to the dbo group and then denying many rights, but...

I have the same database on two different servers. The only difference between the two is the data in the tables. (One is production, one is development.) I have several reports that are based on stored procedures. Suddenly, after being in production for a week, the production reports return...