hi

dont think you can restore the db like this.

hi

Have u done any heavy insert/update operations or any index rebuilding operations. There could be many other reasons for increase in log file size .

use the information_schema.parameters view.

hi

Methods generally used to avoid cursors are

using temporary tables,table data types, other looping syntaxes and implementing a different logic if possible.

In many cases i have seen that using...

hi

keep in mind the following server properties

Cost Threshhold of Parallelism and Max Degree of parallelism.

hi

Try the sysconstraints table.

have figured out what is happening.

hi

I figured out what was happening. MSDTC was not properly configured, I configured it and things started moving.

Thanks anyways

hi

just a guess... have u enabled TCP/IP and NamedPipes protocols for your server.

hi

can u tell us what is the error that u r getting?

try this...

sp_changeobjectowner 'Table1','dbo'

hi

will using a function instead of a procedure help. performance might not be very good though.

Hi

you shud avoid bookmark lookups as much as possible as they can degrade performance while an index seek will imporve performance especially when dealing with a large number of rows.

Again I...

hi

i copied the statements as it is...it seems to be working.

hi

i think the replace function will work here.

ex: i have a string value "value1" and a tab after that which looks like this

"value1     ".  using replace

SELECT REPLACE (value1     ' ...