• 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...

    Rmason345 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:
  • 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:
  • 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:
  • Recovery models for SQL Server databases

    What are acceptable recovery models for the Master and MSDB databases?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error uploading records into a SQL Server table

    We have 700 hundred records, and we wish to upload them into a SQL Server table. After 600 have been uploaded, SQL Server failed to upload the last 100. Why might this have happened?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Storing large data files in SQL Server

    What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Investigating SQL Server 2005 memory issues

    We have a data warehouse server running SQL Server 2005 Enterprise Edition. Lately, after a restructure, we're seeing some performance hits. If this is due to what was added during that rebuild, we have no problem with it. However, we are not sure. When a query is run, the disk queue fluctuates...

    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