• Objects explorator FILTER doesn’t work, SQL Server Management Studio de sql server 2008

    Hello friends, On my PC (Windows Xp 2002 SP3) in SQL-Server management studio 2008, the object explorator filter doesn't work. The funnel symbol is simply greyed. I can't access to the box bialog filter parameters. Please, anybody has an idea ? Jean-Max PS : Microsoft SQL Server Management Studio...

    Poussines50 pointsBadges:
  • Will we really save money having users shut down computers at end of day?

    The article below caught my attention. It says that 217 million dollars a year is wasted just in the UK alone by employees leaving computers on overnight. I never shut mine down...my old mentor thought it was actually harmful. Needless to say, we don't have a policy about shutting down computers...

    NoFX3915 pointsBadges:
  • How to use Insert command between two servers to speed up performance

    We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the data got there....

    Studentofsql5 pointsBadges:
  • Implement SQL Service Broker with SP

    Hi, Can some one help me by giving a sample program in detail on how to implement service broker concept using Stored procedures across different servers, and with in a DB and between Databases. It would be a great help if I could get answer at the earlest. Regards Jeevan

    SQLHELP5 pointsBadges:
  • Data retrieval from TextBox and insert in to database

    Hi i am learning c#2008 and asp.net3.5. I want to get data from my textbox control and insert it in database so i cant find any source code or presentation so please tell me how to do it or give me site address where i can find this Thanks

    Nimitparmar19875 pointsBadges:
  • view active directory data using SQL server 2005

    How could I view active directory data using SQL server 2005. For example I have all of the data available in Human Resource system and I would like to pull some of the information to the active directory like name, position and department … ext where the user name is primary key. Thanks alot for...

    Reem15 pointsBadges:
  • test management tool

    I'm in the process of researching test management tools and was wondering if anyone has any insight to what worksfor them and what doesn't. Also any information on free vs purchasing. Soem features I'm looking for are: user story documentation, test case documentation, defect capture and process,...

    Flyershockey25 pointsBadges:
  • 16 node failover clustering in SQL Server 2008

    How can 16 node failover clustering be achieved in Microsft SQL 2008 enterprise edition? Are all nodes in active state? How many nodes can remain active?

    Akansha150 pointsBadges:
  • Retrieving records from main database and logs database

    Our system has one main database (jadeappdbase) but the system logs (logs per transaction/process) are stored on a separate database on a monthly basis (a specific database is created every start of the month to hold all the logs for the said month). How will I get certain records from the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • bulk update query using sql server

    Hi , We need a way using sql server  for updating more than one rows at a time . Thanks , Pramod.  

    Pramoda5 pointsBadges:
  • Protecting Oracle report source

    Is there a way to wrap the SQL in an Orale report, or another way to protect the report source?

    RMS5 pointsBadges:
  • Policy Management – SQL Server 2008

    I have installed SQL Server 2008 Developers Edition on Laptop witrh XP. All installed ok but noted that under Management section there is no policy management. Is this a separate option during the installation or not included in the Developers 2008 edition of MS SQL Studio?

    Ganners255 pointsBadges:
  • DB2 to SQL Server migration

    We have a client that is migrating from the AS/400 DB2 to .NET and SQL Server and they want us to find them a resource to help locate and then migrate the data stored on the DB2 data base to SQL Server and I was wondering if that is more for a DB2 DBA or for an AS/400 Systems Analyst? Also, the...

    SolpartDean5 pointsBadges:
  • SQL Server 2005 multi-instance cluster

    I need to set up a 2 node multi-instance SQL Server 2005 cluster (active/active). Since each node will failover to the other, can I use SQL Server 2005 Standard Edition on each node or do I need to use Enterprise Edition?

    DbaDave25 pointsBadges:
  • Please explain SQL Ingestion with a example?

    Please explain SQL Ingestion with a example?

    Mayurkhe295 pointsBadges:
  • When does SQL performance start being affected by the size?

    When does SQL performance start being affected by the size?  We are running SQL 2005 64bit on Windows 2003 Enterprise 64 bit server.  The database is over 1 tb.  When does MS SQL start to degrade with database size? 

    Mcappy5 pointsBadges:
  • Data archiving to additional server

    We have two identical SQL Server 2005 databases. We need to archive data to another server over a network. What would be the best way to accomplish this? This is primarily required because data needs to be archived for at least five years. We don’t need the archive server for backup purposes,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating DTS packages that use mainframes source to SSIS

    I am trying to migrate DTS 2005 packages to SSIS. The packages that has SQL data source is migrating around 60% but the packages having mainframes (AS400/DB2) data source is migrating only 10% what is the reason? and How to get this problem resolved?

    Jwalini5 pointsBadges:
  • Multithreading T_SQL

    I have to pool data from 1000+ sites on different physical servers through a web service running on each server. What is the best way to do so using T-SQL so that the multiple threads/processes run in parallel

    Rajeevraina5 pointsBadges:
  • Permission to Export SQL Server 2005

    On SQL Server 2005, what is the minimum permission needed to allow a user to export tables from one database server to another server? Permission on SOURCE=? Permission on DESTINATION=?

    VelameLaCosa110 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