• Passing an array into a Stored Procedure

    is there a possibility of passing an array into a Stored procedure i am using java and sqlserver 2000

    Khperi5 pointsBadges:
  • Notes rich text field to BLOB/Memo field in SQL Server using ADOdb

    I have an agent that uses ADODB to connect and insert a row into a SQL Server database. I want to store the contents of the Body field in the memo (rich text) into a Memo field in the SQL Server database (or Blob field). I'm finding examples of reading this kind of data back into a Notes...

    tjarman90 pointsBadges:
  • AS/400 to SQL Server 2008

    Hi, Is there a way to pull an AS/400 File into SQL server 2008? From within SQL 2008 we do not see an ODBC connection that will work for the 400(??) I am not familiar with SQL server and we need to get some data to it. Can anyone shed some light on what I may be missing in regards to the link to...

    Rmason335 pointsBadges:
  • Update trigger

    I am working in SQL 2005 and need help creating a trigger that will update fields in a record with the user/login and system date after a field in the record is updated.

    Dkrueger40 pointsBadges:
  • SSL on SQL 2005 Express

    Hi, I am attempting to encrypt the connection string to/from my database server. I cannot seem to find guidance on where [what directory] to place the CA certificate. I am working with a Windows Form application that call to the data store. Any assistance will be appreciated.

    ETCGMan40 pointsBadges:
  • Migration from SQL Server 2000 to SQL Server 2005

    Hi EveryBody, I am new to SQL SERVER 2005, I have migrated my SQL SERVER 2000 database to SQL SERVER 2005 and it has degraded my site performance. A Page that opens in 10 seconds is now opening in 30 seconds. I have updated the STATISTICS of the database using UPDATE STATISTICS command but no gain....

    Nitin19835 pointsBadges:
  • SQL Server 64-bit Memory Requirement

    We are replacing an existing SQL Server 2005 32-bit environment with a new SQL Server 2005 64-bit Enterprise High availability environment. The new solution will be a 2-node Microsoft Cluster with SQL Server Cluster Server, all 64-bit Enterprise additions. What I have a problem determining is what...

    ITcar5 pointsBadges:
  • SQL divisions

    Hi All, I'm trying to make a calculation through SQL code but this is resulting in a 0. Example: declare @activities as integer declare @days as integer declare @media as float --my queries that extracts data and sets values to @days, @activities; in this case they return @activities=51 and...

    alessandro.panzetta9,725 pointsBadges:
  • Permissions for writing stored procedures in MySQL

    Hi Friends, I have been using navicat to connect MySql5.0 in my local evironment.I connect my java project to MySql database as backend. Now my problem is, I generated an sql script to backup my local database. I run the script in server. Tables were created. But in the case of stored procedure, I...

    Ktrramu5 pointsBadges:
  • Shortening the generation time for a SQL Server 2000 report

    I have 516 different functions in SQL Server 2000 that are used for different calculations. These functions will operate on more than a thousand Microsoft Excel files. Each Excel file has 960 rows, and generating the report took over four hours. Is there a way to shorten this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Pulling rows from SQL Server and loading the data into column textboxes

    I am trying to load data into 13 column textboxes, and I need the ability to pull any number of rows from the SQL Server based on these parameters: control group number, accounting period and posting date. The results will be about 50 lines of transactions, and I want those loaded to textboxes on...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating data from a SQL Server 2005 database to SQL Server 2000

    I am looking for advice on what technology to use to migrate data from a SQL Server 2005 database to SQL Server 2000. We are currently phasing out our old help desk ticketing system in SQL Server 2005 to a new ticketing system in SQL Server 2000. The tables in the databases are not identical...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Transferring a database and writing a database script in SQL Server 2008

    I want to transfer a database from one server to another server using SQL Server 2008, and then I want to write a script which i can update the database daily automatically. How can these be done?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Different SQL Versions on the same server.

    I was hoping someone could tell me if its ok to install SQL2008 Standard for use with company accounting and billing applications and also install SQL2008 Express for use with Sharepoint 3.0 on the same server. I could put the versions of SQL on different volumes if that helps. The load Sharepoint...

    Arans5 pointsBadges:
  • Problem rendering a field in SQL Server Reporting Services

    I have a strange problem with SQL Server Reporting Services. My report does not render a field when viewed either from Report Manager or when run through subscription. However, the same field is rendered correctly when I test the report in Development Studio. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Linked Server Question

    I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however when...

    AN5gel675 pointsBadges:
  • SQL SERVER 2000, 2005 & 2008

    Can Sql Server 2000/2005/2008 exist on the same machine

    Sdonthi5 pointsBadges:
  • I need to up load an excel file to sql server db with vb

    I need to upload a excell file to sql server. I made a Stored procedure with the openrowset but if i run de stored procedure works, but embebed in visual basic or in crystal repor an error appears.Somethig about serverliked or server trusted i don't rememeber. does somebody an idea? thanks in...

    Xs4010 pointsBadges:
  • Building reports in SQL Server 2008

    I am on SQL Server 2008, and we want the clients to be able to build their own reports whenever they want. Are there any tools out there that can do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • An alternative to using triggers on a SQL Server

    I am using triggers to update two similar tables on a SQL Server. Is there any other method to do this?

    SQL Server Ask the Experts2,585 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