• 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:
  • Linking to a table in SQL with Visual Basic

    How could I link to a table in SQL using Visual Basic?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Re-applying column constraints

    I have a 100+ db that was hacked. The column level constraints/defaults were removed. I'd like to know how I can reapply the constraints/defaults while keeping the data intact. I do have an identical database with no data in it.

    Kcook5 pointsBadges:
  • ERP form error message on a SQL database

    We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrieving values from a table in SQL

    I have values stored in a table in SQL this order: -99.4%, 99.5%, -99.6%, -99.7%, 99.8%, 99.9% I'd like to retrieve them in this order: -99.4%, -99.6%, -99.7%, 99.5%, 99.8%, 99.9% The ORDER BY clause does not do so. Is there another clause I could use?

    SQL Server Ask the Experts2,585 pointsBadges:
  • T-SQL Query- how to explode XML fragment stored as NText into table?

    I'm using a commercial storefront software that offers "extension data" fields as NText to store custom data. I am storing an xml fragment that looks like this: <priceSplit xmlns="http://tempuri.org/priceSplit.xsd"> <split> <type>Credit Processing Fee</type>...

    Lambrite5 pointsBadges:
  • Concatenate

    I have a value in a column that I need combined on 1 line. I need a new row when the Id in the table changes. For example Column A Column B 1 Boyd 1 Honaker 2 Steel I need the row to be 1 Boyd, Honaker 2 Steel I can get the name column to concatenate but I get one large line. I can't figure out the...

    Musiclover5 pointsBadges:
  • SQL server – Management Studio tool

    Hi, Thanks for your help, But on SQL Server (SQLEXPRESS) it prompts for only account name and password but no IP so I still can login to my clients server to access thier database. Please how do it. Thanks Chuk

    Chukbillo20 pointsBadges:
  • SQL sever

    Hi, Thanks Flame. I followed the steps in the link you gave. I got to where it prompted for id and password and click next after that but it gives error message as below. Connection failed SQLState: '01000' SQL ServerError: 14 [Microsoft][ODSC SQL Server Driver][DBNETLIB]ConnectionOpen...

    Chukbillo20 pointsBadges:
  • SQL Server

    Hi, Thanks Mr Denny. but when i go to start - programmes - MS SQL server 2005 - configure tools - SQL Server configure manager' I do not see or know where to open a Connect To Server window or where to click on the File drop down menu, and select "Connect Object Explorer". Kindly give give a...

    Chukbillo20 pointsBadges:
  • Connecting sql server 2000 to 2 databases simultaneously

    I have to create a report to move inventory from an old warehouse to a new one. Each has a separate instance of the database, so I have to get the part# and location from the old warehouse and match it with the new location for that part# in the new warehouse. Is there a way to join tables from...

    CO Bill120 pointsBadges:
  • Is SQL Server Upgrade Advisor worth using?

    We are undertaking a technical study/risk evaluation as to whether to upgrade a substantial SQL Server database from 2000 to 2005. Is the Upgrade Advisor tool of significant benefit it assisting us with the risk evaluation? Nobody in our company has used this tool as yet, so any advice will be...

    ChrisThompson5 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