I think I would consider using calculated columns for Housing Allowance and Income Tax then a View to calc Net Pay as the way calculated columns work Net pay would...

I assume it is DTS Import/Export Wizard. What is the error you get when you run?

Use profiler to monitor all server activiity to see what is running when you get blocked. Also, some coding habits can be a root cause such as running a SELECT...

There is another thread on this somewhere but the gist is this.

Full Backup does not overwrite the transaction log so if you lose a Full backup but have the previous...

This should explain. http://support.microsoft.com/default.aspx?scid=KB;en-us;q244513

I suggest get a larger tape or a second tape drive to keep a mounted tape available.

I would say keep a spare drive handy and for sake of checking the drives condition swap it in the array with another periodically. As long as you can get...

It is ugly and you might have to fix a bit since I couldn't test but this should do it with the need for the case, but the case still...

To the best of my knowledge all index and unique constraints automatically create stats. What do you hope to accomplish as stats are used to determine best index canidates when...

Just to make sure I understand, where are you executing this from. If from your local machine remote to the SQL Server then you need to keep in mind QA...

No ideas but look for a .dmp file and check for a possible log event in Event Viewer or SQL Server ogs for more detail. No details on that error...

One thing that may catch you is if the Transaction log is not cleared before the full backup the time will take more each day as full backup backsup the...

If you normally work with access look at te potential for scaling to MSDE (SQL Server lite) and demonstrate the beniffits that way in your current position. This will give...

Take a look here http://support.microsoft.com/default.aspx?scid=KB;en-us;q237398

Alright Steve I agree Crystal sucks but if done properly can be quite usefull but I suggest find someone who works with it all the time (sorry I don't volunteer...

SQLPlus is the equivilant of QA to Oracle. If you can use SQLPlus and make a single connection then do a select from each of the 37 tables then you...