• Achieving merge replication with SQL Express 2005

    I wish to achieve merge replication with multiple publisher nodes replicating to a central distributor which merges the data and publishes back out. However, I only have access to SQL Express 2005 with only one license for the full edition. Is it possible to achieve this with what I currently have?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Re-linking database user

    Hi Guys, What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name. I am able to do this when I run the following command, and if the database user isn't the same as the login name. use temp alter user TestUser2 with name= TestUser2, login=...

    Db23290 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

    Hi, I'm a Computer Engineering at CSU Chico. I'm conducting a research paper on "Why IT Projects Fail". If someone could give me an example of a failed projects, "failed" meaning that it didn't get finished on time, or the final project did not meet the requierments. Also if you could give a quick...

    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:
  • Installing SP4 for SQL 2000 Error: 50042

    When I try to instal SP4 for SQL Server 200 with the Cyrillic Collation, the install crashes unexpectedly with no on screen errors. In the log it says "GetLastError returned: 50042" which I understand is related to the collation. Is there a way to fix this or perhaps a workaround?

    Ykhutch5 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:
  • SQL2000 linked to SQL2005 doesn’t allow TRAN selects

    Hi all, I have a SQL2000 machine that has a linked server that runs SQL2005 (before this was a SQL2000) When the systems were both SQL2000 from ServerA it was possible to run: BEGIN TRAN SELECT * FROM MYSVR.MYBD.DBO.MYTABLE COMMIT TRAN After the ServerB has been upgraded to SQl2005 the code above...

    alessandro.panzetta9,725 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:
  • Connection issue from analysis to reporting

    I have a report pulling the data from analysis services and reporting in SSRS reports. when i try to render the report I can view the report in the local server.when I try to access the same link remotely, I am unable to access the data and I am getting the below error. An error has occurred during...

    GIG240 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:
  • xp_cmdshell

    hai everybody.. while executing the following procedure.. exec master..xp_cmdshell 'dir c:*.*' iam getting the folders which existing in server..i.e. in which sql server is installed. but i need to access the informaiton of folders existing in client machine i.e. which i operate from another local...

    Manickam0 pointsBadges:
  • How to rectify the overflow error occured?

    Hi.. i appended 4 to 5 records, after that overflow error had occured while executing the sql query in vb.... Pl guide me how to solve this? Sree...

    Sreegans5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following