Northwind database

Hello,
Can somebody send me the Nortwind database?
The MDF file or the sql file with the creates and inserts.
Thanks!
Arjenthere is a script on CD or in SQL folder to recreate Northwind. I don't
have SQL CD with me at this moment but I will look later. It must be there.
"Arjen" <boah123@.hotmail.com> wrote in message
news:bu9f45$eml$1@.news3.tilbu1.nb.home.nl...

quote:

---

> Hello,
> Can somebody send me the Nortwind database?
> The MDF file or the sql file with the creates and inserts.
> Thanks!
> Arjen
>
>

---

|||The script to create Northwind is part of the SQLServer distribution.
The file is called instnwnd.sql and the default path where it's located is:
C:\Program Files\Microsoft SQL Server\MSSQL\Install
David Portas
--
Please reply only to the newsgroup
--|||Okay! If you can find it... thaks!
Bacause I can't find it!
Thanks,
Arjen
"ME" <mail@.moon.net> schreef in bericht
news:%233R3VwG3DHA.2060@.TK2MSFTNGP10.phx.gbl...

quote:

---

> there is a script on CD or in SQL folder to recreate Northwind. I don't
> have SQL CD with me at this moment but I will look later. It must be

---

there.

quote:

---

> "Arjen" <boah123@.hotmail.com> wrote in message
> news:bu9f45$eml$1@.news3.tilbu1.nb.home.nl...
>

---

|||Correct!
Thanks!
Arjen
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> schreef in bericht
news:Jsqdncz5V9V-2ZXdRVn-gQ@.giganews.com...

quote:

---

> The script to create Northwind is part of the SQLServer distribution.
> The file is called instnwnd.sql and the default path where it's located

---

is:

quote:

---

> C:\Program Files\Microsoft SQL Server\MSSQL\Install
> --
> David Portas
> --
> Please reply only to the newsgroup
> --
>

---

|||Found it!
Thanks for your support!
Arjen
"ME" <mail@.moon.net> schreef in bericht
news:%233R3VwG3DHA.2060@.TK2MSFTNGP10.phx.gbl...

quote:

---

> there is a script on CD or in SQL folder to recreate Northwind. I don't
> have SQL CD with me at this moment but I will look later. It must be

---

there.

quote:

---

> "Arjen" <boah123@.hotmail.com> wrote in message
> news:bu9f45$eml$1@.news3.tilbu1.nb.home.nl...
>

---

Northwind database

Hello,
Can somebody send me the Nortwind database?
The MDF file or the sql file with the creates and inserts.
Thanks!
Arjenthere is a script on CD or in SQL folder to recreate Northwind. I don't
have SQL CD with me at this moment but I will look later. It must be there.
"Arjen" <boah123@.hotmail.com> wrote in message
news:bu9f45$eml$1@.news3.tilbu1.nb.home.nl...
> Hello,
> Can somebody send me the Nortwind database?
> The MDF file or the sql file with the creates and inserts.
> Thanks!
> Arjen
>
>|||The script to create Northwind is part of the SQLServer distribution.
The file is called instnwnd.sql and the default path where it's located is:
C:\Program Files\Microsoft SQL Server\MSSQL\Install
--
David Portas
--
Please reply only to the newsgroup
--|||Okay! If you can find it... thaks!
Bacause I can't find it!
Thanks,
Arjen
"ME" <mail@.moon.net> schreef in bericht
news:%233R3VwG3DHA.2060@.TK2MSFTNGP10.phx.gbl...
> there is a script on CD or in SQL folder to recreate Northwind. I don't
> have SQL CD with me at this moment but I will look later. It must be
there.
> "Arjen" <boah123@.hotmail.com> wrote in message
> news:bu9f45$eml$1@.news3.tilbu1.nb.home.nl...
> > Hello,
> >
> > Can somebody send me the Nortwind database?
> > The MDF file or the sql file with the creates and inserts.
> >
> > Thanks!
> > Arjen
> >
> >
> >
>|||Correct!
Thanks!
Arjen
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> schreef in bericht
news:Jsqdncz5V9V-2ZXdRVn-gQ@.giganews.com...
> The script to create Northwind is part of the SQLServer distribution.
> The file is called instnwnd.sql and the default path where it's located
is:
> C:\Program Files\Microsoft SQL Server\MSSQL\Install
> --
> David Portas
> --
> Please reply only to the newsgroup
> --
>|||Found it!
Thanks for your support!
Arjen
"ME" <mail@.moon.net> schreef in bericht
news:%233R3VwG3DHA.2060@.TK2MSFTNGP10.phx.gbl...
> there is a script on CD or in SQL folder to recreate Northwind. I don't
> have SQL CD with me at this moment but I will look later. It must be
there.
> "Arjen" <boah123@.hotmail.com> wrote in message
> news:bu9f45$eml$1@.news3.tilbu1.nb.home.nl...
> > Hello,
> >
> > Can somebody send me the Nortwind database?
> > The MDF file or the sql file with the creates and inserts.
> >
> > Thanks!
> > Arjen
> >
> >
> >
>

NOP in sysprocesses (cmd column)

