Actually issue was somthing different.. We have column containing some blank values. So sometime this blank value print on just start of page and then group ends immediately after that...

My function is deleterministic.. I am accessing data from user table inside function and thats the problem (function is true for IsUserData objectproperty)..

So seems I have only option to...

i think this is partially posted :unsure:... actual one is http://www.sqlservercentral.com/Forums/Topic1414885-392-1.aspx

as I understand, you need row and column total in pivot result.. You can this query -

select *

,isnull([1 - Critical],0)+isnull([2 - High],0)+isnull([3 - Medium],0)+isnull([4 - Low],0) Total

from #tmp

pivot(sum(SevCount) for Severity...

Float is approximate data type. do not store the exact values specified for many numbers; they store an extremely close approximation of the value.

more details are available at - http://msdn.microsoft.com/en-in/library/ms187912%28v=sql.105%29.aspx

anyone knows about this issue? 🙁

azdeji (3/28/2012)

----------------------------------------------

my problem is that it not working.

although you have both tables in same server / database, you have to pass values for all procedure parameters (@INSTANCE1, @DATABASE1 etc). don't...

we want to execute mentioned proc daily...

RemoteSql is sql login used by linked server security and it has full/admin access on remote server db.

PS: I had wrongly mentioned OSQL statement and error message above which...

Thanks GSquared..

But we are bulk inserting rows in history table (approx 1 lakh). So if we implement this we need to check row size every time before insertion and which...

Hi,

thanks for reply.

dont know exact reason but sql server service was running under domain user which I have changed to local system account and now its accessible using domain user...

I tried to execute SQL 2008 stored procedure from SQL 2000 linked server but its not working and throwing error 🙁 -

Msg 0, Level 11, State 0, Line 0

A severe...

Yes I have executed DBCC CHECKDB against SQL 2008 and found no error 🙁

It works! 🙂

log backup truncated successfully and now log backup is happening properly.

Thanks Gila Monster for your help.

Yes, full backup and differential backup both happening properly