Hi Kevin

Thanks for your reply, its doing nothing but in the event log its written below

Fault bucket , type 0

Event Name: CLR20r3

Response: Not available

Cab Id: 0

Problem signature:

P1: myservice.exe

Hi

Is your problem resolved, if yes can you please share the solution i am under same situation now

Thanks

Tweaked a bit to suit my requirement and it worked. Thank you Luis Cazares

Thank you for the quick reply. Yes B is the parent of C. The level column should populate in a view/proc dynamically. I achieved using multiple queries for each level,...

I used "_0x0044", then it is taking column delimiter as "Mixed" and all the columns are considering as one column. This is not only the migration. I have created a...

I agree with you, it used to work, recently we have added a column to the temp table in prod env, then it is giving the exception, will work on...

Yes, actually the inner procedure is inserting the procedure1 output into a temporary table 1 and again the procedure2 is trying to insert the resultset into temporary table 2, so...

Hi

Thanks for your reply, yes RAISERROR statement is there at that particular statement but how can i overcome this issue

Thanks

John

Thanks for your quick replies, nice article shared by Alan.B, yes obsolutely it depends, now we are developing a new database just wanted to check going forward (if data...

Yeah, Thanks. it's worked,we should change the server name.

Thanks for sharing.

Hi

I am trying to auto dump the database, as i was ended up with the below error, can you please advise on this.

The following exception was thrown when trying to...

yes i tried the same as this. if i try it from command prompt it is ending up with an error

HResult 0x35, Level 16, State 1

Named Pipes Provider: Could...

Thanks for your reply, I have tried it but no joy, i just wondering do we have anything to do with windows authentication/permissions?

i have give as below

SQLCMD -S servername -U...

Thank you very much, it is working.

Thanks i did not configured the variable correctly but now it works

Thanks for your reply

Regards

venky