We want to keep track of all transactions going through our database server as we are administering a database server using SQL Server 2005. Can you suggest of a program, software or application that can keep track of those transactions? We plan to create a .net application to gather all the information (select, update, create, insert) contained in our database and its objects as well as the users that trigger these actions.

My company has 50 employees working away from the office. They synchronize with our database daily and we have had no problems until two days ago. Now, whenever they synchronize, this error message appears in the record log:

ERROR : [-10052] The authenticate_user script returned 4000. I reviewed previous records and learned that it should “return 1000.” I am not sure what to do as I started work here only two days ago when the problem started. The employee I replaced left two days ago. Please advise me what to do and what is causing this error to appear. Thank you.

A link was created between MySQL and MSSQL wherein we can replicate the database from MySQL once (the first time) but subsequently receive this error message: Executed as user: NT AUTHORITYNETWORK SERVICE. An object, “access right” can already be found in the database.

Executing it gets this error: [SQLSTATE 42S01] (Error 2714). Can you tell me how we can let MSSQL to write over the existing tables? Thank you.

I am having a web browser related problem i.e. when I use my pre’s internet browser, it loads pages at the bottom of the said page and I have to scroll twice to reach the top of the page. How would I correct this trouble?

Hello! As we are working on a project, we are experiencing some difficulties working on mdf database. We used Visual Studio 2008 Pro Edition in building our website that is created by C# Programming.

We made a database through Server ExplorerData connectionsCreate New SQL Server Database and insert localhostSQLEXPRESS and named the database as Event_Companio_Database. And then I moved the database mdf and ldf file from the primary location to App_Data folder.

But I could not rebuild connection with this error

Microsoft Visual Studio

Cannot open database “Event_Companion_Database” requested by the login. The login failed. Login failed for the user ‘Compal_FrancisInferno FS’.

Help me on this please.

How can an Excel spreadsheet be converted to an Access database? Also, how can an Access form be converted to a spreadsheet through the form as front for data capture? Can several users be linked to a database to allow data to flow into the database?

How do you hide system tables from programs like MS Access? Everytime I link tables in our SQL database, other system views are included in the list and I cannot find which tables I need asap.

How do you specify a range for a report from SQL Server Report Services to be exported to MS Excel? The range should have a name and refers to some cells with certain columns for the rows that are rendered for table control.

Is there a way to export 400k rows in MS Access ’07 to Excel?

I want the row restriction of 65k to change to 1M in Access.