Actually, what I think what is being looked for is this:

create table dbo.Test1 (refNo varchar(10))

insert into dbo.Test1 (refNo) values ('ABC-0')

insert into dbo.Test1 (refNo) values ('ABC-1')

insert into dbo.Test1 (refNo) values ('XYZ-0')

insert...

Looking at BOL, dbcc shrinkfile truncate_only, releases unused space in the log file to the operating system, shrinking the physical size of the transaction log.

You may want to look at...

Are you talking about the physical size of the log files, or the fact that inactive log entries are not truncated during the backup?  Full and Differential backups do not...

Glad it worked!

I'm new to SSIS, but if it is like DTS in SQL Server 2000, when you run it manually from your desktop system, it sees the mapped drive.  When run...

Not really sure but I think it is a simple case of missing comma's.  Compare this insert to the original and let us know.

     INSERT INTO my_table (comments,

                                       sr_status,

                                       sr_notes_count,

                                      ...

Not too sure from your sql command, but I would guess you are appending your differential backups to the same file.  This will cause your differential backup file to grow...

It means that enterpriselistid must unique in every row.  Sounds like you are trying to insert a new row with an enterpriselistid that already exists in the database.

hth

try this

declare @vchar vchar(20)

set @vchar = '1458.00'

select cast(substring(@vchar, 1, patindex('%.%', @vchar) - 1) as int)

hth

I come up with 1152 characters in your option string.

First, you can have a multiline constant, try this and see:

declare @options nvarchar(4000)

set

@options='replace,

move ''CorpProd_Data1'' to ''F:\MSSQL\Data\Corporate_User_Testing\Corporate_User_Testing_Primary.mdf'',

move ''CorpProd_Data2'' to ''F:\MSSQL\Data\Corporate_User_Testing\Corporate_User_Testing_Data1.ndf'',

move ''CorpProd_Data3'' to ''F:\MSSQL\Data\Corporate_User_Testing\Corporate_User_Testing_Data2.ndf'',

move ''CorpProd_Data4'' to ''F:\MSSQL\Data\Corporate_User_Testing\Corporate_User_Testing_Data3.ndf'',...

Careful with my code above, I just noticed the inner on the inner join typed twice!

Reformatted your code and found what I think is the problem inthe subquery at the end.  Check it out:

select

    p.vendor_code,

    p.vendor_name,

    p.vendor_addr_l1,

    p.vendor_addr_l2,

    p.vendor_addr_l3,

    p.vendor_addr_l4,

    p.vendor_addr_l5,

    p.vendor_addr_l6,

    p.vendor_addr_l7,

    p.vendor_addr_l8,

    p.vendor_phone,

   ...

True.  But that also depends on the actual query and what is wanted.  We only see two columns in the query on-line, but what if they wanted to most recent...

I have had this problem with maintenance plans when I have gone in to modify them.  I found I usually had to delete the problem plan and recreate it from...