Running and sleeping processes

Hi there,
Can somebody tell me the differences between SLEEPING and RUNNING
processes? I cannot find an explaination in BOL. If there is a thread on
this issue somewhere, can you put a link?
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!sleeping status indicates that the SPID has completed execution and is
waiting for the application to submit another query or batch. A runnable
status indicates the SPID is currently processing a query
See
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
PSS ID Number: 224453
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Hans Brouwer" <hansbrouwer@.hotmail.com> wrote in message
news:u$XIjMJlDHA.2500@.TK2MSFTNGP10.phx.gbl...
> Hi there,
> Can somebody tell me the differences between SLEEPING and RUNNING
> processes? I cannot find an explaination in BOL. If there is a thread on
> this issue somewhere, can you put a link?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

run time error 3265 after moving from Sql servr 7 to sql server 20

Hopefully somebody see the mistake I am doing.
We are using an Vb application connecting to SQL 7. After moving to SQL 2000
and Windows 2000 system the same application send error message when trying
to insert or update any data via the VB application. What did I missied to
transfer?
I try to move the application via the Copy wizard and also via data import
and both had same result. I also checked the security settings on the old
server and the new one.
Thanks Katja
What exactly are you doing when you get the error?
Andrew J. Kelly SQL MVP
"Katja J." <Katja J.@.discussions.microsoft.com> wrote in message
news:8ABAEC7E-CB87-415F-9066-D19340ED688B@.microsoft.com...
> Hopefully somebody see the mistake I am doing.
> We are using an Vb application connecting to SQL 7. After moving to SQL
> 2000
> and Windows 2000 system the same application send error message when
> trying
> to insert or update any data via the VB application. What did I missied to
> transfer?
> I try to move the application via the Copy wizard and also via data import
> and both had same result. I also checked the security settings on the old
> server and the new one.
> Thanks Katja

RSS Relational Model?

I'm fishing for a model somebody may choose to give me or refer to
documentation for a schema that documents a design for storing RSS and/or
ATOM feeds.
<%= Clinton Gallagher
Not exactly a relational model, but it can give you some ideas "XML to SQL:
Using SQLXML Bulkload in the .NET Framework"
http://msdn.microsoft.com/library/de...exchsqlxml.asp
Cristian Lefter, SQL Server MVP
"clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
> I'm fishing for a model somebody may choose to give me or refer to
> documentation for a schema that documents a design for storing RSS and/or
> ATOM feeds.
> <%= Clinton Gallagher
>
|||Good starting point.
<%= Clinton Gallagher
"Cristian Lefter" <nospam_CristianLefter@.hotmail.com> wrote in message
news:u3%23OBNZVFHA.612@.TK2MSFTNGP12.phx.gbl...
> Not exactly a relational model, but it can give you some ideas "XML to
> SQL: Using SQLXML Bulkload in the .NET Framework"
> http://msdn.microsoft.com/library/de...exchsqlxml.asp
> Cristian Lefter, SQL Server MVP
> "clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
> news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
>

RSS Relational Model?

I'm fishing for a model somebody may choose to give me or refer to
documentation for a schema that documents a design for storing RSS and/or
ATOM feeds.
<%= Clinton GallagherNot exactly a relational model, but it can give you some ideas "XML to SQL:
Using SQLXML Bulkload in the .NET Framework"
http://msdn.microsoft.com/library/d... />
sqlxml.asp
Cristian Lefter, SQL Server MVP
"clintonG" < csgallagher@.REMOVETHISTEXTmetromilwaukee
.com> wrote in message
news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
> I'm fishing for a model somebody may choose to give me or refer to
> documentation for a schema that documents a design for storing RSS and/or
> ATOM feeds.
> <%= Clinton Gallagher
>|||Good starting point.
<%= Clinton Gallagher
"Cristian Lefter" <nospam_CristianLefter@.hotmail.com> wrote in message
news:u3%23OBNZVFHA.612@.TK2MSFTNGP12.phx.gbl...
> Not exactly a relational model, but it can give you some ideas "XML to
> SQL: Using SQLXML Bulkload in the .NET Framework"
> http://msdn.microsoft.com/library/d...>
chsqlxml.asp
> Cristian Lefter, SQL Server MVP
> "clintonG" < csgallagher@.REMOVETHISTEXTmetromilwaukee
.com> wrote in message
> news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
>

