You may also want to check that your WAN users are connecting to SQL Server using TCP/IP protocol.

In SQL Server Client Network Utility, make sure TCP/IP is listed first...

Is there multiple columns or only one big column there, Kanwar?

Can you give an example with the CREATE TABLE so we can see what the column definitions are?

There;s a number of undocumented features in SQL Server 2000 (that is, they probably wont exist in the next version, so try not to use them!).

There's the master..xp_fileexist extended sproc...

SQL Server 2000 allows the text, ntext and image data types to hold up to 2GB of data. Because such a huge amount of data can be put in there,...

Yikes! Keep it simple!

SQL BOL lists:

Or to make sure your SQL Server isn't taken out by an old worm, make sure you have the latest patch SP3a installed

http://www.microsoft.com/sql/downloads/2000/sp3.asp

Ouch.

I'm not familiar with Crystal reports, so i'm not sure if you can build a custom form in there or not. Putting the 'change password' in the same front-end app...

For reverse deployment I've seen this done a number of places (like taking a copy of live db's and putting them into a dev environment). The only thing that I've...

If you are working in a Windows environment, consider using Windows Authentication in SQL Server.

Windows authentication allows users to connect with the windows login credentials, so whenever they change...

pwdencrypt is not a documented feature of SQL Server (in other words, don't use it, get some real encryption).

But hey, in anycase, it returns a varbinary result, not a nvarchar...

checkout the BCP utility in the SQL Server documentation (Books Online).

BCP is a command line program optimised for importing / exporting data from sql server to a text file. BCP is...

If your procedure is doing a single select statement, you can do it without an IF block:

create procedute sp_abc

   @userid  int null

AS

    SELECT * FROM users WHERE users.userid = @userid OR @userid IS...

Grr.. I did a big reply and just lost it.

Yes SQL Server organises the rows inside the data pages in physical order, and with no BOL info to the contrary...

Assuming your audit table is going to be continually updated, making a DESCENDING clustered index on date will see SQL Server doing more work; everytime you add a row, SQL...

David.Poole is right. SQL Sprocs should follow the same sort of logic applied to any programming language. The decision to break something into a subroutine, or separate sproc, should be...