Best diagnone i have ever seen. No one can beet this..............

Thumbs up............Prakash

Prakash

All the discussions above based on the assumption that each raid array is a saperate one. Here the read write calculation is true base on the read/write heads available. Normally...

there is no direct way to do this, what you can do is select into a temp table, drop orig table and while select into orig table back from...

Just use the shortcut for the erwin path where erwin installed and open the document.

Erwin gives one registry error but it opened and you can see the document even erwin...

I had faced the same problem and find out the reasons.....

This problem comes when doing big updates and the procedure go for a toss. Here's the steps I am using...

This is a known problem when using roles, so use sp_addalias to give somebody dbo rights

Cheers,

Prakash

Thanks Antares,

Whai I am interested in is to know why it happened and how to change it back to user type

Prakash

There are basically two ways to process data from procedure:

SELECT A.*

FROM OPENROWSET('SQLOLEDB','HBDWDB1';'MON2ITOR';'MON2ITOR',

'EXEC CAPMANUAT.DBO.spname ') AS A

or

drop table testt

CREATe TABLE testt(

name varchar (200),

rows varchar (200),

reserved varchar (200),

data varchar (200),

index_size...

select user_name() will give you username and other details should be given by ur application only no way to capture password

Prakash

You can use master..xp_cmdshell to fire a command or a batch file now with the help of cmd mapping commands you can reach that file.

The output of any command can...

I remove the where clause also from the query....

Prakash

DECLARE @V_WIRE_CENTER INT

SELECT

A.WIRE_CENTER,

A.WIRE_CENTER_NAME,

A.TERMINAL_NAME,

STREET_NUM,

STREET_NAME,

UNIT,

FLOOR,

BUILDING,

A.ID,

LIVING_UNIT_ID,

COMMUNITY,

STATE_CD

FROM LEAD_SEQ_LU_ADDRESS A

LEFT OUTER JOIN LEAD_SEQ_TAPER_DA B

ON A.TERMINAL_NAME=B.TERMINAL_NAME AND A.WIRE_CENTER=B.WIRE_CENTER

AND A.WIRE_CENTER=@V_WIRE_CENTER

AND B.TERMINAL_NAME...

If your application is using ado to fireb the commands then set the commandtimeout property to 0.

Prakash

Try this....

SELECT year(ShippedDate) AS Year, month(ShippedDate) AS Month, Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal

FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID

Order by year(ShippedDate) ,month(ShippedDate)

COMPUTE sum("Order Subtotals".Subtotal)...

Product number 965004876 has the largest stock but order volume is 0 in this case????

Prakash