Comments by mubarakahmad

mubarakahmad 29-Apr-13 3:48am View

this after little changing just returns max id i think there should be a count on the max ids? and a where clause

mubarakahmad 23-Nov-12 8:38am View

i used to get "The CLR has been unable to transition from COM context 0x.. to COM
context 0x.. for 60 seconds. The thread that owns the destination
context/apartment is most likely either doing a non pumping wait or
processing a very long running operation without pumping Windows messages.
This situation generally has a negative performance impact and may even lead
to the application becoming non responsive or memory usage accumulating
continually over time. To avoid this problem, all single threaded apartment
(STA) threads should use pumping wait primitives (such as
CoWaitForMultipleHandles) and routinely pump messages during long running
operations." but i unchecked the context deadlock exception and it did not report again

mubarakahmad 29-Feb-12 9:40am View

i could really use some guidance with this i am using xcode 4.0 on snow leopard . any sort of help would be much appreciated thankyou...

mubarakahmad 29-Feb-12 9:40am View

Deleted

i could really use pointer with this i am using xcode 4.0 on snow leopard . any sort of help would be much appreciated thankyou...

mubarakahmad 15-Jan-12 9:20am View

yes you are right i have fixed it.i moved the data folder to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.. it gave me access denied option. later i went to sql server configuration manager-> services->properties of sqlserver->logon and changed from network services to local services . it fixed my problem and now i can restore my database .thankyou for your help

mubarakahmad 14-Jan-12 15:21pm View

am sorry i failed to understand your point. can you kindly please elaborate?

mubarakahmad 7-Dec-11 21:05pm View

thankyou, i tried that but it didnt work aswell

mubarakahmad 7-Dec-11 20:58pm View

well when i comment out this line SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=C:\MF 240\Excel file\b.xls;IMEX=1;HDR=yes','select [Sub Group Name],[Model],[pagenum] from [Sheet1$]') and run just this select 'page_title' as page_title,'model_name' as model_name,'page_num' as page_num FROM [sqlDb].[dbo].[pages] i can see the columns on execution... so my column names right its something to do with the openrowset line

mubarakahmad 7-Dec-11 20:47pm View

No the database is same i have checked that aswell.

mubarakahmad 7-Dec-11 20:45pm View

yes , i did that the column name is the same.that is what makes it even more annoying :)

Comments by mubarakahmad (Top 10 by date)