• 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:
  • Transposing a table using SQL Server Reporting Services in VB.NET

    How can I transpose a table using SQL Server Reporting Services in VB.NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Cannot Regster remote Sql Server 2000

    i can access remote server by remote desktop and i can ping server also, but fail to register remote sql server,Please Help

    Master197015 pointsBadges:
  • SQL Writer error

    sql error in the start; either mesup or tempered

    Chuanilee5 pointsBadges:
  • Server Performance online replication

    I have DB of 60 GB on SQL 2000 running on A/P Cluster. I want to do online replication. What would be the impact over Live server performance. Kindly Suggest.

    Natish10 pointsBadges:
  • Import SQL Server 2000 DTS package to new box

    Hi, I am building the new SQL 2000 SP3 server on Windows 2003 R2, in my old box there were alot of DTS package which is I need to import, my question is what account should I import it as to avoid the security right? in my old box I have 3 admin account only one own the DB whoever, DTS package were...

    Bjet55 pointsBadges:
  • Calling a SQL Server 05 Stored Procedure from Oracle

    Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

    Nikkipom795 pointsBadges:
  • Need SQL query

    I have two tables DETAIL and USER. Detail table have two columns (projectid and projectdetail). Projectid is a primary key in DETAIL table. USER table have two columns (projectid and Userid). User table is like more than one userid can be under each projectid, one user can access more than one...

    Minuvinu35 pointsBadges:
  • Adding an index on fields in a SQL Server table

    I have a massive customer table. The ID is the primary key and thus SQL Server makes a clustered index on that. There is no other index on the table. Can I add an index on fields like age, country and gender to make the results faster?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating tables on a SQL Server

    I am creating a directory of local businesses. I have found that my city is divided in to 4,816 business categories, which means I need that many tables in my database. Is there any way that I can create these table with a stored procedure, a SQL function, or a SQL script file? I want to use a...

    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