Hello,

Varchar should be Okay.

I think the use of a Derived-Column like the one detailed in the MSDN thread would be the permanent solution.

Regards,

John Marsh

Hello again,

It probably is the date format that is causing the problem.

If it is a one off then you could manually fix the incoming data before trying the load again.

If...

Hello,

The point to notice would be “The value could not be converted because of a potential loss of data”.

So it is to do with the data that you are trying...

Hello,

Would something along these lines get the result that you want:-

Declare @plz numeric(4,0)

Select @plz = 1213

Select

id

From

MyTable

Where

(@plz >= plz_from) And

(@plz <= plz_to)

Regards,

John Marsh

PS: You could also code the Where clause as:...

Hello,

In your second example, Distinct applies to the whole record.

To quote BOL: “The DISTINCT keyword eliminates duplicate rows from the results of a SELECT statement”

Regards,

John Marsh

Hello,

To restore the System Databases you need to have the same Build as the originating server.

Please see the following KB article:-

http://support.microsoft.com/kb/264474

Regards,

John Marsh

Hello again,

As far as I am aware, the size of a Table Variables is only restricted by the amount of available storage, but you would never want to create one...

Hello,

Try executing an sp_who2 at them time when a “freeze” occurs and look if there are any sessions blocking each other.

Also, do you have any entries in either the...

Hello,

May be take a look at these articles:-

http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html

http://blogs.msdn.com/sqlserverstorageengine/archive/2008/03/30/sql-server-table-variable-vs-local-temporary-table.aspx

Regards,

John Marsh

Hello,

The main question is what has changed since the time that the Application used to work?

If you don’t know then there are a few things to check:-

1) Is there a...

Hello,

1) Use the Alter Table statement to add the new columns. This is the example given in BOL (Books Online):-

ALTER TABLE doc_exa ADD column_b VARCHAR(20) NULL

GO

2) Use an Update statement...

Hello,

You could try the DBCC command and see if it reports anything e.g. DBCC SHRINKFILE (logfilename, 1000) would try to shrink it to 1GB.

Regards,

John Marsh

Hello,

May be this article will help: http://www.builderau.com.au/program/sqlserver/soa/Help-My-SQL-Server-Log-File-is-too-big-/0,339028455,339292404,00.htm

Regards,

John Marsh

Hello,

Did you already run a DBCC CHECKTABLE on the corrupt table?

Are there any dependencies on the table that need to be dropped first?

Assuming not, then what error do you get...

Hello,

I had just posted this link to another thread, but may be it will help you as well, if you are interested in the DBA side of SQL Server: