Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Karin3
  • Content: Threads
  • Order by date
  1. Karin3

    system stored procedure

    Is there a system stored procedure that will allow for the comparison of sysobjects between two separate databases? Or does any one have some code handy. This is for SQL 2000. Thanx in advance.
  2. Karin3

    Mass rename

    We are in the process of migrating from sql 6.5 to 2000. We need to do a mass rename for user_id which exists in all tables and sp's in a very large database, and is now a reserved word in 2000. Any ideas on how we can manage this, or if it is possible to do a system wide rename or search and...
  3. Karin3

    Installing SQL 2000

    Our trial version of SQL 2000 has expired and we can not connect. We do have a lisenced version that we have not installed yet. Is there a way to install the lisenced version then get connected to the trial version. We need the data bases created in the trial!
  4. Karin3

    Limit rows returned in nested subquery

    This is the error msg: .&quot;Subquery returned more than 1 value. This is illegal when the subquery follows =, !=, <, <= , >, >=, or when the subquery is used as an expression. Command has been aborted. &quot; Example: I want a list of peoples phone numbers that fall in certain criteria, and...
  5. Karin3

    Convert datepart week into smalldatetime range

    I need to convert week numbers into the corresponding date range. The reverse is quite simple select datepart(week, 'Sep 12 2001') This will state that for Sep 12 2001 the week number is 37. How can I get the date range for week number?

Part and Inventory Search

Back
Top