One more question if you do not mind....

I have a Dell Server which as one SQL Server 2000 instance and three SQl Server 2005 named instances.

The OS is W2k3 32bits.

I...

Yap, problem solved.

Thank you

Job Code:

declare @NumRF as varchar(10)

declare @unc as varchar(500)

declare @srvname as varchar (100)

declare @date as varchar(25)

Declare @Nome as varchar(50)

DECLARE Backups CURSOR FOR

SELECT name from sys.databases where name <> 'tempdb'...

If i try to make backup to other databases that are not the system databases, the same error happens:

Executed as user: dbo. ...B', file 'DTBaseNET_Data' on file 1. [SQLSTATE 01000]...

Thank you very much guys

In SQL server 2000 i can do like this:

if not exists (select * from syscolumns where name ='dt_cadastramento')

begin

alter statement here

end

correct?

I am sorry. It's in SQL Server 2000 not in 2005...

My mistake (the post is in the rong place) 🙁

I try with BCP and the same happens (errors):

declare @teste varchar(8000)

set @teste =(

select min ('insert into temporaria values ('''+ convert(varchar,a.datah,120)) + ''',', ''''+b.rgc+''') GO'

from

(select datah,codctb from h_contribuintesest...

Because i want to generate a file like this:

Insert into ....... values () GO

Insert into ........ values () GO

And when i try to execute this query from inside the bulk...

This is my code (it runs well):

select min ('insert into temporaria values ('''+ convert(varchar,a.datah,120)) + ''',', ''''+b.rgc+''') GO'

from

(select datah,codctb from h_contribuintesest

union

select datah,codctb from h_contribuinteInst

union

select datah,codctb...

The problem is not with the query...

If i execute the query, it runs well.

The problem is when o try to save the results to a txt file

I am trying like this:

use sgct

declare @var1 as varchar(8000)

set @var1 = (

select min ('insert into temporaria values ('''+ convert(varchar,a.datah,120)) + ''',', ''''+b.rgc+''') GO'

from

(select datah,codctb from h_contribuintesest

union...

what about numbers?

I don't want that names having number appear in the query results pan.

i.e - Pedro2

Pedro

Only want Pedro

WHERE ColumnName LIKE '% %' is another;

Thank you

Thank you very much for the help.