• Error using SQL Server reports in a web application

    I have used SQL Server reports in my web application, and I can see it on the same server but we are getting a "Server Not Found" error on my user's machine.

    SQL Server Ask the Experts2,585 pointsBadges:
  • HTTP 505 calling SQL Server Web service from SAP PI 7.1 SOAP Adapter

    Hi, I have a SAP PI 71. scenario where I need to call a Web Service exposed by an SQL Server 2005 app running on widows 2003. The SOAP adapter call fails with an HTTP 505 indicating mismatched HTTP versions. it appear that sap is speaking 1.0 and sql server is speaking 1.1. Do you know of any way...

    Ziglmorf5 pointsBadges:
  • Video hosting

    I am including a video howto section to my business website. I have minimal experience in php and sql but have already created a SQL database for the information. I want this to be both dynamic and directable through the title of the video. can someone please give me direction.

    Tripodcomputerservices20 pointsBadges:
  • SQL Storage Server

    I am uploading in an SQL Server with a maximum of 1250 check images per batch with a minimum of 45KB file size (back and front) with indexes using a thrid party application. The images are temporary stored on a directory watch (7 folders) before running the import application. There are instances...

    Wackojo50 pointsBadges:
  • Sybase to SQL Server via linkserver

    I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 12.5.0.2 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67 The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table I get ONLY ONE ROW without any...

    Seat15 pointsBadges:
  • SQL Server Linked Server Security Context

    Hey everyone, I'm working on some scripts that will run on a monitoring server and connect to several data servers to return information such as job status, etc. We also use linked servers for replication, etc. We use mixed authentication, however, I would like to change our linked servers to use...

    Lvance16115 pointsBadges:
  • Using Microsoft Access to create reports from MACOLA

    Where can I get instructions on using Microsoft Access to create reports from Macola?

    SQL Server Ask the Experts2,585 pointsBadges:
  • CRViewer Logon Failed error within Visual Basic 6

    I developed and tested a VB6 program that runs CR Viewer accessing with RDC Crystal Reports 11 reports from a folder on a remote server and uses data and queries from SQL2000 on the same server. All operating systems use MS XP. My problem is that the program works on my desktop and a few others,...

    Lamm10 pointsBadges:
  • SQL Server backup would not terminate

    I tried to stop the backup which was already fired through job schedule,but it did't stop. Then I stop the sql serveragent but it also not abled to stop the backup. The backup size was 100GB. Could you please give me the reason and solution of it.

    Axis5 pointsBadges:
  • Monitor SQL Server 2000 Analysis Services Cubes

    I am working in a BI role and have some ancient AS2000 cubes that are used across the organisation. Only trouble is no-one is exactly sure who uses them daily. How can i monitor which cubes are being accessed by whom? Doesnt seem that profiler picks up AS transactions so im kinda stuck how to do...

    Bright1235 pointsBadges:
  • SQL Server 2008 extended stored procedures

    I have created several extended stored procedures in SQL 2008 which when i run always return a NULL. I call these XP's from within a stored procedure. They work fine in SQL 2005 and SQL 2000. One thing i have noticed is when i click on the properties of the xp the path to the DLL is not there is...

    KH155 pointsBadges:
  • Deleting in a complicated data structure on SQL Server 2000

    I have a complicated data structure on SQL Server 2000 which, at times can go four levels deep. It is all designed using foreign keys, as expected. I am having difficulty getting deletion to work from the top level, which is an orders table. Some child tables have cascade deletes on, and some are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 – Analysis Services can’t Right click and create new Data Source

    In SQL Server 2005, under the analysis server, we cannot right click on Data Sources and choose "new Data source". Only Reports and Refresh are available.

    Swish19765 pointsBadges:
  • How to use Store Procedure for multiple column database update?

    I created a store procedure to update a table based on values from another table using inner join. 15 records need to be updated but when the store procedure is executed no rows are updated bu the return value is 0.

    KjitSingh5 pointsBadges:
  • How to run SQL script with parameters in CL

    I have to call an sql script with parameters from an existing cl program that runs daily (in batch). If I call it from the cl program, it is giving me this error "Pointer not set for referenced location referenced".

    Ara5 pointsBadges:
  • Backing up virtual SQL servers

    The following question was recently submitted by a user via e-mail: I’m using ArcServe to back up our virtual machines, and I’m wondering what other tools people are using to back up their virtual SQL servers?

    ITKE364,120 pointsBadges:
  • IBM System x3400 connectivity

    We have brought IBM server x3400(7975PAT) which is running on windows server 2003 with SQL sewrver 2005 which is connected to 15 kiosks. I want to connect it to the one more server 2003 installed system to transfer data from the ibm server. How to connect ?

    Ppaul5 pointsBadges:
  • Error while referencing external assembly in SQL Server 2005.

    Sir, I created a dll (SqlWcfServiceLibrary1.dll) using .net frammework 2008. My code has a reference of another assemble (WcfServiceLibrary1.dll) also. I want to create assemble in sql and use that assemble in a procedure. I am getting error that "Error while referencing external assembly". I am...

    Batsa15 pointsBadges:
  • Database Migration

    Hi Friends, Any one can explain how to do the Sql Server database migration from version to version with screen shots i am new to Sql Server Thanks in Advance Thanks grace

    MSQL5 pointsBadges:
  • Large DB, low capacity line, resync log-shipping options.

    Hello, We've a large SQL2000 DB which is 335GBs in size and a majority of tables are geographically replicated to a subscriber using transactional replication across a 10Mbit line. We're going through the process of converting the DBs' environment to SQL 2005. Unforetunately I think this means...

    SuperCoolMoss140 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