I am not sure how well it updates version 7, but for Win 2K you need to install the Personal edition of SQL server 2k. You should have it as...

No idea about the hardware diagnostics to run. Speak to your server support guys. They have probably already checked the disk. To rule out hardware issues just backup to a different...

I didn't see your last message before I posted my previous one. The dir command should have listed all your backup files. If it didn't you could just have a...

All the command does is execute the DOS 'dir *.*' to list the files on the directory. If any files appear it means the account (windows userID) SQL server is running under...

Does the server you are restoring onto have access to the shared drive?

In Query Analyser run the following command:

exec master..xp_cmdshell 'dir "\\whse\Drive_I\MyTeam\BACKUP\*.*"'

Otherwise, check the SQL server log to see...

Also, if you are using OLEDB drivers for the connection, the 'ORDER BY' in the SQL can sometimes convert the cursor to be read only. Don't ask me why. Its...

What is the command you are using?

If the database is not in the same folder path on system2 or you have changed the name of the database (its logical name), you will need to use the...

Try executing the stored procedure directly from SQLServer, in Query Analyser. The procedure uses CDO that comes with IIS, which is automatically installed with SQLServer. Check that CDO hasn't been...

A 'quick fix' for a database that has been running for a while since it was last tuned is to run the 'Index Tuning Wizard' tool (under tools-wizards-management in Enterprise Manager)....

Check the settings in the email program on your PC to see if the smtp you specified needs 'Authentication' (ie a user ID and password). If so, I think you...

I agree with Wayne. Get your UDF to return the sum(), then your SQL is very easy:

SELECT [dbo].[rules_Test](acctNo) FROM tblAccount

Regards

Peter

The service packs generally updates various SQLserver files on disk (under folder \program files\Microsoft SQL Server\), various stored procedures in Master and possibly structure changes to the system tables in the...

I have a general question to add to the mix.

I have worked on 10+ database systems in the past and for all the general rule is never build composite keys...

see this useful article by Brian Kelly. It explains all the steps.

http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritysecurityadmins.asp

regards

Peter