Thanks to all.

I go through the link , now my issue with the decimal data type

SELECT col1 FROM table2

WHERE col2 > 9999999999.99999

OR col1 < -9999999999.99999

In this script col1 is...

what is col1 in this script??

so i need to change the script as follow

EXEC (@command); replace with Print(@command); right??

but the server language is spanish ??

Sorry Gila,

i am not getting you .. can you please explain more ...

I need to execute the script manually or ???

anthony.green (1/2/2013)

---

Check sys.indexes in every database where the name has -

IF @frag < 30.0

SET @command = N''ALTER INDEX ['' + @indexname + N''] ON ['' +@DBname+ N''].[''+ @schemaname +...

hi Thanks for the quick response ..

I searched alldatabases with the below script , but i didnt find any indexes names with -

select * from sys.indexes where name...

i need to change the script in the below lines

IF @frag < 30.0

SET @command = N''ALTER INDEX...

hi ,

we are using the same script in all servers ,but wea re not seeing any issues on other servers expect this server ..

The issue was resolved by other team , but i dont know how to resolved this ??

Can you have any inputs how to resolve this issue?

in the principal server

1....

Thanks for the response

I got the below error from mirror at the same time from sql error log :

Error: 1204, Severity: 19, State: 4.

The instance of the...

hi ,

I got the below error message from the log

Message

, the remote mirroring partner

for database XXXXXXXXX, encountered error 1204, status 4, severity 19.

Database mirroring has been suspended....

Hi Anthony,

Thanks for the quick response ..

I don't want the error message generated by that job failure . I want only the job name with the failure alert...

hi Guys,

Can i have any update on this...........

hi Gila,

Thans for the update .

This weekend also we had the same problem .

By using the script we are taking the backups,no maintenance plans

The diff...

Hi All,

Thanks for your valuable infrmation.

we are not using maintenance plan . We created a job with backup database script for all user databases to run every...