KDC Problem: enterprise

Showing posts with label enterprise. Show all posts

Monday, March 26, 2012

Killing automatically crashed sessions ??

If one of my workstations (which communicate using ODBC) crashes, I still see it as connected in Enterprise Manager under management\current activity\.
Is there anyway to kill automatically the crashed cessions?
Thkx in advanceYou could periodicaly scan the sysprocesses table and kill any connection that hasn't had activity in some predeturmined amount of time.

kill user connections

can someone point me to a good site / article on how to go abt checking for
current user connections and kill these connections,
using Enterprise Mge & T-SQL.
try searching Microsoft, didn't find what I am looking for.
tksTry BooksOnLine. Specifically you might want to look at sp_who and KILL
commands.
Andrew J. Kelly SQL MVP
"pk" <pk@.> wrote in message news:e#XJeQtEEHA.3576@.tk2msftngp13.phx.gbl...
> can someone point me to a good site / article on how to go abt checking
for
> current user connections and kill these connections,
> using Enterprise Mge & T-SQL.
> try searching Microsoft, didn't find what I am looking for.
>
> tks
>|||Hi,
IN Query Analyzer
Execute
sp_who (To get all the connected process)
Kill <Process id> (to kill a process)
Enterprise manager
1. Expand the Management option
2. Expand - CUrrent Activity
3.Click the process info - this will show all process connected
4. Doule click the process to get the statement running (Use DBCC
INPUTBUFFER(process id) in Query Anlyzer
5. Right click and kill (if you need to kill the process)
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:O42p##tEEHA.696@.TK2MSFTNGP12.phx.gbl...
> Try BooksOnLine. Specifically you might want to look at sp_who and KILL
> commands.
> --
> Andrew J. Kelly SQL MVP
>
> "pk" <pk@.> wrote in message news:e#XJeQtEEHA.3576@.tk2msftngp13.phx.gbl...
> for
>|||tks.
i also found this, although it uses a script,
http://www.sqlservercentral.com/scr...ibutions/30.asp
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:eToleOuEEHA.2308@.tk2msftngp13.phx.gbl...
> Hi,
> IN Query Analyzer
> Execute
> sp_who (To get all the connected process)
> Kill <Process id> (to kill a process)
> Enterprise manager
> 1. Expand the Management option
> 2. Expand - CUrrent Activity
> 3.Click the process info - this will show all process connected
> 4. Doule click the process to get the statement running (Use DBCC
> INPUTBUFFER(process id) in Query Anlyzer
> 5. Right click and kill (if you need to kill the process)
> Thanks
> Hari
> MCDBA
>
>
> "Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
> news:O42p##tEEHA.696@.TK2MSFTNGP12.phx.gbl...
news:e#XJeQtEEHA.3576@.tk2msftngp13.phx.gbl...
checking
>|||Also Tibor Karaszi has a stored procedure that I always use.. It allows you
to kill all of the connections on a particular database... It can be found
under the procedures section of his web site www.dbmaint.com
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"pk" <pk@.> wrote in message news:e%23XJeQtEEHA.3576@.tk2msftngp13.phx.gbl...
> can someone point me to a good site / article on how to go abt checking
for
> current user connections and kill these connections,
> using Enterprise Mge & T-SQL.
> try searching Microsoft, didn't find what I am looking for.
>
> tks
>

Friday, March 23, 2012

Kill session

I've made a kill to a session that is stucked in SQL Server 2000 Enterprise +
SP3 with the status KILLED/ROLLBACK.
How can i force the kill ?
SQL> kill 567
SPID 567: transaction rollback in progress. Estimated rollback completion:
100%. Estimated time remaining: 0 seconds.
Thanks in advance
CCCC
Take your coffee , it takes time
"CC" <CC@.discussions.microsoft.com> wrote in message
news:CB29FBB8-0772-4315-9DAB-3D898D39C354@.microsoft.com...
> I've made a kill to a session that is stucked in SQL Server 2000
> Enterprise +
> SP3 with the status KILLED/ROLLBACK.
> How can i force the kill ?
> SQL> kill 567
> SPID 567: transaction rollback in progress. Estimated rollback completion:
> 100%. Estimated time remaining: 0 seconds.
> Thanks in advance
> CC|||Thanks Uri but:
-Estimated time remaining: 0 seconds
-Estimated rollback completion:100%
-Spid last_batch in sysprocesses 2005-09-12 00:52:15.380 (7 Days)
This session is from a backup:
sp_lock:
567 14 0 0 DB [BULK-OP-LOG] X GRANT
567 14 0 0 DB [BULK-OP-DB] X GRANT
567 14 0 0 DB S GRANT
My full database backup don't start because of this session and i do not
want to restart SQL Server service on a production database because of a
zombie spid.
I think i will need more than a coffe : ) Can you help ?
The spid was killed but does not release locks held.
CC
"Uri Dimant" wrote:
> CC
> Take your coffee , it takes time
>
> "CC" <CC@.discussions.microsoft.com> wrote in message
> news:CB29FBB8-0772-4315-9DAB-3D898D39C354@.microsoft.com...
> > I've made a kill to a session that is stucked in SQL Server 2000
> > Enterprise +
> > SP3 with the status KILLED/ROLLBACK.
> > How can i force the kill ?
> >
> > SQL> kill 567
> > SPID 567: transaction rollback in progress. Estimated rollback completion:
> > 100%. Estimated time remaining: 0 seconds.
> >
> > Thanks in advance
> > CC
>
>|||CC
Well, one option is to restart MS Service , another is if the first one does
not help ,in Task Manager to kill the process.
"CC" <CC@.discussions.microsoft.com> wrote in message
news:131B1221-349A-4260-93F9-2FF6BAF63BBD@.microsoft.com...
> Thanks Uri but:
> -Estimated time remaining: 0 seconds
> -Estimated rollback completion:100%
> -Spid last_batch in sysprocesses 2005-09-12 00:52:15.380 (7 Days)
> This session is from a backup:
> sp_lock:
> 567 14 0 0 DB [BULK-OP-LOG] X GRANT
> 567 14 0 0 DB [BULK-OP-DB] X GRANT
> 567 14 0 0 DB S GRANT
> My full database backup don't start because of this session and i do not
> want to restart SQL Server service on a production database because of a
> zombie spid.
> I think i will need more than a coffe : ) Can you help ?
> The spid was killed but does not release locks held.
> CC
> "Uri Dimant" wrote:
>> CC
>> Take your coffee , it takes time
>>
>> "CC" <CC@.discussions.microsoft.com> wrote in message
>> news:CB29FBB8-0772-4315-9DAB-3D898D39C354@.microsoft.com...
>> > I've made a kill to a session that is stucked in SQL Server 2000
>> > Enterprise +
>> > SP3 with the status KILLED/ROLLBACK.
>> > How can i force the kill ?
>> >
>> > SQL> kill 567
>> > SPID 567: transaction rollback in progress. Estimated rollback
>> > completion:
>> > 100%. Estimated time remaining: 0 seconds.
>> >
>> > Thanks in advance
>> > CC
>>|||So is BULK-OP-DB and BULK-OP-LOG used for any file growth operations? I see
it holding locks on backups?
"Uri Dimant" wrote:
> CC
> Well, one option is to restart MS Service , another is if the first one does
> not help ,in Task Manager to kill the process.
>
>
> "CC" <CC@.discussions.microsoft.com> wrote in message
> news:131B1221-349A-4260-93F9-2FF6BAF63BBD@.microsoft.com...
> > Thanks Uri but:
> > -Estimated time remaining: 0 seconds
> > -Estimated rollback completion:100%
> > -Spid last_batch in sysprocesses 2005-09-12 00:52:15.380 (7 Days)
> > This session is from a backup:
> > sp_lock:
> > 567 14 0 0 DB [BULK-OP-LOG] X GRANT
> > 567 14 0 0 DB [BULK-OP-DB] X GRANT
> > 567 14 0 0 DB S GRANT
> >
> > My full database backup don't start because of this session and i do not
> > want to restart SQL Server service on a production database because of a
> > zombie spid.
> >
> > I think i will need more than a coffe : ) Can you help ?
> > The spid was killed but does not release locks held.
> >
> > CC
> >
> > "Uri Dimant" wrote:
> >
> >> CC
> >> Take your coffee , it takes time
> >>
> >>
> >> "CC" <CC@.discussions.microsoft.com> wrote in message
> >> news:CB29FBB8-0772-4315-9DAB-3D898D39C354@.microsoft.com...
> >> > I've made a kill to a session that is stucked in SQL Server 2000
> >> > Enterprise +
> >> > SP3 with the status KILLED/ROLLBACK.
> >> > How can i force the kill ?
> >> >
> >> > SQL> kill 567
> >> > SPID 567: transaction rollback in progress. Estimated rollback
> >> > completion:
> >> > 100%. Estimated time remaining: 0 seconds.
> >> >
> >> > Thanks in advance
> >> > CC
> >>
> >>
> >>
>
>sql

