Hi,

It's looking like a permission issue.

To get better idea about error go to Advacced Tab of job and specify a file for the output. BY this you can have...

Hi GSquared,

Thanks for your reply.

Can anyone provide some links where Architecture of SQL Server 2005 is explained clearly?

Ankur

Hi,

You can use the Update Advisor while migrating from 2000 to 2005 platform. It will list the major issues which you are going to face during migration. Pay attention and...

Hi Mahesh,

You can have all information related to Browser Services at this link:

http://msdn.microsoft.com/en-us/library/ms181087.aspx

Cheers.:-P

Hi Gail,

This information is required just for knowledge purpose.

I came across the article about xp_logevent extended procedure, which is used to log a user-defined message in the Microsoft® SQL...

Hi,

I checked and found that text pad - notepad can be used for the same, but it doesnot reflect the chnages until the SQL services are stopped and restarted.

Is...

Thanks Gail,

It means that by using the text editors, one can even delete an entry from error logs.

Is the use of Text editor requires some special privileges? ...

Thanks Gila,

Is there any way to delete an individual entry from the error log file as well?

Your valuable responses are always appreciable, commendable and trustworthy.

We all are thankful to you...

Hi Akash,

You can get good collection of FAQ on this site:

http://www.sql-server-helper.com/

These are fundamental questions and are used by interviewers to judge the basics of candidates.

So, read and learn...

Hi Shamshad,

You can use the following built in Extended Procedure in Sql Server 2000/2005:

xp_servicecontrol querystate, MSSQLServer

this command will list the status of the sql server.

IIly, you can use it...

This is what i am looking for..

It is indeed a great help..

Thanks Florian 😀

Again Thanks Pradeep for Googling..

Actually i have also tried the same but all in vain.

Can anybody else guide in this regard?

Thanks

Ankur

Thanks Pradeep,

Error Message displayed on execution of code:

Incorrect syntax near '@DatabaseName'.

Is it a true that create database command doesnot accept variables in SS 2005?

Ankur

I hope that you must be specifying the name of the named instance while accessing it.

Moreover, check that specific SQL service for that instance should be running on the server....

Hi Ram,

Post at this link will definitely help you in recovery of MSDB database:

http://www.sqlservercentral.com/Forums/Topic399609-266-2.aspx

Cheers 🙂