• Displaying the COUNT in a SQL database

    I have the following information available from my SQL database: Incident Type COUNT ADHOCREPAIR 13 CONSEXCHANGE 7094 ENTERPRISE 21189 FONECARE 38996 FONECAREEXCHANGE 6280 FONECAREPRIORITY 1251 POSTALEXCHANGE 929 POSTALREPAIR 4575 RETOUT 1 I also have the specification that ADHOCREPAIR CONSEXCHANGE...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Row versioning in SQL Server 2005

    What is row versioning in SQL Server 2005, and how does it work?

    SQL Server Ask the Experts2,585 pointsBadges:
  • List,Save and FTP list of all databases

    How do I run a job to list all SQL databases on a server, save the output and then FTP the output file to another server?

    Mistp00120 pointsBadges:
  • SSIS – Bulk Inserts dynamically into various tables depending on the input file name.

    I have a scenario where a folder consists of various files with the format 'ABC_DbName_Date_TableName.txt' and there are many Databases with DBNames For e.g. - DB1, DB2 DB3 etc consisting of tables created every day with a 'Date_TableName' format. I need to provide a prompt to accept a folder name...

    NewLearnerSSIS5 pointsBadges:
  • Facing a problem while working with transactions

    I m having my SQL server on Machine A and i m starting one transaction on server from Machine B, now in between suppost Transaction from Machine B creates a new record in one of the table on server using insert into statement, after creating the record the LAN connection of Machine B is...

    Rajratna5 pointsBadges:
  • database ownership won’t accept login

    I'm trying to assign an owner to AdventureworksDW so I may turn on database diagrams. Neither the GUI interface nor the 'Alter Authorization ...' method work. The sript approach reports success but whe reopened, the dialog still shows the property blank. Any ideas?

    Jsmaccready15 pointsBadges:
  • how to delete dup records from a table to ?

    basically i want to remove dups in a table. i have a table called productincludes it has a few fields listed here: ParentProductID ChildProductID SummarizedRowID IncludeStatus LastUpdateDate DisplayOrderByID i ran a update for a business request that made many dup rows and want to clean this up....

    Supergirl20085 pointsBadges:
  • Errors: Violation of UNIQUE KEY constraint ‘UN_FILENAME’. Cannot insert duplicate key in object

    when i am migrating data from oracle9i to SQL2005 i am getting the error Errors: Violation of UNIQUE KEY constraint 'UN_FILENAME'. Cannot insert duplicate key in object how should i solve the problem

    Lava5 pointsBadges:
  • Sql Server Database doesn’t updated

    Hello, iam developing an ASP.NET2 Application using SQL Server2005 database, i have updated data from a web page ,the data updated successfuly and displays a meessage that itis updated successfuly , but when i refresh the page or when i display the data from the database ,i found that no changes...

    AbuSolyman20 pointsBadges:
  • Strange behavior in Access 2003 user interface

    I create a form in access 2k3 data project connected to sql server 2k5. I put two check boxes on my form. On runtime, when i click on one of check box, it also fires on the other check box...set check box value from false to true. But it works normally when i use keyboard shortcut to fire that...

    Ipong40 pointsBadges:
  • SQL SERVER 2005 MAINTENANCE PLAN PROBLEM

    HI, SQL2K5 Maintenance plan does not delete old backups even when 'backups older than 1 days' is selected.so my backups are piling up and have to remove them manulally everyday. any solution? Marshall

    Marshall01275 pointsBadges:
  • SQL Connectivity with Developer 2000

    Hi friends, I am using d2k as front end and for backend i want to use my sql server 2000 data how i can connect it. Thanks

    Amitd15115 pointsBadges:
  • Spooling Oracle Output via SQL DTS

    I am able to execute a stored procedure that resides in a database on an Oracle server via a DTS Package on a SQL Server. I would like to be able to spool the output to a .log file on a different server. Is this possible using DTS?

    Broskek5 pointsBadges:
  • Setting and establishing a default connection before a SQL statement

    Is it necessary to establish a connection and set it to the default before and after the execution of any SQL statement? I am develolping a multi-user system with 10 users in Visual Basic 6.0 with SQL Server 2000 and i need to know this for my setup.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Column extention

    Hi I want to expand the number of columns that sql would permit me to creat. How do I start? any suggestions? example: 1032 maximun column limit I want in the area of upper 5000 ramge for a table. someone help thanks

    Ctc12320 pointsBadges:
  • releasing SSRS reports to clients

    we have clients that have ssrs installed on their servers and we would like to supply them with reports we have created using ssrs. what is the best way to go releasing our reports to our clients?

    Sabrena5 pointsBadges:
  • Data protection features in SQL Server 2005

    Can you explain data protection features in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Federated Fabric cluster

    Can any one help me out on how to setup a federated fabric cluster using SQL 2005 + windows 2003

    Henrywat4885 pointsBadges:
  • How to generate a column name in a table dynamically

    hi, I have to generate dynamic columns for a temp table. I have a temp table with column a, the column b should be generated based on a condition. B conditions are if value> 10 i have to genrate the column as 10 and if the value >20 the column name should be 20 etc....n values.... If i select...

    GIG240 pointsBadges:
  • A job to move database files from one server to different server

    Hi I have job which creates databases based on month in analysis services which contains cubes in the databases. I need to create a job to move the database ldf and mdf files of the previous months removing the database from the server if the month changes to next month. The database files should...

    GIG240 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