Thanks but i need to run thru every database on a server. any hints on that?

I also get the error as

 Bulk Insert: Unexpected end-of-file (EOF) encountered in data file. when doinga  bulk insert. any help??

Steve,

Once you turned off parallelism did it impact anything else on that server. Apart from thsi did you do any changes to teh sql code? any help will be greatly...

All the jobs are staggered so that 2 jobs dont run at concurrent time. The job history shows up as -

The job failed.  The Job was invoked by Schedule 778...

Thanks,I got it from BOL.

SQL Server can have as many as two billion tables per database and 1,024 columns per table. The number of rows and total size of the...

Heres the SQL Script

SELECT DISTINCT

 PROD_KEY,

 CAST(1 AS BIT) AS DISPLAY_FLAG,

 RIGHT(PROD_KEY, 7) AS PROD_ID,

 PROD_NM,

 LEFT('XXXXXXX-CCCC', 18) AS XX_MKT_NM,

 USC_CD,

 ATC_CD,

 CASE WHEN CORP_NM = 'UNKNOWN' THEN MFR_NM ELSE CORP_NM END as corp_nm,

 NULL AS PROD_FORM_CD,

 NULL AS...

Heres what the log generates. This is the log that i created in the maint plan.

(null)

SQLMAINT.EXE Process Exit Code: 1 (Failed)                                                                                                                                                                                                                    

(null)

(null)

Emailing report to operator 'SQLDBA'                                                                                                                                                                                                                          

(null)

Msg 22029, Sev...

Greg,

the job has only 1 step which is to take the backup of the database. I checked the history too and heres what it says

The job failed.  The Job was invoked...

I am also a  bit surprised that these jobs which are setup to take the backups , the backup is successfully created but job shows a failed status with above...

What i am trying to get from a table is all rows of a specific field say name which has any character with ascii>128 . Any script that can help...

Steve,

Not sure if I am getting you right

- The server got rebooted as i wasnt able to get onto the m/c also. It wasnt just sql server .

If, Had...

All i tried was a backup tran tempdb with no_log. Also the log shows msg as

Using 'dbghelp.dll' version '4.0.5'

*Dump thread - spid = 61, PSS = 0x52237290, EC =...

Well, thanks for our thoughts though. I have seen people using scripts with no problems while registering them in EM.specially if all servers have similar settings.

Yes dml will be againt the same table and the same transaction can be run by multiple users. Thanks

Thanks Allen,

Can this lock be used in insert/update statements. If so can you pl jott down the consequences/impact of this too.

Thanks