Still no joy.

I also checked/updated the following, from SQL Server Configuration Manager:

SQL Server 2005 Network Configuration > Protocols for SQLEXPRESS

Shared Memory - Enabled

TCP/IP - Enabled (updated because it...

Still a time out error though...

Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents...

yep

I enabled it, and, restarted the SQL Service and SQL Service Browser, but no joy.

Cheers

Error message reads:

The data in row 11 was not committed.

Error source: .NET SqlClient Data Provider.

Error message: Arithmetic overflow error converting numeric to data type numeric. The statement has been...

The IDENTITY column worked fine, I asked for information. Thanks for the advice.

Indeed, thx

🙂

Well this is the CommandText passed from Visual Studio. Any idea how to get the SQL statement from Management Studio, if at all possible?

"INSERT INTO [teamwiki].[dbo].[task]\r ...

Thanks. As a matter of fact I had to re-create the table from scratch. Any idea if this feature is available in Server 2008?

What is incorrect with the syntax of this statement?

ALTER TABLE [application_db].[dbo].[task]

ALTER COLUMN taskID numeric identity (2,0);

:w00t:

Error:

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'identity'.

Related links:

http://technet.microsoft.com/en-us/library/ms190273.aspx...

Yes. What is the default locking behaviour for SQL Server 2005 Express Edition (i.e. optimistic, pessimistic, opportunistic)?

How do I change it? Any links to some...

Thanks. In my case I'm not worried about multiple inserts at the moment, but it's a good issue.

At the moment the database has to be updateable, so...

I need to install SQL Server Enterprise 2005 because it's a pre-requisite for Sharepoint 2007 Reporting Services. The problem is that it is not supported on Windows Server 2008.

SQL...

Well, initially the autorun didn't do anything, so I ran the setup program. Any suggestions on getting around it?

- using SQL Server 2005 with reporting services?

-...