Why do you want to return every single field, in every single record, for such a large table?

A clustered index will help if you run a query with a suitable...

Yes it matters (see next para). The triggers will fire as usual, because they are defined at table level. So you need to avoid importing into those tables that will...

Maybe you could create a trigger that would perform the integrity checks that you need on insert, update etc.

So what is the DTS package transferring? Not records, I presume. Why do you want to call triggers when they look after themselves after inserts/updates etc?

You'll have to be a...

This code reproduces the error - could it be the problem?

declare @contact varchar(10)

set @contact = 'abbbbbbbbc '

select substring(@contact,1,charindex(' ',@contact)-1)

Hang on. VARCHAR value 'NULL'?? Suggests that this might work:

select * from tableA

where col5 = 'NULL'

If so, it's not empty - it's a string set to NULL.

The entries are not NULL. What makes you think they are? Are you sure they're not just empty ('')?

Your syntax is fine - and very simple. Try inverting the query

select * from tableA

where col5 is not NULL

and see whether the 'blanks' are returned.

I think that your understanding is wrong this time - NULLs are fine in FK constraints - at least in SQL Server (BOL confirms).

Sounds like the SQL Server service is running under the sys admin account. Find MSSQLServer in Admin Tools / Services and right click - select Properties and then the Log...

There's a very good chance that, even if you do transfer the DTS packages, they won't work on your PC without being 'tweaked'. For someone who is new to SQL...

Not really bizarre - it's not the job of SQL Server to present data, that's what the front-end tools that Ray mentioned are for. SQL Server handles the storage, processing...

I do not understand. This command will work if you execute it directly on the connection that you have created, regardless of your WHERE clause. Whether it gives you the...

When the user clicks save, why not run an UPDATE query instead?

UPDATE article SET Flag = 3 where ArticleID = [ArticleID from form]

Try

select convert(char(12),dateadd(s, 5400, 0),114)

for your conversion question.

Your second question - just use

IF NOT EXISTS (select procedure entry here) CREATE PROCEDURE