• Is firewall preventing SQL Server from showing up in the EM?

    I have a corporate Dell Image laptop running SQL server 2000. Enterprise manager (EM) shows up without my registered SQL server (local or remote). When I try to re-register I see the other registered servers, however, they are grayed out. When I use the MMC Snap-In from computer management, I can...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Can SQL Server 2003 provide CPU usage information by application?

    I have a Windows Server 2003 Service Pack 1 (SP1) machine and need to find out how much of the central processing unit (CPU) each application is using. I am familiar with task list for Windows XP, but the only task list I see on the Windows 2003 machine is a command line tool and it does not...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Having problems converting SQL Server queries to stored procedures

    I am using SQL Server queries as in-script and I have now decided to use the queries as stored procedures. However, I am facing some problems while converting the SQL Server queries into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I move all stored procedures to a new SQL server?

    I recently moved a database from SQL Server 2000 to a new server running SQL Server 2005. Is it possible to move all of the stored procedures to the new server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Stored Procedure Problem

    Hi Greg, I am using SQL queries as in-script and now decided to use them as stored procedure. I am facing some problem while converting them into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using with asp. SQL = “Select *...

    Anilak singh5 pointsBadges:
  • Learning SQL 2005/2008

    I would like to start from the grounds up in learning SQL 2005 and 2008. Any recomendations? I have been working with databases for sometime now including SQL 2000, but I have not jumped to anything newer. Thanks.

    NKaram5 pointsBadges:
  • How can I set the database password by the SQL Server Enterprise Manager?

    How can I set the database password by the SQL Server Enterprise Manager?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SUB-QUERIES

    Hi, Good you give me an best real example for using the sub query, correlation of sub query & Top analysis using subqueries. Thanks in Advance.................

    134915 pointsBadges:
  • I am using SQL Server 2005. How can I retrieve data from live server through the Internet using VB.Net 2005?

    I am using SQL Server 2005. How can I retrieve data from live server through the Internet using VB.Net 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server – I would like a stored procedure that will take the name of a table as input.

    I would like a stored procedure that will take the name of a table as input. What the procedure would do is drop all indexes on that table except any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another stored procedure that takes a table name as...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server – Is there a formula for determining what identity range to set?

    We have been struggling with exhausting our range and get the following error: The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers or when...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Create Information_Schema view

    Back in 2k, there was a backdoor that allowed you to create an INFORMATION_SCHEMA view. Backdoor yeilds a permissions error in 2k5. Is there any way to create a view in Master that would be accessabile from all databases like the Information_Schema views? Thanks for the help... --Jeff Moden

    Jeff Moden30 pointsBadges:
  • Hosting SSRS on Windows XP – user limitation.

    While I host SSRS on a Win XP Prof machine is there a limitation on the number of users who can access this site at once.

    Yup5 pointsBadges:
  • Restoring Databases

    Sir, I have deleted a table in sql database.Is there any option to recover it without losing the data.Please reply

    H1005 pointsBadges:
  • How can I restore my old data into the new design in SQL Server 2000

    The SQL Server 2000 application I was using was badly designed. Now that there has been a rework of my database design, so many more tables and columns are being added. How can I restore my old data into the new design?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I structure this in SSIS?

    Within SSIS, I need to do the following: 1. Select the max(to_date) + 1 from a table in SQL Server. 2. Pass this value to a view where clause statement; this view is an Oracle view that needs this date value so I can get the new data from Oracle and load it into this same table in Step 1. How can I...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using Case Statement Inside SQL Join

    Hi, I am trying to convert dynamic sql into static sql due to permission issue, I faced a challange when i am trying to convert this part of code given below -- join to ADDR_DETAIL SET @join_sql = 'inner join ADDR_DETAIL on ADDR_DETAIL.GRP_CONTACT_ID = pm.GRP_CONTACT_ID AND ' IF (@ChannelEntity =...

    Bmdayal5 pointsBadges:
  • How to transfer encrypted data between SQL Server 2005 and SQL Server 2000

    We are a retail/web/phone order store. We process credit cards for all three stores at our retail location. We have our web data stored offsite on the web server, using SQL Server 2005. We have our retail/phone order data stored onsite in SQL Server 2000. I'd like to add a function to our MS Access...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Unable to execute the saved SSIS package.

    I have two servers server1 and Server2 both has SQL Server 2005 installed.Server1 has Enterprise Evaluation Edition SP1 and server2 has Workgroup Edition SP2.Since server2 has workgroup edition I cannot open the saved SSIS package in server2. So I connected from server1 created a DTS package and...

    MNA20 pointsBadges:
  • How can I initialize arrays in stored procedures?

    How can I initialize arrays in stored procedures?

    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