Recent content by Karin3

I've checked it out and it is a bit complicated for me. What I need to do is compare indexes between databases. I've only been at SQL for a year and learning as I go.

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.

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...

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!

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...

Thanx for the tip, I'll give it a try. Karin

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?