Can somebody please tell me what 'NOP' is in the cmd column of sysprocesses
(SQL2K) noticed this when a stored procedure was running . .. I could not
find anything about this cmd (relating to SQL) on the internet . . .however
there were some references to NOP in c# and .NET programming
Thanks for your help
Olu Adedeji
Baysignia Systems
In other areas NOP means "No Operation", but I do not know if that is true
here..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Olu Adedeji" <OluAdedeji@.discussions.microsoft.com> wrote in message
news:ACD1A5E9-503C-41D7-9F6D-9C8D2ABA7EFD@.microsoft.com...
> Can somebody please tell me what 'NOP' is in the cmd column of
sysprocesses
> (SQL2K) noticed this when a stored procedure was running . .. I could not
> find anything about this cmd (relating to SQL) on the internet . .
..however
> there were some references to NOP in c# and .NET programming
> Thanks for your help
>
> Olu Adedeji
> Baysignia Systems
|||Thanks Wayne
"Wayne Snyder" wrote:

> In other areas NOP means "No Operation", but I do not know if that is true
> here..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.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
> "Olu Adedeji" <OluAdedeji@.discussions.microsoft.com> wrote in message
> news:ACD1A5E9-503C-41D7-9F6D-9C8D2ABA7EFD@.microsoft.com...
> sysprocesses
> ..however
>
>

NOP in sysprocesses (cmd column)

Can somebody please tell me what 'NOP' is in the cmd column of sysprocesses
(SQL2K) noticed this when a stored procedure was running . .. I could not
find anything about this cmd (relating to SQL) on the internet . . .however
there were some references to NOP in c# and .NET programming
Thanks for your help
Olu Adedeji
Baysignia SystemsIn other areas NOP means "No Operation", but I do not know if that is true
here..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Olu Adedeji" <OluAdedeji@.discussions.microsoft.com> wrote in message
news:ACD1A5E9-503C-41D7-9F6D-9C8D2ABA7EFD@.microsoft.com...
> Can somebody please tell me what 'NOP' is in the cmd column of
sysprocesses
> (SQL2K) noticed this when a stored procedure was running . .. I could not
> find anything about this cmd (relating to SQL) on the internet . .
.however
> there were some references to NOP in c# and .NET programming
> Thanks for your help
>
> Olu Adedeji
> Baysignia Systems|||Thanks Wayne
"Wayne Snyder" wrote:

> In other areas NOP means "No Operation", but I do not know if that is true
> here..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.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
> "Olu Adedeji" <OluAdedeji@.discussions.microsoft.com> wrote in message
> news:ACD1A5E9-503C-41D7-9F6D-9C8D2ABA7EFD@.microsoft.com...
> sysprocesses
> ..however
>
>

NOP in sysprocesses (cmd column)

Can somebody please tell me what 'NOP' is in the cmd column of sysprocesses
(SQL2K) noticed this when a stored procedure was running . .. I could not
find anything about this cmd (relating to SQL) on the internet . . .however
there were some references to NOP in c# and .NET programming
Thanks for your help
Olu Adedeji
Baysignia SystemsIn other areas NOP means "No Operation", but I do not know if that is true
here..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Olu Adedeji" <OluAdedeji@.discussions.microsoft.com> wrote in message
news:ACD1A5E9-503C-41D7-9F6D-9C8D2ABA7EFD@.microsoft.com...
> Can somebody please tell me what 'NOP' is in the cmd column of
sysprocesses
> (SQL2K) noticed this when a stored procedure was running . .. I could not
> find anything about this cmd (relating to SQL) on the internet . .
.however
> there were some references to NOP in c# and .NET programming
> Thanks for your help
>
> Olu Adedeji
> Baysignia Systems|||Thanks Wayne
"Wayne Snyder" wrote:
> In other areas NOP means "No Operation", but I do not know if that is true
> here..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.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
> "Olu Adedeji" <OluAdedeji@.discussions.microsoft.com> wrote in message
> news:ACD1A5E9-503C-41D7-9F6D-9C8D2ABA7EFD@.microsoft.com...
> > Can somebody please tell me what 'NOP' is in the cmd column of
> sysprocesses
> > (SQL2K) noticed this when a stored procedure was running . .. I could not
> > find anything about this cmd (relating to SQL) on the internet . .
> ..however
> > there were some references to NOP in c# and .NET programming
> >
> > Thanks for your help
> >
> >
> > Olu Adedeji
> > Baysignia Systems
>
>sql

No Transaction is Active

Hi,
I have a COM+ Application written by somebody else, and when I am calling
one function, it is returning an "No Transaction Is Active". I have looked a
t
the code, and cannot see why. I have the same version of the dll running
perfectly fine on other servers, so I cannot see that it is the code that is
at fault, so I am left to believe that it is being returned by SQL Server
(SQL Server 2000, SP4).
Can anyone help explain what the error message means and why it is coming up
?
Regards
SamHi
Are you getting error numbers 3902/3903? In which case you are trying to
ROLLBACK/COMMIT without a BEGIN TRANSACTION. You may want to use SQL Profile
r
to see where this is occuring.
e.g. instances such as
http://support.microsoft.com/defaul...kb;en-us;231987
http://support.microsoft.com/defaul...kb;en-us;223213
John
"Sam Coleman" wrote:

> Hi,
> I have a COM+ Application written by somebody else, and when I am calling
> one function, it is returning an "No Transaction Is Active". I have looked
at
> the code, and cannot see why. I have the same version of the dll running
> perfectly fine on other servers, so I cannot see that it is the code that
is
> at fault, so I am left to believe that it is being returned by SQL Server
> (SQL Server 2000, SP4).
> Can anyone help explain what the error message means and why it is coming
up?
> Regards
> Sam