Blocks

Hello,Why an sp autoblock '
If exec my sp and view the connections with sp_who i watch te id of my
connection in the column blk of the result.
Why succedes this '
Thanks in advance.Check out:
http://support.microsoft.com/default.aspx/kb/906344
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
Hello,Why an sp autoblock '
If exec my sp and view the connections with sp_who i watch te id of my
connection in the column blk of the result.
Why succedes this '
Thanks in advance.|||Thanks !!!
But,what i configured in the server because the time of blocked is over 20
seconds ?
Thanks in advance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23mmGQy%23xGHA.2516@.TK2MSFTNGP06.phx.gbl...
> Check out:
> http://support.microsoft.com/default.aspx/kb/906344
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
> news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
> Hello,Why an sp autoblock '
> If exec my sp and view the connections with sp_who i watch te id of my
> connection in the column blk of the result.
> Why succedes this '
> Thanks in advance.
>|||You'll have to tell us what you "configured".
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
news:eidPzzAyGHA.3844@.TK2MSFTNGP06.phx.gbl...
Thanks !!!
But,what i configured in the server because the time of blocked is over 20
seconds ?
Thanks in advance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23mmGQy%23xGHA.2516@.TK2MSFTNGP06.phx.gbl...
> Check out:
> http://support.microsoft.com/default.aspx/kb/906344
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
> news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
> Hello,Why an sp autoblock '
> If exec my sp and view the connections with sp_who i watch te id of my
> connection in the column blk of the result.
> Why succedes this '
> Thanks in advance.
>

Blocks

Hello,Why an sp autoblock '
If exec my sp and view the connections with sp_who i watch te id of my
connection in the column blk of the result.
Why succedes this '
Thanks in advance.Check out:
http://support.microsoft.com/default.aspx/kb/906344
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
Hello,Why an sp autoblock '
If exec my sp and view the connections with sp_who i watch te id of my
connection in the column blk of the result.
Why succedes this '
Thanks in advance.|||Thanks !!!
But,what i configured in the server because the time of blocked is over 20
seconds ?
Thanks in advance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23mmGQy%23xGHA.2516@.TK2MSFTNGP06.phx.gbl...
> Check out:
> http://support.microsoft.com/default.aspx/kb/906344
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
> news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
> Hello,Why an sp autoblock '
> If exec my sp and view the connections with sp_who i watch te id of my
> connection in the column blk of the result.
> Why succedes this '
> Thanks in advance.
>|||You'll have to tell us what you "configured".
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
news:eidPzzAyGHA.3844@.TK2MSFTNGP06.phx.gbl...
Thanks !!!
But,what i configured in the server because the time of blocked is over 20
seconds ?
Thanks in advance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23mmGQy%23xGHA.2516@.TK2MSFTNGP06.phx.gbl...
> Check out:
> http://support.microsoft.com/default.aspx/kb/906344
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
> news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
> Hello,Why an sp autoblock '
> If exec my sp and view the connections with sp_who i watch te id of my
> connection in the column blk of the result.
> Why succedes this '
> Thanks in advance.
>

Blocking Telnet command for SQL Server Detection 1433/1434

Any ideas how I can I block telnet connections to SQL Server ports ?

The only way is to turn of TCP/IP connections for SQL Server on the server.

HTH, jens SUessmeyer.

http://www.sqlserver2005.de

Blocking on something like Ghost Cleanup?

I noticed that several connections were blocked by something called Ghost Cleanup (or something like that). I know what the cleanup does, but it often causes blocking for quite a while . . .

Anything I can do about it? SS2000.

Thanks,

Michael

Did you check for error 602 in the error log? You want to make sure the object involved isn't damaged.

Other than that, being that they are created when row level locks are used for the delete, you can try using PAGLOCK or TABLOCK hints to avoid them being created.

-Sue

Blocking on something like Ghost Cleanup?

I noticed that several connections were blocked by something called Ghost Cleanup (or something like that). I know what the cleanup does, but it often causes blocking for quite a while . . .

Anything I can do about it? SS2000.

Thanks,

Michael

Did you check for error 602 in the error log? You want to make sure the object involved isn't damaged.

