When i see my hardware profiles it has undocked profile(currrent) and docked profile in the AS available hardware profiles.

does this effect?

thanks.

how can I create an unique name for table everytime the procedure executed.

Thanks.

The sql query which creates the temp table is a dynalic sql statement and that the reason I have used the global temp table over local temp table.

Thanks.

One more question regarding these temporary tables.

I am creating a temp table in my stored procedure and droping at start of the next execution time.

What happens if two uses try...

I tried the following code and it worked fine. Let me know if it's a correct way of doing it.

IF EXISTS( SELECT * FROM tempdb.dbo.sysobjects WHERE id=(SELECT id FROM tempdb.dbo.sysobjects...

Even this code is not dropping the table.

Thanks.

Is there any system procedure to know the size of the database like we use sp_spaceused to know the size of the table.

Thanks.

One more thing I need to do is that to transfer sql jobs and dts packages associated with this database to the production server from development server.

How can I do...

I am going for backup and restore because I need to copy the data from development server to production box.

Sorry guys I have posted the wrong function.

Following is the correct one.

CREATE FUNCTION fn_get_few_words (

  @stringToSplit varchar(3000),

  @numberOfWords int

)

RETURNS varchar(3000) AS

BEGIN

DECLARE @currentword varchar(3000)

DECLARE @returnstring varchar(3000)

DECLARE @wordcount int

SET...

Sorry guys. AS I was busy with my work I didn't check this forum for last few days.

The following is the procedure I find on the net.

Thanks for all your...

I found an user defined function and it worked really good.

Thanks.

Thank you very much for your help.

Thanks, It worked like a dream.