if thats so, then its about time.

thanks man

in time u will get all the syntax u need, but u cant memorize them all, i know T-SQL and PL\SQL and some times a title confusion could happen like...

hay every one.

i have been preparing for the test 70-431 and i have been reading about it on the net but i need to know if i need to...

thanks this is perfect.

one last question

dose it make a difference that in my case using proc instead of func.

the indexes you r talking about, is it automatically built by sql server?

i know it is a litel big one but they give it to me and said make it work better?

this is the function

CREATE FUNCTION dbo.BUD0_F_T_GENEXPDTL( @CATID AS INT,@BUDYEAR AS INT,@EMPID AS NVARCHAR(50),@SORTTYPE INT,@TOTALSORT INT, @VERNUM INT )

--SET @CATID =4

--SET @BUDYEAR =1

--SET @EMPID= 'KAT EMP00000073'

--SET @TOTALSORT = 2

--SET @SORTTYPE=1

RETURNS...

if thats so why the seconed solution runs faster.

first solution:function+variable tables

seconed solution:procedure+temp tables?

of course am using a test servers and both of them have the same name..

actually i need all configurations from master-1

and i dont care what happen to master-1.log and mdf

i did try trace flag 3607 but i still couldnt connect to the sql server the same error.

any way i had tried this please tell if will be any side...

thanks a lot for helping me ,am doing exactly as u said but on step

4- logon into SQL Server as sa/trusted connection

i get an error message that only one...

thats good ,

am not trying to be nagy but i want to restore the master database not rebuild it,the tow operations are much differente as i know .

check this out...

yes Of course man??