There's a lot of new enhancements to T-SQL, including Common Table Expressions (or recursive queries), pivoting, partitioning, database snapshots, online indexing. Huge improvements in xml data, including XQuery...

VS 2005 is needed to correctly identify SQL Server 2005.

And you need the SQL Server 2005 Management Studio to access all the new services. Infact, the 2000 Enterprise Manager can't...

Ohh.. if what you are trying to achive is something like the "auto-number" feature in Access, then you really want an IDENTITY column in SQL Server.

Using a Max+1 will...

"Somehow, these users are also able to read all the stored proc present in that database"

Are you worried that the users can read the text inside your stored procedures?...

If you can't setup the service to use a domain account, then Pass Through authentication should work. You need to have the same user name and password on both boxes,...

Christoffer Hedgate has a good article on moving system databases as well.

http://www.sqlservercentral.com/columnists/chedgate/movingsystemdatabasesachecklist.asp

Put the tempdb back to where it was, maybe also move model back, and try to start sql server again.

Tempdb is automatically re-created by sql server (by copying Model)...

If SQL Server wont start, it will give detailed reasons in the error log. (usually located in the LOGS directory). Just read  the latest log and see why SQL Server...

Are you mapping supplying a username & password?

Does your SQL Server / SQL Server Agent account have permissions to the files on the network server? to the share?

Are you running an Active...

If you backed up the entire database and logs, it should restore all the objects in the database, including your stored procedures.

However, your logins may be screwed (as the Sql...

Elaine, if there are no Foreign Key / Primary Key relationships on the table you can use the

TRUNCATE TABLE myTableName

command. It deletes ALL the data in the table without...

Hmm if your question is: Can I execute a stored proc for each result row in a select statement? the answer is No. You have to use a Cursor, or...

First I'd make sure that you have a custom 500-100 error page if you are using ASP. If you are using ASP.Net look at setting a custom error page in...

I'd definately use the datediff function to determine if the date changes. It's the most reliable way to check for differences in dates, a function that is specifically written for...

use Remi's code.

DESC order is what you want. That will make the latest entry display first.

ASC is the default sort order, which is what you were getting before.