My best record are almost two billion of records with IMS(pharma sector).

On the other hand, this works but not very perfectly...

insert into testspaceused

 EXEC SP_MSFOREACHDB 'USE BDGENERAL; EXEC SP_SPACEUSED G03OFIC'

testspaceused is the table above created...

On the other hand, this works but not very perfectly...

insert into testspaceused

 EXEC SP_MSFOREACHDB 'USE BDGENERAL; EXEC SP_SPACEUSED G03OFIC'

testspaceused is the table above created...

I've created this:

CREATE TABLE TESTSPACEUSED (

 FI varchar (60),

 ROWS1 INT,

 rESERVED varchar(20),

 data varchar(20),

 index_size varchar(20),

 unused varchar(30)

) ON [PRIMARY]

GO

And then I tried this statement, obtaining unsuccessful results:

SELECT *

FROM TESTSPACEUSED inner join  (sp_spaceused...

hi SqlBill,

Unfortunately, that doesn't works. I am almost sure that might have any solution for that. Apparently BOL no says nothing about that.

Think, think

Sorry for that. Here you've got it:

CREATE TABLE [dbo].[Via_Peticiones] (

 [CodPeticion] [char] (12) NOT NULL ,

 [Estado] [char] (1) NOT NULL ,

 [Dni] [char] (10) NOT NULL ,

 [Nombre] [varchar] (255) NULL ,

 [EMail] [varchar]...

We had issues when developers were creating temporary tables and TEMPDB and that database own a different collation than source database, which causes a lot of errors.

Finally, they decided...

that finally works properly:

  REVERSE(substring(REVERSE(DATASOURCE),1,charindex('\',REVERSE(DATASOURCE)) -1)) AS F

Thanks to all for your comments.

Yeah, it was just that.

Thanks a lot for your comments Ian.

All the best,

I work out, finally I've founded the answer to my issue usign REVERSE and CHARINDEX functions:

 REVERSE(substring(REVERSE(DATASOURCE),1,charindex('\',REVERSE(DATASOURCE)) -1))

It's unbelievable. As time goes by we have got less gadgets, machines all over our homes.. I am trying to convice my wife to have a big laptop for see...

Could you please kindly to post DDL statements in order to have a very comprehensive view of such issue?

Thanks