Yes, the function on it's own works fine, when the ID is passed as a parameter.

Scott.

Spot on. That was the issue. The missing table has a different schema_id other than the default "1" for dbo. 
My script is not filtering on "schema_id". 

Hi Lowell,

Sorry for late reply on this. I ran your scripts and got this output. Probably the same as your output. What else could I do to make...

Lowell,

There is only one Exec.

Declare @command varchar (max)
SELECT @command = s.Colzs
   FROM(SELECT
     Colzs = STUFF((SELECT...

Hi Lowell,
After the change, I am getting the same error. I removed Set command before Declare too. 

Vin

Thank you Adi. 

I can't change the column type. So this solution is fine for me. Insrtead of varchar(max) I only need max 25 characters.

Vinay

This topic is in the wrong section. I forgot to mention the database is on SQL 2008 R2.

I have asked webmaster to move the topic.

Thank you,

Thank you, Eirikur.

I had a look at Ola's scripts and it does not cover "other" elements of SQL databases to backup.

User and System Databases are being backup daily,...

Go To Flat File Connection Manager and then Advanced.

Increase the column size there. And then do Save All.

Also ensure you have a Text Qualifier. Generally doubleQuotes.

it's possible...

Hi Adi,

The clause Option(recompile) works well.

Execution time 59 seconds;

and 54 seconds for constant values supplied.

Before Option(recompile), it was "2min 31 sec."

I will also use Stored Procedure. That's a...

Hello John,

Here is the table structure:

CREATE TABLE [dbo].[tableA](

[Id] [int] IDENTITY(1,1) NOT NULL,

[EmailAddress] [varchar](60) NULL,

[event_Type] [varchar](25) NOT NULL,

[MessageName] [varchar](255) NULL,

[DeliveryDate] [datetime] NULL,

[event_Date] [datetime] NULL,

[BroadcastId] [varchar](25) NULL,

[subjectline] [varchar](100) NULL,

[firstname] [varchar](50) NULL,

[surname]...

Gail,

I can't tell if the XACT_ABORT is On or Off.

But the way to replicate auto rollback is this way:

select * into #temptable

from basetable

select * from #temptable

begin tran

...