• Loading a new database from an Old one

    I am new to SSIS. We are running SQL Server 2008, and I have to load a new database from an old one which had a different structure. I'm not sure how to cope with PK's that are identities. For example, I have three tables: 1) Main table eg. A list of applications 2) Joiner table eg. A list of...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database management plan wizard

    I installed Microsoft SQLSERVER 2008 management studio Express with advanced services. I am trying to work with Database management plan wizard. What is the navigation for that? and i don't find management plan folder under management in SSMS express...Do i need to install sql server enterprise...

    Student0045 pointsBadges:
  • Database Best Practices for index values

    I'm more of a .NET than a database guy, but sometimes we just do what we've got to do.  Please bear with me if this is an elementary question. One of the apps I'm working on now will have to parse data from another system and store the values in the database.  The data coming from the other...

    Overtech65 pointsBadges:
  • SQL 2008 stored procedures and execution plans

    Hi, Is it any significant difference in performance between stored procedure with many parameters (some of them can be null sometimes) and creating many stored procedures that will contains only subset of this parameters ? Thx,  

    Bink15 pointsBadges:
  • Alter Column Drop Identity in T/SQL?

    Is it possible to alter a column definition to remove its identity property?

    Jagoodie60 pointsBadges:
  • Where did the undocumented stored procedures go in SQL Server 2008 Managment Studio?

    Is there a way to see the undocumented stored procedures in SQL Server 2008?  They don't seem to show up in the explorer tree in Management Studio the way they did in SQL Server 2000's Enterprise Manager. I was able to run XP_FIXEDDRIVES but it doesn't show up in the list under stored procs in the...

    Brenbart5 pointsBadges:
  • Synchronizing SQL Server 3.5 Compact Edition to SQL Server 2008

    How do you synchronize of SQL Server 3.5 Compact Edition to SQL Server 2008? I have the framework installed, do I have to create a third party application to actually perform the synchronization?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Will Visual Studio 2003 and SQL Server 2008

    Will Visual Studio 2003 work with SQL Server 2008 databases.

    CGarnett15 pointsBadges:
  • SSRS statistics

    Hi, I new to SSRS. I have a table grouped by a category. I need to make a statistics about number of rows of particular item and sum of few columns in each of the group. I can make those statistics inside the tablix. But I need to have those statistics outside of the tablix in a separate text box....

    Accetjkk5 pointsBadges:
  • SQL Server 2008 & Team Foundation 2008

    Hi All, Just wondering if anyone has had issue with using SQL Server 2008 with Team Foundation Server 2008. I know there was a compatibility error that occurred when you tried to installing TFS with SQL Server 2008 however this was address with TFS SP1, are there any issue or error that I should...

    Db23290 pointsBadges:
  • SQl Server 2008 Plain Text procedures results iin Encrypted Text within Profiler

    I am attempting to trace some SQL activity on a SQL 2008, Standard SP1 64-bit server. In the profiler trace, I keep seeing Encrypted Text in the textdata column for triggers and procedures that are clearly plain text and are not encrypted. In this example, the object is a trigger. I do notice that...

    ITKE409,090 pointsBadges:
  • Composite foreign Key in SQL Server

    I have a composite foreign key that has to be part of the primary key of the new table... but an error appears in SQL server... CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel, IDvta)...

    GabyCostilla5 pointsBadges:
  • Complete System Backup SQL Server

    We are running SQL 2008 on Dell Servers with a wholesale Distribution Package Software by Activant Solutions Called P21 (Prophet 21) Our question is this! WE have a SQL Server and a TS Terminal Server running our Distribution Software and off of this equipment was recommended by the Activant...

    ITKE409,090 pointsBadges:
  • Why should I use SSAS for Predictive Analytics?

    We are considering tools for Predictive Analytics in Law Enforcement, and I have been asked to find the advantages of SSAS, especially in SQL 2008. What are your thoughts on the product and what can it do for us?

    Bubbuh5 pointsBadges:
  • CLR Assembly in MS SQL 2008

    I have a problem with COM-objects which i create in CLR-assembly in VB.NET via CreateObject. When I compile this assembly as console project and run loging under any account on server, it works ok. But when i run this file from MS SQL, it can not create object. What may be reason for this?

    dalex35 pointsBadges:
  • Filling data in datagridview in vs2005 with windows develpment

    HI all I have a more than 80000 data in sql server 2008 in a single table. Then i have to show that data in datagridview. But the performance has very slow some time my machine hang. It has taking several minute. So i have to improve this performance could anybody help me. For information i am...

    Visualpro5 pointsBadges:
  • SQL Server 2008: Difficulty setting mixed mode authentication password

    I am attempting to install SQL Server 2008 (64-bit) on Windows Server 2003 SP2 (64-bit). During the installation, I get stuck at the step where it asks for a mixed mode authentication password. Following the requirements, I have tried a strong password but I am still getting the error message, "The...

    SQL Server Ask the Experts2,585 pointsBadges:
  • unable to connect to SQL from Access

    I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version of...

    Standaman15 pointsBadges:
  • SQL server 2005 to SQL server 2008

    I am following using sql server 2008 but following some lessons written by BOB Taybor. Is MyCompany.mdf for 2005 abailable in 2008 format?

    Standaman15 pointsBadges:
  • Backing up SQL Server 2008 databases to a tape drive

    I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

    Phrathepmali30 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