Are you explicitly closing the connection and cleaning up the objects to be sure they are gone? COuld you post an example of how you make the connection an how...

Yes you do have to qualify with the schema owner all user defined functions.

But I am a bit confused on how this gives you GMT outside of your request.

Actually if space i really not a concern then you don't want to perform a shirnk. Odds are your file will grow again for the very same reasons it did...

To expand upon. In deciding what index to use for a search it is based on selectivity statistic of how unidque the index is. It doesn't factor in if it is...

You don't have to give access to the database now roberta already has access. In the database in the users group (folder, subtree or whatever you want to call it)...

OK if you are referring to creating a new installed instance of SQL Server on the machine:

You basically run the install and following the same steps except make sure you...

You're absolutely right. I did not catch on to that. With that said. have you tried this.

Detach the db. Rename the log file (we usually change the extension). Use Attach...

No what I meant is in SQL Logins? Or Database Roles? What do you mean by Group exactly?

I would still hire the one I thought was better qualified. Unfortunately friendships fall on these issue often and it really is a sad thing considering you have to do...

First off I don't know the size or details of the drives so I can't say what is truely best. I also included Reporting Services databases in case you are...

Where are you creating these?

The short and simply answer is that it comes down to gut feeling and overall impression on the final choice. You can come up with hard real world case scenarios,...

The key is that GUIDS are sorted like all character data so if you have a million rows and you have covered 0-9A-F and you next value is 8xxxxxxxx(whatever) then...

It creates an ODBC entry. Open Data Sources (ODBC) in administration tools (under control panel if no where else) of the OS and you can edit there.

http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en#Requirements

Important: SQL Server 2000 Service Pack 4 is not supported on Windows NT 4.0, Windows Millennium Edition and Windows 98 platforms.