First I want to state that I am relatively new to Sql 2005 and schemas so I still think in terms of owners, but I think I can give you...

Use T-SQL, from BOL:

ALTER LOGIN login_name

{

| WITH [ ,... ]

...

I have a degree in Physical Education, found out I can't stand children and ended up working with Developmentally Disabled adults for 4 years. My best friend from high...

Actually either indexes or indices can be used as the plural of index. I tend to use indices because no one else does.

Have you compared the...

This is interesting as I just a had a discussion about this with a coworker and I did not know it was even possible. When I googled it the...

What are the indices on your tables? Are the databases on the same machine? How much memory is allocated to SQL Server 2005 vs. SQL Server Express?

Are you using SSMS to create the linked server? If you are it should be in the provider drop-down box. I had to scroll down to the 11th...

Question 1:

I believe FoxPro does not support full object qualification, server.db.owner(schema).table. I believe you just want server.db.table.

Question 2:

I don't think you can access a linked server through a linked...

You should make sure you have the latest version of MDAC installed.

What jumps out at me to start are the outer joins. Are these really necessary?

Thanks, the second articl was helpful.

Check out this article on rebuilding and restoring the master DB.

http://articles.techrepublic.com.com/5100-1035_11-5025441.html

I am assuming you are using SSRS to develop this report. In SSRS you could put the calculation as a calculated field in the dataset and use that...

Yes. But it actually brings us to a different point - that we can't have one set of ideals for the DBA candidate. No doubt each of...

R L Reid (10/15/2007)

How about "Gee, I'm not sure. I don't see a...