Showing posts with label properties. Show all posts
Showing posts with label properties. Show all posts

Monday, 19 March 2012

connect timeout , is it works ?..

hye
i set in the connection string "connect timeout=400" and the application send error after 30sec ... why ?

*in the sql server properties , the connection time set to 0 .
*i know the run time of the query is very long , but in this case its doesn't matter :)

You are setting the timeout for the connection, that is, how long does it try to connect before timeout. If you are using a Command object, there is a CommandTimeout property that you can set to allow the command to actually run longer before timeout.

Wednesday, 7 March 2012

confused by drilldown

the field which has drilldown option is always showed minimum width after delopying to website

I attempted to set all properties of this fields as i can,such as "width","can grow" etc, but all do not work

any idea about this?

thanks

so flustrating

this issue caused by my firefox

it can work using ie

Sunday, 19 February 2012

Confirm Password window being displayed

Hi,
When I modifiy the properties of a SQL Server Login, I get the "Confirm
Password" screen displayed. This is displayed even if no change is made to
the login. Is this a bug and is there a hot fix out there.
Just want to know if anyone else has had this problem.
Thank You for your help,
GaryI wanted to add... If I retype the Password on the General Tab of the
Properties screen and make any changes, the Confirm Password screen still
pops up, but it will acknowledge the "new" (really the old one) password whe
n
confirmed and accept my changes. Without doing this, you cannot make any
login changes.
I am on version 2000 sp3 hot fix 818.
This is the only work around I have found so far.
Thanks,
Gary
"Gary Stewart" wrote:

> Hi,
> When I modifiy the properties of a SQL Server Login, I get the "Confirm
> Password" screen displayed. This is displayed even if no change is made t
o
> the login. Is this a bug and is there a hot fix out there.
> Just want to know if anyone else has had this problem.
> --
> Thank You for your help,
> Gary|||Search KB. I'm pretty certain that there's an article on this one.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
news:15EB36BD-B036-4C4D-96D8-D683EBDA695E@.microsoft.com...
> Hi,
> When I modifiy the properties of a SQL Server Login, I get the "Confirm
> Password" screen displayed. This is displayed even if no change is made t
o
> the login. Is this a bug and is there a hot fix out there.
> Just want to know if anyone else has had this problem.
> --
> Thank You for your help,
> Gary|||Hi Tibor,
I did find a HotFix on Google Groups.
See Link below for more information. It has been a problem since 2003.
http://groups-beta.google.com/group...0f0690f173447fb
Thank you for your help.
Gary
"Tibor Karaszi" wrote:

> Search KB. I'm pretty certain that there's an article on this one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
> news:15EB36BD-B036-4C4D-96D8-D683EBDA695E@.microsoft.com...
>
>|||This is the tool fix for MS03-031 (Build 818). The tool hotfix is build 819
and there is a link to it right off of the MS03-031 site.
Sincerely,
Anthony Thomas
"Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
news:0BD39043-BF96-41DE-B054-F8A9AAB799E2@.microsoft.com...
Hi Tibor,
I did find a HotFix on Google Groups.
See Link below for more information. It has been a problem since 2003.
http://groups-beta.google.com/group...0f0690f173447fb
Thank you for your help.
Gary
"Tibor Karaszi" wrote:

> Search KB. I'm pretty certain that there's an article on this one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
> news:15EB36BD-B036-4C4D-96D8-D683EBDA695E@.microsoft.com...
to[vbcol=seagreen]
>
>

Confirm Password window being displayed

Hi,
When I modifiy the properties of a SQL Server Login, I get the "Confirm
Password" screen displayed. This is displayed even if no change is made to
the login. Is this a bug and is there a hot fix out there.
Just want to know if anyone else has had this problem.
Thank You for your help,
Gary
I wanted to add... If I retype the Password on the General Tab of the
Properties screen and make any changes, the Confirm Password screen still
pops up, but it will acknowledge the "new" (really the old one) password when
confirmed and accept my changes. Without doing this, you cannot make any
login changes.
I am on version 2000 sp3 hot fix 818.
This is the only work around I have found so far.
Thanks,
Gary
"Gary Stewart" wrote:

> Hi,
> When I modifiy the properties of a SQL Server Login, I get the "Confirm
> Password" screen displayed. This is displayed even if no change is made to
> the login. Is this a bug and is there a hot fix out there.
> Just want to know if anyone else has had this problem.
> --
> Thank You for your help,
> Gary
|||Search KB. I'm pretty certain that there's an article on this one.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
news:15EB36BD-B036-4C4D-96D8-D683EBDA695E@.microsoft.com...
> Hi,
> When I modifiy the properties of a SQL Server Login, I get the "Confirm
> Password" screen displayed. This is displayed even if no change is made to
> the login. Is this a bug and is there a hot fix out there.
> Just want to know if anyone else has had this problem.
> --
> Thank You for your help,
> Gary
|||Hi Tibor,
I did find a HotFix on Google Groups.
See Link below for more information. It has been a problem since 2003.
http://groups-beta.google.com/group/...f0690f173447fb
Thank you for your help.
Gary
"Tibor Karaszi" wrote:

> Search KB. I'm pretty certain that there's an article on this one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
> news:15EB36BD-B036-4C4D-96D8-D683EBDA695E@.microsoft.com...
>
>
|||This is the tool fix for MS03-031 (Build 818). The tool hotfix is build 819
and there is a link to it right off of the MS03-031 site.
Sincerely,
Anthony Thomas

"Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
news:0BD39043-BF96-41DE-B054-F8A9AAB799E2@.microsoft.com...
Hi Tibor,
I did find a HotFix on Google Groups.
See Link below for more information. It has been a problem since 2003.
http://groups-beta.google.com/group/...f0690f173447fb
Thank you for your help.
Gary
"Tibor Karaszi" wrote:
[vbcol=seagreen]
> Search KB. I'm pretty certain that there's an article on this one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
> news:15EB36BD-B036-4C4D-96D8-D683EBDA695E@.microsoft.com...
to
>
>

Confirm Password window being displayed

Hi,
When I modifiy the properties of a SQL Server Login, I get the "Confirm
Password" screen displayed. This is displayed even if no change is made to
the login. Is this a bug and is there a hot fix out there.
Just want to know if anyone else has had this problem.
--
Thank You for your help,
GaryI wanted to add... If I retype the Password on the General Tab of the
Properties screen and make any changes, the Confirm Password screen still
pops up, but it will acknowledge the "new" (really the old one) password when
confirmed and accept my changes. Without doing this, you cannot make any
login changes.
I am on version 2000 sp3 hot fix 818.
This is the only work around I have found so far.
Thanks,
Gary
"Gary Stewart" wrote:
> Hi,
> When I modifiy the properties of a SQL Server Login, I get the "Confirm
> Password" screen displayed. This is displayed even if no change is made to
> the login. Is this a bug and is there a hot fix out there.
> Just want to know if anyone else has had this problem.
> --
> Thank You for your help,
> Gary|||Search KB. I'm pretty certain that there's an article on this one.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
news:15EB36BD-B036-4C4D-96D8-D683EBDA695E@.microsoft.com...
> Hi,
> When I modifiy the properties of a SQL Server Login, I get the "Confirm
> Password" screen displayed. This is displayed even if no change is made to
> the login. Is this a bug and is there a hot fix out there.
> Just want to know if anyone else has had this problem.
> --
> Thank You for your help,
> Gary|||Hi Tibor,
I did find a HotFix on Google Groups.
See Link below for more information. It has been a problem since 2003.
http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_frm/thread/c730938ac04e37c3/10f0690f173447fb?tvc=1#10f0690f173447fb
Thank you for your help.
Gary
"Tibor Karaszi" wrote:
> Search KB. I'm pretty certain that there's an article on this one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
> news:15EB36BD-B036-4C4D-96D8-D683EBDA695E@.microsoft.com...
> > Hi,
> >
> > When I modifiy the properties of a SQL Server Login, I get the "Confirm
> > Password" screen displayed. This is displayed even if no change is made to
> > the login. Is this a bug and is there a hot fix out there.
> >
> > Just want to know if anyone else has had this problem.
> >
> > --
> > Thank You for your help,
> >
> > Gary
>
>|||This is the tool fix for MS03-031 (Build 818). The tool hotfix is build 819
and there is a link to it right off of the MS03-031 site.
Sincerely,
Anthony Thomas
"Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
news:0BD39043-BF96-41DE-B054-F8A9AAB799E2@.microsoft.com...
Hi Tibor,
I did find a HotFix on Google Groups.
See Link below for more information. It has been a problem since 2003.
http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_frm/thread/c730938ac04e37c3/10f0690f173447fb?tvc=1#10f0690f173447fb
Thank you for your help.
Gary
"Tibor Karaszi" wrote:
> Search KB. I'm pretty certain that there's an article on this one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Gary Stewart" <GaryStewart@.discussions.microsoft.com> wrote in message
> news:15EB36BD-B036-4C4D-96D8-D683EBDA695E@.microsoft.com...
> > Hi,
> >
> > When I modifiy the properties of a SQL Server Login, I get the "Confirm
> > Password" screen displayed. This is displayed even if no change is made
to
> > the login. Is this a bug and is there a hot fix out there.
> >
> > Just want to know if anyone else has had this problem.
> >
> > --
> > Thank You for your help,
> >
> > Gary
>
>

Confirm password problem??

I am running SQL Server 2000 on a Windows 2000 Server. Whenever I change
anything on the properties of any of the logins, it asks me to confirm the
password even though it has not been changed. Actually, I can just view the
properties of any login, change nothing, click OK, and it will still ask me
to confirm the password. If I type in the password (and the password has
not been changed) it says it is incorrect. I must retype the password,
click OK, verify it, and then click OK again. What is the problem here?Sounds like this may be the issue you are running into:
FIX: You Are Prompted for Password Confirmation After You
Change a Standard SQL Server Login
http://support.microsoft.com/?kbid=826161
-Sue
On Thu, 8 Apr 2004 07:14:43 -0500, "Dave"
<DMikeK@.hotmail.com> wrote:

>I am running SQL Server 2000 on a Windows 2000 Server. Whenever I change
>anything on the properties of any of the logins, it asks me to confirm the
>password even though it has not been changed. Actually, I can just view th
e
>properties of any login, change nothing, click OK, and it will still ask me
>to confirm the password. If I type in the password (and the password has
>not been changed) it says it is incorrect. I must retype the password,
>click OK, verify it, and then click OK again. What is the problem here?
>|||Sue,
Thanks. I did try searching the Knowledge Base but didn't find that one,
for some reason. I'll give it a try.
Dave
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:6vja70leoufd0535ral22cb1q7f4hnatq0@.
4ax.com...
> Sounds like this may be the issue you are running into:
> FIX: You Are Prompted for Password Confirmation After You
> Change a Standard SQL Server Login
> http://support.microsoft.com/?kbid=826161
> -Sue
> On Thu, 8 Apr 2004 07:14:43 -0500, "Dave"
> <DMikeK@.hotmail.com> wrote:
>
the
the
me
>