(if <> ) like else

try it this way

alter procedure sp_foo

@inputval varchar

as

begin

if @inputval like 'ALL'

begin

print 'ALL'

end

else

print 'hi'

end

u can try SQL Server Backup v7.1.6

or http://www.redgate.com SQL backup

can u try thired party tools, i have saw some can do this.

cos in 2005 there is some thing called schema and every user needs one to work in it.

in 2000 there is nothing like this.

so u have to map the user...

i have one try it it works for me.

please note that i hanvt created it, a freind give it to me.

/************************************************************************************************

*

*Purpose:To capture all the SQL Server logins with the binary...

just the reading the book and the questions wont be enough.

u have to use the management studio for a while, cos the questions are made for an experianced user.

if you...

i have found this link http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=31

and get this lines from there:

But SQL Mail has one very powerful feature that the later version (Database Mail) doesn't: the ability to...

but if i did used xp_readmail i still need to have outlook installed on the server and opened, right.

which i dont want to do.

denormalizing would require structure changes on the table, which it couldn't be made.

dose it contain any simulations, or what?

hi

i toke the exam last night and passed with 806.

it is n ot perfect, but good as for now.

and am preparing for 70-441 hope things go fine.

thanks

it dosent matter how hard is it, i think its hard enough.

i just passed it last day for 806, but the problem was that microsoft had never said any thing...

this is exactly wat i was looking for.

thanks alot

three hours?

its along time, then it must be alot of questions.

is it more than 50 question or what.

any way am studying microsoft self pased training kit, all in all its...

hi all

i know that am little bit late but i need to know how many questions in the test and in how much time did they gave u to answer...