Viewing 15 posts - 1 through 15 (of 21 total)
Thanks you very much for the advice and i really appreciate that.
February 11, 2010 at 2:46 am
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...
February 11, 2010 at 12:10 am
I have tried that and no errors encountered. Any suggestions as How to overcome this issue?
February 10, 2010 at 11:49 pm
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'.
February 10, 2010 at 10:52 pm
February 10, 2010 at 5:03 am
How to compare Column values with user provided variables.
Select 1 From tbla Where RID = '13/12/2009'
Select 1 From tbla Where RID between '13/12/2009' and '16/12/2009'
February 10, 2010 at 3:11 am
Thank you. I went through the thread and found it very useful. Still my doubts persist as to what is the better alternative.
February 10, 2010 at 1:45 am
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...
January 29, 2010 at 2:58 am
I have done using GUI. The process i used is
Security --> Loginss --> New Login --> Login with windows Authentication --> User Mapping --> Database --> db_datareader --> ok
January 29, 2010 at 2:37 am
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?
January 29, 2010 at 2:20 am
some of the Permissions the user has are:
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
January 29, 2010 at 1:58 am
Thanks for the reference.
January 27, 2010 at 11:07 pm
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).
January 19, 2010 at 5:27 am
will be doing as suggested by you and will also go through the logs. will keep you updated on this.
January 18, 2010 at 10:45 pm
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.
January 18, 2010 at 10:44 pm