SQL Server only allows 1,024 columns per table.

Mr. Celko hasn't posted today and I am biting my tongue from giving snarky replies to others. Just wanted to tell someone to read the readme files.

SQLRNNR (9/18/2012)

---

jasona.work (9/18/2012)

---

I know the feeling, some of the people I work...

Sometimes you just want to give a snarky reply, but then you bite your tongue and wait.

Have you tried this on the new server?

SELECT @sMysql = 'bcp "SELECT sOutput FROM MYDATABASE.dbo.VPOSITIVEPAY" queryout ' + @sFilePath + @sFileName + ' -T -c'

Something like this should work:

declare @idxname sysname = 'idx_DatePosted';

declare @SQLCmd varchar(max);

select @SQLCmd = stuff((

select 'union all' + char(13) + char(10) + 'select ''' + db.name + ''' as DatabaseName, object_name(idx.object_id)...

Looks like a custom EAV using multiple tables instead of a single table.

SQL Server 2008 and 2008R2 have a major revision number of 10 and SQL Server 2012 has a major revision number of 11. Does that help?

paul.knibbs (9/18/2012)

---

Is that query in the OP transcribed correctly? Because you don't seem to have enclosed the BX-00006767 value in quotes, which means SQL server isn't going to interpret it...

Think of a parking garage (disk) and parking slot numbers (identity,...

I don't know since the following runs with no problems for me:

create table dbo.table1 (

Field1 varchar(30),

Field2 varchar(30));

go

insert into dbo.table1

values

...

You also need to verify that you aren't using any Enterprise Only features. Sorry, don't remember exactly how to do that of the top of my head.

Basically, yes. There are ways around it but I don't...

adonetok (9/17/2012)

---

There are two tables: ORDER1(ORDERID, DATE) and ORDER2(ORDERID, CITY)

How to code to combine two tables as query which will including all records in ORDER1 and ORDER2?

(ORDERID, DATE, CITY)

(Can not...

The system view sys.indexes in each database.