If you have a unique constraint on a column, it doesn't matter what you do with triggers, WHERE clauses and so on - you can still only have one NULL....

George

Another way round it might be to open the file in Excel, format the columns appropriately and then save it and import from that. You could write a VB...

Jeff

Yes, I did think about asking why he posted in this forum, but it such things seem to happen so much these days that I don't usually bother!

John

George

I think the problem is that 1,400.00 is actually a number, which is being sent as text because it has a "," as a thousands separator. I would import...

Something like this. The INSERT statement will only work in 2008.

CREATE TABLE #Docs (DocNo int, Line char(1), LStatus varchar(2))

INSERT INTO #Docs VALUES

(1, 'A', 'QA'),

(1, 'B', 'QV'),

(1, 'C', 'O'),

(1,...

Yes, that's the old-style join syntax which is deprecated for inner joins, and obsolete for outer joins. Goes something like this

SELECT * FROM Table1 t1 JOIN Table2 t2

ON t1.ID...

For the first one, look in Job Activity Monitor. For the second, you'll need to write a query against sysjobhistory (like I think you would also in SQL Server...

I don't think you can. But read the ALTER Login topic in Books Online - you may or may not be able to find a way round it by...

From Books Online:

CHECK_POLICY = { ON | OFF }

Applies only to SQL Server logins. Specifies that the Windows password policies of the computer on which SQL Server is running...

Flodpanter (11/26/2010)

---

This Insert will create 100 new records all with unique identity values in the table dbo.table_referencing_project. Now I have to copy all data that references the dbo.table_referencing_project table. These...

It sounds as if there's something in Visual Studio 2008 or Integration Services 2008 that is insisting on a SQL Server 2008 database. What is the task that is...

First off, you need a precedence constraint between Export SBISCLPRICELIST and Rename Files.

Please will you double-click on the precedence constraint between Rename Files and FTP Each File and post a...

I'm not...

Lindsay

Is the database in question significantly larger than the others? Have you done a RESTORE VERIFYONLY on the backup file? Is this done as part of the backup...

Lindsay

Go to a command prompt and type net helpmsg 64. This will tell you what the error message means. Looks like your network is somewhat flaky.

John