There is no way to know this unless your have started the trace.

Hey I got the sollution of your problem.

Converting the whole string to VARCHAR(MAX) doesn't solve the problem, if your string is longer than 8000 characters. You have to convert...

This is consistancy error. You just try with Index rebuid. It should solve the problem.

Best Regards

Nitin

Hi,

Windows will not use all 4GB RAM, untill you enable the \3G or \PAE.

In your case you can.

>> Enable the \3GB or \PAE in OS http://www.microsoft.com/whdc/system/platform/server/PAE/PAEdrv.mspx

If you...

Hi,

Have you tried DBCC DBREINDEX ?

Best Regards

Nitin

http://www.enlinkURL.com

Hi

One way is, create script for each job using management studio one by one. And second is, you can write t-SQL script which quries dbo.sysjobs, dbo.sysjobschedules and dbo.sysjobsteps ...

Hi Santhosh,

Try this

SELECT

ee.selId,

ee.Name,

e.Sal,

ee.CumSal

FROM employee_san e

INNER JOIN

(

SELECT Name, MAX(id) selId, SUM(Sal) CumSal

FROM employee_san

GROUP BY name

) AS ee ON e.id = ee.SelId

ORDER BY e.Sal

Hope...

Hi,

Write whole command in single line, remove line break(s) from the parameter of xp_cmpshell procedure

Best Regards

Nitin

http://www.enlinkURL.com

It looks, there is nothing wrong with your script. Have tried to store your output XML in file using management studio? Run your script from management studio and ...

Hi,

Run DBCC DBREINDEX for your table and then try. 700K are not too much records to take 30 min. There must be some corruption in Index or Data pages. Try...

Hi,

You can create dynamic query for PIVOT and then run it using sp_executesql.

Best Regards

Nitin

http://www.enlinkURL.com

Hi Jung,

I think GilaMonster has given the exellent sollution. But I would like to add something more here.

You also user CASE statement inplace of OR condition.

For example...

Consumer_SSN = (CASE WHEN...

Could you pls post your script to generate XML and conversion to NVARCHAR(MAX)?

If you wish to have lists in HTML format you can use my script

http://www.codeproject.com/KB/database/SQL_DB_DOCUMENTATION.aspx

This script generates HTML report of the database objects. You can edit this script to get...

Hi Simon,

Can you pls post the more details?...

like

-database size of each database you are trying to backed up..

-space availabale on all internal hard drive where...