• 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:
  • 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:
  • 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:
  • Just In Time Debugging

    Just to ask what really the cause of this kind of error "just in time debugging" Im using visual basic 6 and SQL Server 7, and im developing a biometrics program that this error is frequent to occur...may everyone share there ideas with regards on this matter, really need help. Thanks in advance.

    Jdcruz10 pointsBadges:
  • Index Tuning Wizard shows error occurred while executing SQL statement but I can’t find the problem

    I am facing a strange problem while using the Index Tuning Wizard (ITW) in SQL Server 2000. It shows error occurred while executing a SQL statement. I've checked every thing like trace is okay, as they show no problem with SQL Server 2005. Kindly give me some solution, URGENT.

    SQL Server Ask the Experts2,585 pointsBadges:
  • retrieving data from SQL express

    i have sql 200 and express 2005 runing on one machine and all is working but for some reason i cannot retrieve data anymore hence it says the data is being used by another instance.

    TonyM5 pointsBadges:
  • Deploying 2000 reporting services reports on 2005 reporting services

    Hi ! I have a large number of reports created in visual studio 2003 .They were originally deployed on SQl server reporting services 2000. Now durinfg the process of upgradation to 2005 , i transferred all the reports from 2000 server to 2005 server using RSscripter which worked fine.However , my...

    Atom1235 pointsBadges:
  • Advice needed to reinstall SQL 2005

    I'm fairly new to administrering SQL 2005. I need to reinstall SQL Server 2005 due to a few problems I've been having with dll's not being registered. We also run the reporting services. I just need to know what impact uninstalling and reinstalling SQL will have on the current DB's and reports and...

    Catloftus5 pointsBadges:
  • SSIS package failure message

    I am running SQL Server 2005 and my package fails with the following error: OnError MyServer\serverAD My_Object{F63BA2F3-E28F-4142-98D8-0E631F8D0D3A} {31AB7571-ECB2-4591-BFE1-CC8D59739230} Data conversion failed while converting column "Some_Column" (5017) to column "Copy of Some_Column" (6373)....

    MarkFyffe5 pointsBadges:
  • Using SQL CLI APIs to call an sql stored procedure on an AS400

    I would like to know if there any examples of using the SQL CLI APIs in a COBOL/400 program that may help me in using the APIs to call a stored procedure and process the result set(s) . Thanks Mike

    I5DB2DBA5 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