Maybe an unfinished transaction too...

It concatenates the columns names for each table in the db and presents it in a single row. You'll have to do something like this for the drivers, then...

You need something like this :

IF Object_id('ListTableColumns') > 0

DROP FUNCTION ListTableColumns

GO

CREATE FUNCTION dbo.ListTableColumns (@TableID as int)

RETURNS varchar(8000)

AS

BEGIN

Declare @Items as varchar(8000)

SET @Items = ''

SELECT

@Items = @Items + C.Name + ',...

Wrong order>>>

1 - Validate with the application that the order is valid.

2 - (assuming batch operation). Revalidate that everything is fine.

3 - Execute the tasks without error.

Takes dynamic sql for this task. There's just no way around that. I usually do that stuff in vb >>

first loop

Select Name from dbo.SysObjects where XType = 'U'...

Thanx for the info... However I'm glad I won't be needing to use it someday .

I'll take your word for it... I'd still try and validate what I insert in my db and correct the problems, but I don't know why he's doing that so...

Are you sure that tis is working.. this seems to give the size of the column name???

And I've already told him what to do to expose that bad data in his table and what to look for to fix it if it's only a date format.

Am...

No open enterprise manager, go into the right database, then in view, create a new view.

PASTE the old working query.

SAVE

Add the new table and use the interface to add the...

If col1 is a datetime column, that'll ALWAYS fail. That's the error you are getting.

Go with a query designer. It'll be easier for you to build this. (create a new view and add the tables and there relationships, or you may want to...

Welcome to my world .

Were you able to fix the problem with my info??

Here's a working exemple :

SELECT O.XType

, O.name

FROM dbo.SysObjects O

WHERE ID IN (SELECT TOP 5 ID FROM dbo.SysObjects O2 WHERE O2.XType = O.XType order by O2.Name)

ORDER BY O.XType, O.Name

The cursor...

I'm pretty sure it'll be usefull (unless maybe you can have some other characters that throw this off)???.