i have gone through this link.

but the problem is i don't want to work with registry keys on the

server.One wrong step and the whole system can be down.

Any more help...

Is there any method so that my program which uses Truncate table command under a

DBUser and DBRole can work

I got the solution.

We can get the number of columns by usifn the below line of code.

SELECT COUNT(*) FROM tempdb.dbo.syscolumns WHERE [id] = object_id('tempdb.dbo.#T')

Thanks David this was really a nice reply.!It worked

Hi amish i tried doing the below statements i am not able to get the results

CREATE tABLE #T

(

A int,

b int

)

select * from #T

Insert...

yes we can do a loop.

But if My number table is #Number table 'a # table in stored procedure'

Then how can i find the loop termination value.i.e till how many...

Can we find total number of columns of a #Table in side a stored procedure

Thanks David!

Thanks a lot this works fine

Thanks a lot it worked!

Thanks,Let me have alook on the link u send me.

I have another issue i want the top header to be populated in a table.

If we dio it from below query...

If we convert it into csv also it doesn't come.....

Please ignore the csv part of the aboove question.

I will again retype the question

My question is :-

Hi i have a...

Thanks for the reply but my data base is very compalex it has around

18 tables with almost 20- 25 excel sheets.

How about DTS can we perform the jobs?

Thanks Paul and steve.

I will place the same question In DTS section ion order to get some more expert advice.

Thanks aPaul and steve.

I will place the same question In DTS section ion order to get some more expert advice.