Error 1222 Lock request

I received the Error 1222 lock request time out period
when trying to open SQL Server Current Activity folder
under the Management folder to display locks.
This was caused by several locks.
This made it very difficult to resolve the locks without
the GUI.
What would cause the SQL Server GUI to be unable to
display the locks?
Thank You,
Mickey Autry
mautry@.ev1.netThat's know to happen when you have a lot of locks. You can
use Query Analyzer to execute sql statments and system
stored procedures to view the same info you look at in the
Current Activity part of Enterprise Manager. Check books
online for more information on sp_lock, sp_who, sp_who2 and
the sysprocesses table.
-Sue
On Tue, 23 Sep 2003 15:41:17 -0700, "Mickey"
<mautry@.ev1.net> wrote:
>I received the Error 1222 lock request time out period
>when trying to open SQL Server Current Activity folder
>under the Management folder to display locks.
>This was caused by several locks.
>This made it very difficult to resolve the locks without
>the GUI.
>What would cause the SQL Server GUI to be unable to
>display the locks?
>Thank You,
>Mickey Autry
>mautry@.ev1.net
>

Error "Logon Fail" with crystal repor 11 and sql native language

Hi, I am using VB6 and sometimes when I try to display a report using cristal report 11 , I get this error "Logon Fail", I am working with SQL 2005 ENTERPRISE EDITION.

I want to know if I need an aditional configuration or something like that.

Thank you.

There should be a more datiled error message with the error number and state which explains why the logon failed.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Errocde = 3

Hi..
I wrote a StoreProcedure and use delphi to call it. if I am admin it run OK,
if I use normal user system will display error message like :
gereral SQL error
[MICROSOFT][ODBC SQL server Driver][SQL server]string or binary
data would
be trunated
[MicroSoft][ODBC SQL server Driver][SQL Server]the statement has
been
terminted
[MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
What's problem?how to solved it'
ThanksCan you reproduce this by running the code from within Query Analyzer?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"James" <James@.discussions.microsoft.com> wrote in message
news:E4DC72AA-BC62-42F7-8552-6BB9212BFD4D@.microsoft.com...
> Hi..
> I wrote a StoreProcedure and use delphi to call it. if I am admin it run O
K,
> if I use normal user system will display error message like :
> gereral SQL error
> [MICROSOFT][ODBC SQL server Driver][SQL server]string or binar
y data would
> be trunated
> [MicroSoft][ODBC SQL server Driver][SQL Server]the statement h
as been
> terminted
> [MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
> What's problem?how to solved it'
> Thanks
>

Errocde = 3

Hi..
I wrote a StoreProcedure and use delphi to call it. if I am admin it run OK,
if I use normal user system will display error message like :
gereral SQL error
[MICROSOFT][ODBC SQL server Driver][SQL server]string or binary data would
be trunated
[MicroSoft][ODBC SQL server Driver][SQL Server]the statement has been
terminted
[MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
What's problem?how to solved it?
Thanks
Can you reproduce this by running the code from within Query Analyzer?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"James" <James@.discussions.microsoft.com> wrote in message
news:E4DC72AA-BC62-42F7-8552-6BB9212BFD4D@.microsoft.com...
> Hi..
> I wrote a StoreProcedure and use delphi to call it. if I am admin it run OK,
> if I use normal user system will display error message like :
> gereral SQL error
> [MICROSOFT][ODBC SQL server Driver][SQL server]string or binary data would
> be trunated
> [MicroSoft][ODBC SQL server Driver][SQL Server]the statement has been
> terminted
> [MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
> What's problem?how to solved it?
> Thanks
>

Errocde = 3

Hi..
I wrote a StoreProcedure and use delphi to call it. if I am admin it run OK,
if I use normal user system will display error message like :
gereral SQL error
[MICROSOFT][ODBC SQL server Driver][SQL server]string or binary data would
be trunated
[MicroSoft][ODBC SQL server Driver][SQL Server]the statement has been
terminted
[MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
What's problem?how to solved it'
ThanksCan you reproduce this by running the code from within Query Analyzer?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"James" <James@.discussions.microsoft.com> wrote in message
news:E4DC72AA-BC62-42F7-8552-6BB9212BFD4D@.microsoft.com...
> Hi..
> I wrote a StoreProcedure and use delphi to call it. if I am admin it run OK,
> if I use normal user system will display error message like :
> gereral SQL error
> [MICROSOFT][ODBC SQL server Driver][SQL server]string or binary data would
> be trunated
> [MicroSoft][ODBC SQL server Driver][SQL Server]the statement has been
> terminted
> [MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
> What's problem?how to solved it'
> Thanks
>