Can you include your code and some sample data? I am not sure what you are trying to do.

Toni

Specialization may be necessary to some extent. Adaptability is a tremendous asset. Marketability is of the essence.

Just be sure what you are asked to specialize in has...

Thank you Davros. I am still very much new at this and wanted to be sure I understood the import of your post. By the way, in...

Phil, I am glad you found another approach that works for you and thanks for the reference which gave additional parms, etc.

Dragos, as to PK - FK relationship restrictions, doesn't...

You can use the stored procedure sp_msforeachtable to do truncates on each table in the database.

sp_MSforeachtable @command1 ="Truncate Table ?"

Be sure you are in the right database before running this....

I know that getting old my eyesight is not as good but I REALLY missed the question or the code you need help with???

Toi

Did you try using [] around the term with the '-' character in it? Pardon me if this is too simple a repl.

Toni

I tried it on a named instance on my "lab" (home set up) servers and it worked for me with

select * from [TMM\TRAINING].pubs.dbo.authors

Did you also run an sp_addlinkedsrvlogin command? ...

In order to get SQL to accept the special character ('\') you put open brackets [] around the phrase. Trusting the rest of your statements are fine, try...

What's done is done. As you guessed, I did not post the code directly myself (instead providing areas to review that would allow creation of the solution) as...

Read up in your text book or Books On Line about the Top option and the GROUP BY function. You should be able to make it work from...

I can't answer the restore straight from a backup question but you can surely restore the backed up database to one with a new name and then copy the contents...

Not sure if you can do this but it sounds fairly workable at least to get back a sysadmin id then proceed from there.

http://www.lazydba.com/sql/1__7395.html%5B/code%5D

Toni

Would there be a way to reset the passwords and allow the users to create new ones?

Toni

There was an article in the newsletter about Derived Tables that offers a way to resolve your issue by taking the WHERE clause and creating a Derived Table for the...