Other than that, being that they are created when row level locks are used for the delete, you can try using PAGLOCK or TABLOCK hints to avoid them being created.

-Sue

blocking all connections for final cut over to new SQL server machine

Hi ALL,
I'm replaceing the old SQL server machine to the new & better SQL server
machine. i already done all the moves but in the final cut over planning, i
need some help. How can i restrict all users and applications from connecting
to the old machine. so that in the down time i can take the Final
Transactional log backup and restore to the new SQL server machine. i know i
can use Single user move or Change IP address to the old machine or i can
denay all users access. BUT i don't know which one is better way to do and
why?
are there any other way of doing this?
Any feedback will be greatly appreciated.
THANKS
Nick
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200508/1
Good stuff
http://vyaskn.tripod.com/moving_sql_server.htm
"Nick via droptable.com" <forum@.droptable.com> wrote in message
news:534E920C33D81@.droptable.com...
> Hi ALL,
> I'm replaceing the old SQL server machine to the new & better SQL server
> machine. i already done all the moves but in the final cut over planning,
> i
> need some help. How can i restrict all users and applications from
> connecting
> to the old machine. so that in the down time i can take the Final
> Transactional log backup and restore to the new SQL server machine. i know
> i
> can use Single user move or Change IP address to the old machine or i can
> denay all users access. BUT i don't know which one is better way to do and
> why?
> are there any other way of doing this?
> Any feedback will be greatly appreciated.
> THANKS
> Nick
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200508/1

blocking all connections for final cut over to new SQL server machine

Hi ALL,
I'm replaceing the old SQL server machine to the new & better SQL server
machine. i already done all the moves but in the final cut over planning, i
need some help. How can i restrict all users and applications from connectin
g
to the old machine. so that in the down time i can take the Final
Transactional log backup and restore to the new SQL server machine. i know i
can use Single user move or Change IP address to the old machine or i can
denay all users access. BUT i don't know which one is better way to do and
why?
are there any other way of doing this?
Any feedback will be greatly appreciated.
THANKS
Nick
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200508/1Good stuff
http://vyaskn.tripod.com/moving_sql_server.htm
"Nick via droptable.com" <forum@.droptable.com> wrote in message
news:534E920C33D81@.droptable.com...
> Hi ALL,
> I'm replaceing the old SQL server machine to the new & better SQL server
> machine. i already done all the moves but in the final cut over planning,
> i
> need some help. How can i restrict all users and applications from
> connecting
> to the old machine. so that in the down time i can take the Final
> Transactional log backup and restore to the new SQL server machine. i know
> i
> can use Single user move or Change IP address to the old machine or i can
> denay all users access. BUT i don't know which one is better way to do and
> why?
> are there any other way of doing this?
> Any feedback will be greatly appreciated.
> THANKS
> Nick
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200508/1

blocking all connections for final cut over to new SQL server machine

Hi ALL,
I'm replaceing the old SQL server machine to the new & better SQL server
machine. i already done all the moves but in the final cut over planning, i
need some help. How can i restrict all users and applications from connecting
to the old machine. so that in the down time i can take the Final
Transactional log backup and restore to the new SQL server machine. i know i
can use Single user move or Change IP address to the old machine or i can
denay all users access. BUT i don't know which one is better way to do and
why?
are there any other way of doing this?
Any feedback will be greatly appreciated.
THANKS
Nick
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200508/1Good stuff
http://vyaskn.tripod.com/moving_sql_server.htm
"Nick via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:534E920C33D81@.SQLMonster.com...
> Hi ALL,
> I'm replaceing the old SQL server machine to the new & better SQL server
> machine. i already done all the moves but in the final cut over planning,
> i
> need some help. How can i restrict all users and applications from
> connecting
> to the old machine. so that in the down time i can take the Final
> Transactional log backup and restore to the new SQL server machine. i know
> i
> can use Single user move or Change IP address to the old machine or i can
> denay all users access. BUT i don't know which one is better way to do and
> why?
> are there any other way of doing this?
> Any feedback will be greatly appreciated.
> THANKS
> Nick
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200508/1