Kill session

Monday, March 12, 2012

Key column is insufficient or incorrect. too many rows were affect

Hi,
When I open table, return all rows using Enterprise Manager and I tried to
edit a column, it returned "Key column is insufficient or incorrect. too man
y
rows were affected by update"
This is a standalone table. No constraint. No formula.
Advice please. TIA !Any reasons to open it in EM?
Do you have any triggers on the table that you modifies to?
If you edit some row , click om another one and see if it worked
Do any modifications thru SP and not by EM
"Desmond" <Desmond@.discussions.microsoft.com> wrote in message
news:51F80698-3DE1-49C7-88A0-093E583DF49F@.microsoft.com...
> Hi,
> When I open table, return all rows using Enterprise Manager and I tried to
> edit a column, it returned "Key column is insufficient or incorrect. too
> many
> rows were affected by update"
> This is a standalone table. No constraint. No formula.
> Advice please. TIA !|||Has the table a primary key defined?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Desmond" <Desmond@.discussions.microsoft.com> wrote in message
news:51F80698-3DE1-49C7-88A0-093E583DF49F@.microsoft.com...
> Hi,
> When I open table, return all rows using Enterprise Manager and I tried to
> edit a column, it returned "Key column is insufficient or incorrect. too m
any
> rows were affected by update"
> This is a standalone table. No constraint. No formula.
> Advice please. TIA !

