Peter

This may help you:

http://msdn2.microsoft.com/en-gb/library/ms173423.aspx

Since schemas and owners are different concepts in SQL Server 2005, you shouldn't try to change the "owner" of a view to information_schema.  And if you...

Nathan

To get a domain set up, you'll need to speak to your network administrator.  In the meantime, your best bet is probably to do all your testing on one computer.

John

Dean

Something like this?  I haven't tested it.

John

SELECT e.Employee, a.ChildName, a.ChildSex, a.Age

FROM EmployeesChildren e JOIN

(SELECT Employee, ChildName, ChildSex, Max(ChildAge) as Age

FROM EmployeesChildren

GROUP BY Employee, ChildName, ChildSex) a

ON e.Employee =...

Nathan

I think I'm right in saying that you can't put local users from one computer in a local group on another.  If you have a domain, create a global group...

Nathan

Create a Windows group containing all the users that need access to the database.  Then grant that group access to the server, that is, make it a login on the...

Dean

From your sample data, an inner join will be enough:

SELECT RestName, FoodName, r.Group

FROM Restaurants r INNER JOIN Food f

ON r.Group = f.Group

However, what happens if there is a...

Yomesh

What are you referring to here?

John

Are you getting an error message?  If so, what does it say?  Chances are that the account you are logged in as when you use DOS is not the same...

How do you define "invalid"?

John

Peter

I'm not sure what it is you're trying to do.  Information_schema views are built in so you can't create them.  Please post the SQL that you are trying to run...

UPDATE t2

SET distinguishedname = t1.distinguishedname

FROM staffdetails t1 JOIN staffdetails2 t2

ON t1.displayname = t2.displayname

John

James

I think the key is to do your delete in small(er) batches so that it doesn't fill your transaction log up in one go.  Before you do that, read in...

Do you not have your own picture you can use?  That's what I did.

John

Choose My Profile from the My Account menu near the top of the page.  Then click on Avatar, where you can upload your picture.

John

Glenn

This is one of those issues where you can waste days trying lots of fixes that don't work.  Or you can spend half a day blitzing  the whole thing and...