Blocked sleeping active connections

Hi

We just installed SQL service pack 4. I am now finding that when doing a sp_who2 active, there are a lot of connections that are blocked by itself. The common factor is they all have a status of 'sleeping'. The strange thing is that even though it shows the connection is blocked, it is in fact not and will still return results. Below is a snapshot of a portion of what the sp_who2 active returns:

SPID Status Login HostName BlkBy DBName
53 sleeping sa TRACKER 53 dbABC
58 sleeping sa TRACKER 58 dbCDE
64 sleeping sa TRACKER 64 dbSTA
66 RUNNABLE User12 PC24 . master
70 sleeping User5 ANALYSIS 70 dbBML
74 sleeping sa TRACKER 74 dbCDE
76 sleeping sa TRACKER 76 dbPTS
83 sleeping User5 ANALYSIS 83 dbANA
86 DORMANT User11 CPTDB . NULL

Has anyone seen this? Is it related to the installation of service pack 4? (We have installed the services pack on many other SQL servers, but have not come accross this before.

Tx,
TessZAThe "self-blocking spid" is a new feature of SP4. In short, it is not actual blocking. If a spid is waiting on a latch, it shows as blocking itself. I have not seen it on this scale, though. Do you happen to know if you are suffering a lot of disk activity around the times that a lot of self-blocking spids are showing up?

Block MS Office Connection

SQL Server 2000.
Is there a simple way to block MS Office connections to a SQL Server database?
Thanks,
TomEasy, dont give them a login to use.
"T Morris" <TMorris@.discussions.microsoft.com> wrote in message
news:1C16D499-3B03-4252-A474-042650A67385@.microsoft.com...
> SQL Server 2000.
> Is there a simple way to block MS Office connections to a SQL Server
> database?
>
> Thanks,
> Tom|||Yes, disable the network adapter.
The long answer is no. If the user has a valid SQL Server username/password
(or) their network identity or group has access to the server/database, then
there are many applications, including Office products, that can be used to
access the data in the database.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"T Morris" <TMorris@.discussions.microsoft.com> wrote in message
news:1C16D499-3B03-4252-A474-042650A67385@.microsoft.com...
> SQL Server 2000.
> Is there a simple way to block MS Office connections to a SQL Server
> database?
>
> Thanks,
> Tom|||Hi Tom
One option may be to use an Application Role for your own application and
only grant the privileges needed to access the tables to this role.
If you restrict access to be only by stored procedures and don't use dynamic
SQL then your users will only be able to execute these procedures and not
access the data directly regardless of the application they are using.
John
"T Morris" wrote:
> SQL Server 2000.
> Is there a simple way to block MS Office connections to a SQL Server database?
>
> Thanks,
> Tom

Block MS Office Connection

SQL Server 2000.
Is there a simple way to block MS Office connections to a SQL Server databas
e?
Thanks,
TomEasy, dont give them a login to use.
"T Morris" <TMorris@.discussions.microsoft.com> wrote in message
news:1C16D499-3B03-4252-A474-042650A67385@.microsoft.com...
> SQL Server 2000.
> Is there a simple way to block MS Office connections to a SQL Server
> database?
>
> Thanks,
> Tom|||Yes, disable the network adapter.
The long answer is no. If the user has a valid SQL Server username/password
(or) their network identity or group has access to the server/database, then
there are many applications, including Office products, that can be used to
access the data in the database.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"T Morris" <TMorris@.discussions.microsoft.com> wrote in message
news:1C16D499-3B03-4252-A474-042650A67385@.microsoft.com...
> SQL Server 2000.
> Is there a simple way to block MS Office connections to a SQL Server
> database?
>
> Thanks,
> Tom|||Hi Tom
One option may be to use an Application Role for your own application and
only grant the privileges needed to access the tables to this role.
If you restrict access to be only by stored procedures and don't use dynamic
SQL then your users will only be able to execute these procedures and not
access the data directly regardless of the application they are using.
John
"T Morris" wrote:

> SQL Server 2000.
> Is there a simple way to block MS Office connections to a SQL Server datab
ase?
>
> Thanks,
> Tom