My SQL Script File is as follows

use master

go

------------------------------------------------------------------------------------

-- If the backup device already exists then drop it and recreate it

------------------------------------------------------------------------------------

IF EXISTS(SELECT 1 FROM sysdevices WHERE name='epos_Backup')

exec sp_dropdevice 'epos_Backup'

GO

exec sp_addumpdevice 'disk','epos_Backup','D:\Epos\BACKUP\DW_EPOS.BAK'

GO

--...

The roles that can DROP a table are DBO, DDL_Admin, obviously the SA login and other members of the SysAdmin role.

Provided your user is not a member of such roles...

I think you also need to consider the @@DATEFIRST setting which determines which day of the week is considered DAY 1.

For example US English Sunday is Day 7. For...

Innovasys DocumentX and Apex SQL Doc both do it.

If you are only interested in SQL the Apex SQL Doc is the most detailed.

If you want something that also does Access,...

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...