• query of query errors

    I have a runtime query of a query error as below. java.lang.String cannot be cast to java.util.Date But the output format is correct and is in date. This application was developed in coldfusion 6.1 and sqlserver2000. But now we get this error when it was migrated to coldfusion 8 and sql server...

    Vidukarth25 pointsBadges:
  • Error message when connecting SQL Server database to ASP.NET

    I’ve been getting the following message when connecting my SQL Server database to the ASP.NET application: "Login failed because, under default settings, SQL Server 2000 does not allow remote connections." What might this mean?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Unable to open a SQL application on two different machines

    If someone in our office opens a SQL application, no one else is able to open it. We all receive the message: “Another application is using this file.” How can we solve this problem?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Setting aside code for 12 databases in separate database on SQL Server

    I have 12 databases on my SQL Server, one for each month of the year, and I have almost all the same stored procedures in each database. This architecture is hard to maintain, because you have duplication of the code, and a modification must be made on all the databases. Is there a way to put all...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Making a query for a SQL Server database

    I would like to make a query for my SQL Server database to specify that only unmatching records should be displayed from both tables. Can you help me in doing so?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Create Stored Procedure based upon existing Stored Procedure

    How do I create a Stored Procedure based upon an existing stored Procedure in SQL Query Analyzer V 8.00.760

    Trainingit20 pointsBadges:
  • Is there a built-in stored procedure in SQL Server 2000 that returns the sql table structure of XML format

    i have a xml file.i want to insert the contents of the xml file into a table in sql server 2005.

    Mitha10 pointsBadges:
  • i want to send sap idoc to sql server 2005

    I have one application in sap which takes sap data into idoc and want to send in sql server 2005

    Vimalshah5 pointsBadges:
  • Windows 2003 server hangs after reboot

    Hi All, We have a Windows 2003 server ( Model: HP Proliant DL385 ) running SQL Server 2000, in which we always experience issues. The issue is that Windows Server 2003 hangs after every reboot. Sometimes, it has also bluescreened and has created a memory dump. First time, when it bluescreened, the...

    jeevan930 pointsBadges:
  • Saving Query results into Excel format

    How can I save query results into .xls format directly from Microsoft SQL server Management studio?

    Preetg5 pointsBadges:
  • Move data in SSIS via store procedure

    How do I set up an SSIS pkg to move results from a stored procedure from an external ss2005 db to the local ss2005db?

    Dreadoux5 pointsBadges:
  • Email notification in the event of a SQL Server database failover

    In case of a failover of a SQL Server database, I’d like to be notified by email. Can you tell me how to activate this option?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message during database mirroring on SQL Server 2005

    I am trying to begin database mirroring in SQL Server 2005. I have Service Pack 2 installed, and I have three instances running. When I attempt to start mirroring, I receive the error message, “One or more of the server network addresses lacks a fully qualified domain name.” My network...

    SQL Server Ask the Experts2,585 pointsBadges:
  • BCP and SQL2005 collation issues

    I get this error: Error = [Microsoft][SQL Native Client]Unable to resolve column level collations SQLState = 01000, NativeError = 5701 I am using the standar collation that comes with SQL2005

    Jmead5 pointsBadges:
  • Using MSDE 2000 Release A with my Custom VB 6.0 Application (PDW or Visual Installer 1.1)

    Hello IT Pro, Please can anyone give a thorough guideline on how to package my VB 6.0 Application with MSDE 2000 (Also including my Custom Database) so that my clients gets the CD and install without my being there for assistance Please help

    Aowl5 pointsBadges:
  • Union Query

    I 've a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a....

    Ipong40 pointsBadges:
  • PHP or HTML

    I need to create a database that allows a user to query info. on a project,name, proj number, contacts, contact #, etc. We are using SQL 2005. The office manager will enter info. about each project into an access form. Then, from the HTML page a user can f search by project name or number to list...

    Caddman35 pointsBadges:
  • Creating a website with a SQL Server database

    What programming tools can I use to create a website that will be hosted on a Windows-based platform with a SQL Server database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Access databases

    I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?

    Michaelrdowney10 pointsBadges:
  • Cobol Stored Procedures

    Can someone explain the flow of reentrant cobol stored procedures? Is it possible for two users to access and modify the same variable at the same time?

    Everett5 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