• T-SQL how to identfiy tables that have dulicate roaws

    I have a MS 2000 SQL server. How can I search the db and indentify the tables that have duplicate raws. Thanks

    Techzon1225 pointsBadges:
  • Consistent error occuring in SQL Server 2005

    I have five servers in my network. On one member server, I have SQL 2005 Standard ver.9.00.1399.00 running on MS Server 2003 R2 SP2. In my event log on this server, I am receiving an error every couple minutes. They show up in the SQL error log as well as the event viewer. The error is: Event Type:...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Ask a question. Win an IT Knowledge Exchange T-shirt

    Community members Brent and I decided to put together a cool little contest. It is very simple. For the next week, starting today, all members that ask questions will be entered to win 1 of 5 IT Knowledge Exchange t-shirts we will be giving away. The more questions you ask the better your chances...

    ITKE344,705 pointsBadges:
  • i have windows 2000 server and isa server 2000 and we have some problems one is when i connect cmd then the command is arp -a then ip and phisical add

    i have windows 2000 server and isa server 2000 and we have some problems one is when i connect cmd then the command is arp -a then ip and phisical address show butt ip is different and mac address is same

    Sulaman5 pointsBadges:
  • MS SQL Server installing in the Livelink

    Hi there, I want to create a new Database ( MS SQL ) in the Livelink 9.7.0 , so which version ( MS SQL Server 2000 or 2005 ) is install in the Livelink 9.7.0 . If together can installed in Livelink 9.7.0 , whichever is better ? Best Regards, Abdullah from DUC

    A9944495 pointsBadges:
  • How to delete a duplicate SQL Server entry in a single redundant table?

    How do you delete a duplicate SQL Server entry in a single redundant table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Executing a Stored procedure using Excel Macro

    I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Exporting large files in Reporting Services 2005

    Reporting Services 2003 uses a lot of memory for the Excel Export, making it impossible for files 15 MB or larger. Is this still an issue in Reporting Services 2005 or above?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using VB.NET to find local subscriptions on SQL Express

    I have several different SQL Express databases using pull subscription replication with a SQL Server. Different computers will have different databases to replicate with; some have more than one. Is there a way in VB.NET to find all the local subscriptions on the computer running SQL Express?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Storing attachments in tables on SQL Server 2005

    I am new on .NET and plan to migrate some applications to this new environment. I have a simple question – on SQL 2005, can you store attachments inside of tables?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Help with new installation of SAP CRM and supporting software

    We are going to Install SAP CRM 5.0 with Microsoft SQL Server 2005 and ECC 6.0 with Oracle 10g and integrate these with each other and also with QAS (Third Party tool). My question are: 1. Can we install all three applications on one single server as database is different or will there be issues...

    CRM Ask the Expert250 pointsBadges:
  • Data Sources for SSAS 2000

    I have a short term issue where I will need a SSAS2000 cube to be using data from a SQLServer2005 database. Can I do this directly? If not, can I Export MSSS2005 data directly to the MSSS2000 database? (Sorry for such a simple question- I am a newbie).

    Petro5 pointsBadges:
  • Table creation in SQL Server 2005

    Hi, I need to prevent users to use CREATE TABLE but I need them to be able to execute a stored procedure that creates a table. Is it possible to allow users to create tables in SQL Server 2005 only through a stored procedure? Thanks in advance.

    Alediamo10 pointsBadges:
  • SQL SERVER REPORTING SERVICES

    can anyone explain what is presentation delivery utilizing reporting services?

    Swaroopa5 pointsBadges:
  • msforeachdb

    Could not locate entry in sysdatabases for database, when using msforeachdb

    Llsnowinaz5 pointsBadges:
  • SQL 2005 Transaction Logs

    I am by no means very good at SQL. I know the basics. I am a network engineer but was recently asked to do a few tasks in a SQL 2005 environment. I currently have a database that is residing off-site and I was asked to import the database and transaction logs so that this server can be used for...

    Danyluk15 pointsBadges:
  • Need advice on CRM application integration for email newsletter system

    We are in the process of developing an electronic email newsletter system for one of our client. Could you tell me how we may be able to link to and from their Microsoft CRM database to our email newsletter SQL Server database. For example, we need to link the newsletter with the database of...

    CRM Ask the Expert250 pointsBadges:
  • Insert records between records in a file using RPG code.

    Is there a way to insert a record in between records in a file? For example, a file contains 10 records (1 to 10). I want to insert a record in between records 1 and 2, thus record 2 will move to position 3, 3 to 4, and so on and so forth. Can SQL/Insert function be used to do this?

    Francissamonte15 pointsBadges:
  • installing SQL server enterprise edition on XP

    how can I install SQL server enterprise edition on windows XP? I know there is a way but I dont know it if some body know it tell me plz

    Sazzemokhalef5 pointsBadges:
  • Should we use system tables or information schema views to retrieve metadata if both give the same results? Please explain why.

    Should we use System tables or Information schema views to retrieve Metadata, since both give the same results, and why?

    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