Just as a matter of interest SQLBill do you use the straight SQL Backup or do you use a tool such as SQL Litespeed?

Why not

SELECT CAST(CAST(GETDATE() AS INT) AS DATETIME)

The advice to backup the database after doing a truncate_only is because truncate_only removes checkpointed transactions from the log and therefore you have lost your ability to restore to a...

Sam, I'm with you on this but I would say there is one over-riding cause of all project failures and that is a break-down in communication.

It doesn't matter if it...

I've lost count of the number of times I've sat through a recording of a TV show, adverts and all and then had either one of two thoughts

a) Hang on...

Guys, in the UK it has been illegal to tape records (remember those) and CDs for as long as I can remember. It is an entirely toothless law because...

Off the top of my head (I don't have SQL at home) I'm not sure if TEXT and NTEXT are allowed as output parameters but the general format is

CREATE PROC...

Assuming that ISQL on Sybase is the equivalent of OSQL in SQL Server then the easiest way of using a batch file to create tables is to create a text...

Or even

SELECT name FROM syscolumns WHERE id=object_id('dbo.TBL1')

Wrap up your code in a Try, Catch block

I need a lot more information to give anything other than general advice.

Is your data access via stored procedures?

Are there indexes where they should be on the fields?

What is the...

Does the account used for the MSSQLSERVER service have "Lock Pages In Memory" privileges. Even if the account is an administrator it won't have these by default.

SQL...

If you are going to do searches within an ASP page then my approach would be to :

• create a VIEW for the SELECT and FROM part of your query
• Build up...

Well try changing the WHERE clause to

WHERE Name LIKE 'View[0-9]%'

The firewall admins asked me what I would recommend.