ok that helps explain the logic, thanks.

is there a master table that has value like this?:

1 Gary

2 Terry

3 Bob

so we could lookup/compare the proper name that...

not enough info;

you have a table with salaries, what does it contain? do you mean a base rate of pay? is it an hourly rate, so $10 dollars an...

terry you'll need to explain the "rules" a bit clearer. I'm not sure why a unique index on the two columns does not do what you want.

i'm just guessing, but...

I'm venturing a guess that you might not be familiar with creating a join on more than one column...like you said, it's intuitive if you had a unique column.

what might...

The views will use the existing indexes that are already on the tables; no...

i had a little trouble reading what you wanted, but i think i got it.

1. you want to create a view for every table in the database, but exclude one...

but with Service Broker, you are sending emails and such, right? I thought the original poster was saying he wants a form to open up on everyone who is...

David with luck this will get you oriented.

you need to open SQL Server Management Studio, and get the object explorer on the left side opened up; once you have that...

the error tells what the issue is, but it might be a little new to you for debugging these kinds of issues.

to really help; we'd have to see the code...

Kris if you alter...

dtipser (4/26/2010)

---

Hi,

Yes, I created the index, but after that is asking to create another one. For sure the statement run a litle faster but it still doing some scans in...

Developer 2005 (4/26/2010)

---

Thanks

u are right

but we don't want to send mail to all user.

i want to pass a message in message box and want to display on screen of...

search your MSSQL.1mMSSQL.2 and MSSQL.3 folders for *.mdf files.

with luck, one of those files should be the name of your old database.

once it, you will copy that MDF file along...

hansel i'm not sure what you are doing...

sysobjects in SLQ 2000 contains the metadata of all the objects in the database, including the tables; you can join sysobjects to syscolumns...

i actually can see how that is a good idea; some views pulling together a lot of stuff shouldn't be ad hoc queried;

I like the idea.

i might actually rename some...