Key column information is insufficient or incorrect. Too many rows were affected by u

I have edit sql server 2000 table record by vb or direct enterprise mangafer and i have recived one message "Key column information is insufficient or incorrect. Too many rows were affected by update." any guys know this problem pl send the solution

Manish jain

ThanksThe Name Of Allah
hi

In the following table, for example, the error message appears if you attempt to delete one or both of the rows containing "abc" by using SQL Enterprise Manager with the following steps:
1. Right-click on the table.
2. Click on Open table, and then click on Return All Rows.
3. Highlight the rows, and then press the Delete button.

Character_Column1 Character_Column2
abc abc
abc abc
zxy zxy
fgt art

Eng. Maged

key column information is insufficient or incorrect

key columen information is insufficient or incorrect.Too many rows were
affected by update

pls suggest what is this and how to solve this problem

Thanks in advance

Dinesh Patwaldinu wrote:

Quote:

Originally Posted by

Dear Friends,
I have table contain 2000 out of those some are
duplicate when i select duplicate records by using Enterprise Manager
and make modification to one of those duplicate records the following
message flashes/display.
>
key columen information is insufficient or incorrect.Too many rows were
affected by update
>
pls suggest what is this and how to solve this problem
>
Thanks in advance
>
Dinesh Patwal

Before you can edit the data in Enterprise Manager you need to add a
unique constraint or unique index. To facilitate that it may help to
use SELECT DISTINCT to eliminate duplicates and copy the data to a new
table. It rather depends on just how you want to eliminate the
duplicate data. You can Google for lots of previous posts on this topic
in this group and in the microsoft.public.sqlserver groups.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--

