• Configuring a password message prompt on SQL Server 2000

    On SQL Server 2000, how can I make it so that the server will prompt me for a password when I am click on my database through Enterprise Manager?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message while restoring the a SQL database onto a mirror database

    I took a backup of my main SQL database, and I have created a new database with the name of MirrorDB. When I tried to restore the main database with NORECOVERY, MirrorDB is constantly listed as "Recovering," and it won't stop. I am getting a message that it is in the middle of the restore and...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Limit SQL Admin Access to a single DB

    I need to set up admin access on a MS SQL server but limit the access to a particular db.

    Cybx10 pointsBadges:
  • Reducing CPU usage on a SQL Server application

    I have Windows Server 2003 and with SQL Server 2005 installed. I run my timesheet software on that SQL server, but CPU usage reaches 70% to 80% when the program is running on many consoles on the client side. Is there a solution to reduce CPU usage?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Need SQL query

    Hi, I have a emp table in which I have 7 columns and hiredate is one of the columns. I need to query for the hiredate which has maximum number of employees joined the company on a particular date?

    Kirankg5 pointsBadges:
  • ReportServerService restarting after app domain cant unload

    SQL Server Reporting Services (MSSQLSERVER) service terminated unexpectedly. We are rs2005 Version 9.00.3239.00. What is causing this error to happen when in the ReportServerService_Main log there are 11 attempts to unload the app domain from 14:16:18 to 14:19:04 and then this error => e ERROR:...

    MJT20 pointsBadges:
  • Email notifications in SQL Server 2000 Enterprise Edition

    In regards to email notifications in SQL Server 2000 Enterprise Edition, what level of authority does the SQL Server Agent account need in order to email me that a critical job has died?

    SQL Server Ask the Experts2,585 pointsBadges:
  • deployment

    While running the setup on client machine, An error Number 5 occurred telling - "An error has occurred while establishing a connection to the server. When connecting to SQL server 2005., this failure may be caused by the fact that under default settings SQL server does not allow remote connections....

    Pchandrachoudhary5 pointsBadges:
  • Community Update: New Member Contest – Earn Knowledge Points and win!!

    Get some Amazon.com gift cards for your holiday shopping. Now is your chance to win an Amazon gift certificate based on your activity in the IT Knowledge Exchange Community. Remember: the more you ask, answer or discuss questions, the more Knowledge Points you will earn. The top 10 most active...

    ITKE346,360 pointsBadges:
  • Improving the performance of a SSRS report in SQL Server 2005

    How can I improve the performance of a SQL Server Reporting Services (SSRS) report in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Testing when primary and mirror SQL Servers are the same

    My primary SQL Server and mirror SQL Server are the same. Is this allowed for testing?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Advantages and disadvantages of certain SQL commands

    Where can I find information about the advantages and disadvantages of using SQL commands like BCP, BULK INSERT, SELECT INTO, etc.?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Comparing views, user-defined functions and stored procedures in SQL

    How do views, user-defined functions (UDFs) and stored procedures work in SQL, and what conditions are there on their usage?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Acquiring remote access for SQL Server 2000 from a private server to a public server

    How do I acquire remote access for SQL Server 2000 from a private server to a public server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Limit admin access to a single database SQL2005

    I want to set up an account similar to sa but limit the rights to a particular db.

    Cybx10 pointsBadges:
  • shrinking of pie-chart graph when there is no data

    In my application, i have to display "No Data Available " at the pie-chart when there is no data to show in pie-chart... I have done that by setting the NoRows property to "No Data Available" , but the graph block shrinks by 1-2 mm when there is no data..Can anyone provide me the solution to this...

    Bhushanladdad30 pointsBadges:
  • SQL Server restore duration

    what DMV show restore info. including the duration of a restore?

    JDPhillips5 pointsBadges:
  • sql table in rpg

    I need to read an sql table (file) in rpg and select certain records. I'm pretty green in sql. Anyone have a sample they could share? I'am better at rpg than ile., but I'll take what I can get. Thanks

    Brenger170 pointsBadges:
  • Transfering table data from one database to another

    I am using SQL Server 2005 i m inserting some data from one database to another. both Servers are resided on different machine.

    Pankaja5 pointsBadges:
  • Exchange 2000 and Active Directory mess

    I inherited the bulk of these problems due to poor forethought by a previous consultant. He moves on server crashes I get called in with no real history or information, workarounds to get business critical apps going while waiting on parts for other server and now stuck in the quagmire I'm in....

    Injury5 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