Hi ChrisM@Work,

I changed my query and verified(made some modifications) the indexes as the others said. So i could avoid the table spool, and i have the response in ...

Hi ChrisM@Work,

I think, i didn't really understand howto and why replace with ROW_NUMBER() . Can you just explain a bit?

thakns really much. It is a really good explication.

may be it helps you :

declare @value int

declare @sql varchar(200)

set @sql= 'select * from tablename where date=getdate()-'+@value+

exec(@sql)

Hi everyone..

I have a query that gets the 30 days back...

At the end i had the success. Here's the result :

DECLARE @STRING1 VARCHAR(500)

declare @db varchar(100)

DECLARE @Flag INT

SET @Flag = 0

WHILE @Flag<22

BEGIN

select @db=name from sysdatabases where name like '%outbound%'

SET...

Thanks you two. It is better now but i still get an error which is different.

DECLARE @STRING1 VARCHAR(500)

DECLARE @STRING2 VARCHAR(500)

declare @db varchar(100)

DECLARE @Flag INT

SET @Flag = 0

WHILE @Flag<2

BEGIN

select @db=name from...

Actually sysdatabeses does not cause a problem.

i get the error from this part as a syntax error :

SET @string ='use '+@db+' DISABLE TRIGGER tr_ListeGroups_in_Archivage_ListeGroups on'+ @db

Msg 102, Niveau 15, État 1,...

Yes i looked. I didn't find something so different. Here's what i saw :

BackupMedium::ReportIoError: write failure on backup device '\\XX.bak'. Operating system error 1130(error not found).

any ideas ?

Thanks but i couldn't find it in profiler? Can you explain where can i fin it exactly?

Hi,

I found the error, maybe there will be other people who want to learn it. Actually it is an error of SQL Server 2005. When you script your trace...

Hi thanks for the reply . Here's the script.

/****************************************************/

/* Created by: SQL Server Profiler 2005 */

/* Date:...

Thanks really much it worked, just i had to delete the "+" near the command MOVE .

SET @SQL =

' RESTORE DATABASE ' +...

Thanks for your reply it seemed me logical but when i try it it gives always the syntax error

third line. The line Move + ... I will try to...

Hi,

I'm sorry occupying you with that problem, actually i found the solution. So i write it may be someone will need it.

When i run the job by hand...

i think a good summary. for the second one i can add something. Imagine that you have 200 databases but they have different characteristics so you have to classify them....