gail,

we can also get the idea from the service manager

(Control Panel-->administrative tool), if i am not wrong.......

Cheers!

Sandy.

Renu, good question..:)

rinu, since how long you are using Sql server?

before using it just go through the Try-Catch Concepts in Sql Server 2005, because it has some limitation, I personally prefer to use custom error handling method in SQL Server...

Hi Lester Vincent,

Its very simple..

After Executing the stored proc by below parameter:

Exec proc_GetRowCount_Dynamic 'Temp', 'status' , 'status = 1'

your temp query will be like this:

SELECT COUNT(status) FROM Temp WHERE status...

Shiv,

please correct this query:

correct query:

you missed the "$" symbol...after Sheet1..:)

Cheers!

Sandy.

Shiv,

hope you got the solution...:)

Cheers!

Sandy.

hi,

yisaaacs

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

I have a table that contains an XML column with a huge xml string in it.

Problem is a normal 'select * from ' takes about 8mins to process.

I writing a...

rinu,

Nice script...:),

you can send your article to this forum.

so if you have any new and different idea then you make it one article and post in this forum. So...

you can use this also...

Cheers!

Sandy.

Gila

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

I had that exact situation a few months back. A table that the system architect designed had 5 different models in it (each in a different column). I suggested that...

Shiv,

I think, you have to check your Excel sheet.

I mean to say 'Sheet1' is present or not..

or it present in different name, then specified it in your query..

Cheers!

Sandy.

Abhijit,

1st table Index hints:

CREATE TABLE dbo.ParentTable (

ParentCol INT Primary Key,

Col2 INT,

Col3...

umailedit,

I have just gone through this links, and I think for the above DB design situation its not required....

Yes, you can use it, but some cases it may raise issue in future..

I can say, Its purely depends on the application requirements..

Cheers!

Sandy.

hi,

why u need more sp, one sp is enough......:P

you can simple use this..

Cheers!

Sandy.