Wednesday, March 7, 2012

Keep users from view other databases

Hi,
We are a small ISP that allows user to use Enterprise Manager to work with
their databases. We would like the users to only see that databases they hav
e
permissions for. The way SQL 200 is setup by default the users can see all
the databases on the server.
So the question is can we change something that would prevent users from
seeing the other databases on the server?
Thanks in advance,
BobNot with Enterprise Manager and SQL 2000. The users will be
able to see the other databases. They can't access them
without the appropriate permissions but they will be able to
see them.
-Sue
On Mon, 28 Feb 2005 16:57:03 -0800, "Bob Melani" <Bob
Melani@.discussions.microsoft.com> wrote:

>Hi,
>
>We are a small ISP that allows user to use Enterprise Manager to work with
>their databases. We would like the users to only see that databases they ha
ve
>permissions for. The way SQL 200 is setup by default the users can see all
>the databases on the server.
>So the question is can we change something that would prevent users from
>seeing the other databases on the server?
>Thanks in advance,
>Bob|||Bummer,
Thanks for the answer..
"Sue Hoegemeier" wrote:

> Not with Enterprise Manager and SQL 2000. The users will be
> able to see the other databases. They can't access them
> without the appropriate permissions but they will be able to
> see them.
> -Sue
> On Mon, 28 Feb 2005 16:57:03 -0800, "Bob Melani" <Bob
> Melani@.discussions.microsoft.com> wrote:
>
>

Monday, February 20, 2012

Keep all servers registered and connected

I have 5 servers in my Server Mgmt Studio divided into 4 groups,

Local

Production

Test

Development

In Sql 2000 Enterprise Manager would put the little green arrow next to your db if it was connected, I noticed that Sql 2005 does do that but it wont allow me to keep all 5 servers connected and I need them all to stay connected.

If I look under Registered Servers it shows all 5 servers there but again only 2 show as connected even if I connect the other ones they dont stay connected. I have deleted the registerd ones and re added them and still no difference.

How can I keep all servers registered and connected and then have them show up on start-up?

Thanks!

Stokh

Launch Mgmt Studio

In the Registered Servers tool window right-click on the server and select Properties

On the Properties dialog select the Connection Properties tab

Set Connection time-out to 0 (the default is 15 seconds; 0 indicates no time-out).

|||I already did that and it still does the same thing, only shows 2 servers registered and doesnt keep the other 3 connected|||I suggest you file a bug using the Product Feedback Center: http://lab.msdn.microsoft.com/productfeedback/Default.aspx.|||I would also like to complain about this new 2005 behavior. As a DBA managing dozens of servers, it is ridiculous to keep jumping through the connection hoops in 2005 whenever I switch server context. It's hard to believe MS could screw up something so basic... and something that worked perfectly well in 2000.|||The best thing to do is search the Product Feedback Center for the issue and vote on it. In SP2 we are targeting many of the annoyances of the Mgmt Studio but we need your votes. The voting system let's us know what issues are causing pain for people and those tend to float to the top part of the list.

Monday, March 26, 2012

Killing automatically crashed sessions ??

kill user connections

Friday, March 23, 2012

Kill session

Kill session

Kill session

Monday, March 12, 2012

Key column is insufficient or incorrect. too many rows were affect

Key column information is insufficient or incorrect. Too many rows were affected by u

key column information is insufficient or incorrect

Wednesday, March 7, 2012

Keep users from view other databases

Monday, February 20, 2012

Keep all servers registered and connected

KDC Problem

Blog Archive

About Me