Sql server wont prompt for variable value if it is not assign on time of query execution, just like oracle (or access). You need to initialize them by ur own....

I just replied to your previous post regarding the same.

in this post also, one couldn't get the idea what exactly you want to do.

It will be helpful if you...

did u try it anyway?

couldn't get the actual question!!!

@Grant Fritchey

Yes u r right!

it just need to add 'Option (maxrecursion 365)' (100 is the default limit for CTE, one can set it upto 32767 with 'maxrecursion')

DECLARE @STARTDATE datetime;

DECLARE...

Can't you use 'convert' while querying?

set @CalculateAdminScore = convert(decimal(10,2),@Hits) * @RelativeImp

though, it is not possible to store any big value without coverting or casting smaller datatype in to bigger one.

Hi,

Very good article!!! 🙂

Actually, as you mentioned in this article, WMI is very least used but the most powerful technique. It will be good if the article contain the basic...

Hi Smith,

Your preparation method is absolutely fine. Myself also following the same pattern. But wish to have some books to refer regarding the topics related to exam.

Kindly post if you...

Hi Mike,

Exellent article!! especially for those who wants to appear for exam but have no knowledge. I am going to add it to my favorite articles on SQL Server 🙂

Hey,...

Hi Mike,

Hope this may help you...

http://www.google.co.in/search?hl=en&q=related:www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/

may this link also be helpful to u..

http://www.microsoft.com/learning/en/us/certification/mcitp.aspx#tab2

Thank you Priyadarshan 🙂

and Congratulations for completing your certification exam.

Dear All,

my problem has been solved. These were the coz of problem.

1) The default port 1433 was disabled due to policy changed and dynamic port 1477 was enabled.

2) The TCP/IP...

Hi Mani,

TCP/IP protocol is already enabled.

My web server is located some where in USA, and I am trying to connect to SQL Server on my web server from my...

Hi,

I have some links over here,

http://delicious.com/krkansara11/MicrosoftCertificate;_ylt=A0wNBqFtEEJKkU8ASB1fRh54;_ylv=3

http://delicious.com/krkansara11/bundle:Microsoft%20SQL%20Server

Hi all,

Earlier i was forget to mention that I am facing this problem in SQL Server 2008; and as this is forum list for SS2K5, i should not hv to...