Hi

Thanks you very much for the advice and i really appreciate that.

Thanks Again.

Azeem

Hi

I have used this and got no error. But how do we overcome this problem of 30 days in the 12th month. How does the sql convert the date? will...

Hi

I have tried that and no errors encountered. Any suggestions as How to overcome this issue?

Thanks

Azeem

Hi

I tried the query, its working for some values and it is giving error for others.

It is converting '7/12/1430' into gregorian.

where as it is giving error for '30/12/1430'.

I...

Thanks

Hi

How to compare Column values with user provided variables.

Select 1 From tbla Where RID = '13/12/2009'

or range

Select 1 From tbla Where RID between '13/12/2009' and '16/12/2009'

The column...

Thank you. I went through the thread and found it very useful. Still my doubts persist as to what is the better alternative.

Thanks Again.

Azeem.

Yes the database was associated with the user. but even if i take any new user and assign him the db_datareader role this issue is encountered.

may be the this has...

I have done using GUI. The process i used is

Security --> Loginss --> New Login --> Login with windows Authentication --> User Mapping --> Database --> db_datareader --> ok

then when...

No i did not add the user to any server roles. I have given the default schema for the user as dbo

Do you want me to look for something specific?

...

hi

some of the Permissions the user has are:

1.ALTER

2. ALTER ANY APPLICATION ROLE

3. ALTER ANY ASSEMBLY

4. ALTER ANY ASYMMETRIC KEY

5. ALTER ANY CERTIFICATE

6. ALTER ANY SCHEMA

7. ALTER ANY SERVICE

Regards.

Hi

Thanks for the reference.

Thanks again.

Regards.

Azeem

Hi

How to read the .out files generated by sql agent?

I have checked the event log its giving the error as Unable to read local eventlog (reason: The parameter is incorrect).

need...

Hi

will be doing as suggested by you and will also go through the logs. will keep you updated on this.

Thanks.

Hi

I am going through the logs and tresting by changing the account. will let you know once iam through.

Thank you very much for the advice.

Thanks Again.