RSS Relational Model?

I'm fishing for a model somebody may choose to give me or refer to
documentation for a schema that documents a design for storing RSS and/or
ATOM feeds.
<%= Clinton GallagherNot exactly a relational model, but it can give you some ideas "XML to SQL:
Using SQLXML Bulkload in the .NET Framework"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp
Cristian Lefter, SQL Server MVP
"clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
> I'm fishing for a model somebody may choose to give me or refer to
> documentation for a schema that documents a design for storing RSS and/or
> ATOM feeds.
> <%= Clinton Gallagher
>|||Good starting point.
<%= Clinton Gallagher
"Cristian Lefter" <nospam_CristianLefter@.hotmail.com> wrote in message
news:u3%23OBNZVFHA.612@.TK2MSFTNGP12.phx.gbl...
> Not exactly a relational model, but it can give you some ideas "XML to
> SQL: Using SQLXML Bulkload in the .NET Framework"
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp
> Cristian Lefter, SQL Server MVP
> "clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
> news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
>> I'm fishing for a model somebody may choose to give me or refer to
>> documentation for a schema that documents a design for storing RSS and/or
>> ATOM feeds.
>> <%= Clinton Gallagher
>

RSS or Atom Relational Model?

I'm fishing for a model somebody may choose to give me or refer to
documentation for a schema that documents a design for storing RSS and/or
ATOM feeds.
<%= Clinton GallagherThis is an article about using xml bulkload to store RSS feeds in a database
.
It includes a simple annotated XSD schema.
http://msdn.microsoft.com/xml/build.../exchsqlxml.asp
It may be what you are looking for.
-Todd
"clintonG" wrote:

> I'm fishing for a model somebody may choose to give me or refer to
> documentation for a schema that documents a design for storing RSS and/or
> ATOM feeds.
> <%= Clinton Gallagher
>
>|||Thanks Todd. That's a good start.
<%= Clinton Gallagher
"Todd Pfleiger [MSFT]" <ToddPfleigerMSFT@.discussions.microsoft.com> wrote in
message news:66D653E6-E1CC-4C64-86DE-D7F3441906A5@.microsoft.com...
> This is an article about using xml bulkload to store RSS feeds in a
> database.
> It includes a simple annotated XSD schema.
> http://msdn.microsoft.com/xml/build.../exchsqlxml.asp
> It may be what you are looking for.
> -Todd
> "clintonG" wrote:
>

RSS or Atom Relational Model?

I'm fishing for a model somebody may choose to give me or refer to
documentation for a schema that documents a design for storing RSS and/or
ATOM feeds.
<%= Clinton Gallagher
This is an article about using xml bulkload to store RSS feeds in a database.
It includes a simple annotated XSD schema.
http://msdn.microsoft.com/xml/buildi...exchsqlxml.asp
It may be what you are looking for.
-Todd
"clintonG" wrote:

> I'm fishing for a model somebody may choose to give me or refer to
> documentation for a schema that documents a design for storing RSS and/or
> ATOM feeds.
> <%= Clinton Gallagher
>
>
|||Thanks Todd. That's a good start.
<%= Clinton Gallagher
"Todd Pfleiger [MSFT]" <ToddPfleigerMSFT@.discussions.microsoft.com> wrote in
message news:66D653E6-E1CC-4C64-86DE-D7F3441906A5@.microsoft.com...[vbcol=seagreen]
> This is an article about using xml bulkload to store RSS feeds in a
> database.
> It includes a simple annotated XSD schema.
> http://msdn.microsoft.com/xml/buildi...exchsqlxml.asp
> It may be what you are looking for.
> -Todd
> "clintonG" wrote: