Hi,

You can proceed as follows in the query, which is being used to raise the report:-

select CAST(20.34545 AS decimal(10,2))

Result: 20.35

Hint:

Decimal (p,s)

where p (precision):- Specifies the maximum total...

Hi All,

I came to know that if we can reinstall the client tools in English language, it can help to get the SSMS Items like Menu, Maintenance Plans, Jobs in...

Thanks Rich for your valuable response.:-)

Please also clarify that what setting should be changed so that from now onwards, new maintenance plans, jobs and objects are created in English Language...

Hi All,

Let me know if some other information is required..

With regards,

Ankur

Hi,

Greg , Thanks again for showing me the path.:-)

I wish to clarify one more thing:

We are having both SQL Server 2k/2k5 in our scope. As far as SS 2000 is...

Many Thanks To Greg & Locker for your feedback..

I am also planning to use 'sa' as the Job owner for all the scheduled jobs. But in general it is said...

Hi,

FYI..

Issue got resolved on deletion of excess backup devices and then restarting the server.

🙂

Ankur

Hi,

When only db_datareader role is assigned to any windows user in sql2005

that user is not able to view system procedures in that database.

You can grant view defination role that user...

Hi Sudhakara,

For Checking SQL Agent status, you can use:

xp_servicecontrol querystate, MSSQLAgent

Ankur:-D

Hi Sudhakara,

Please check following link for your questions's answer, provided by me:

http://www.sqlservercentral.com/Forums/Topic735557-145-1.aspx

Ankur 😛

Thanks for the replies.

It's really nice and learning to be part of such a fantastic group.

SQL Central rocks!!

Ankur 😛

Hi,

It can be related to any of the following reasons:

1. Did someone changed Job owner password recently?

2. Check whether Job Owner has access to the server or not.

Please...

Thanks Mr. Steve Jones and Mr. K. Brian kelly for your valuable responses.

Can you please explain more about Rainbow tables? This is the first time i have heared of it.

Ankur:-)

Hi,

Please help in clearifying following doubts:-

1. Is there is any function to decrpyt the string value encrypted using the hashbytes fuction?

2. Hashing algorithms are only used to encrypt the data....

Hi,

You can find useful info at following links:

http://www.mssqltips.com/tip.asp?tip=1359

http://blogs.technet.com/rob/archive/2008/05/26/detecting-sql-server-2005-blocking.aspx

Ankur