Can I Install Enterprise edition on Windows 2000 Server as in Small Business Ser

Hi.
We have Windows 2000 Small Business Server
In control panel/System the operating system is identified
as
Windows 2000 server service pack 4
Microsoft pages on System requirements for SQL Server
Enterprise edition says requires Windows 2000 Server
The operating system I have seems to be Windows 2000
Server even though it has some junk in it making it
Windows 2000 Small Business Server.
Question can i Install SQL Server 2000 Enterprise?
I need this because i need to use Indexed Views which do
not exist in Sql Server standard edition.
THe answer varies depending on whome i ask at Microsoft.
Apreciate any advice.Hi
There is no mention of SBS on the system requirements at
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp
even though SQL Server comes with it!!
I have never tried installing this onto a specific SBS system, so can not be
100% but I am pretty sure that it is no different. If you do help/about
windows in Windows Explorer and it says Microsoft (R) Windows Version 5.0
then I don't think there would be any reason for it not to.
John
"Wayne Wilson" <anonymous@.discussions.microsoft.com> wrote in message
news:904101c43310$657e3600$a101280a@.phx.gbl...
> Hi.
> We have Windows 2000 Small Business Server
> In control panel/System the operating system is identified
> as
> Windows 2000 server service pack 4
> Microsoft pages on System requirements for SQL Server
> Enterprise edition says requires Windows 2000 Server
> The operating system I have seems to be Windows 2000
> Server even though it has some junk in it making it
> Windows 2000 Small Business Server.
> Question can i Install SQL Server 2000 Enterprise?
> I need this because i need to use Indexed Views which do
> not exist in Sql Server standard edition.
> THe answer varies depending on whome i ask at Microsoft.
> Apreciate any advice.
>|||Please do not post the same message independently in different newsgroups, I
posted an answer in .setup.
--
Jacco Schalkwijk
SQL Server MVP
"Wayne Wilson" <anonymous@.discussions.microsoft.com> wrote in message
news:904101c43310$657e3600$a101280a@.phx.gbl...
> Hi.
> We have Windows 2000 Small Business Server
> In control panel/System the operating system is identified
> as
> Windows 2000 server service pack 4
> Microsoft pages on System requirements for SQL Server
> Enterprise edition says requires Windows 2000 Server
> The operating system I have seems to be Windows 2000
> Server even though it has some junk in it making it
> Windows 2000 Small Business Server.
> Question can i Install SQL Server 2000 Enterprise?
> I need this because i need to use Indexed Views which do
> not exist in Sql Server standard edition.
> THe answer varies depending on whome i ask at Microsoft.
> Apreciate any advice.
>

Can I hide system objects in QA like in EM

...using SQL SERVER 2k
I know how to hide system objects in Enterprise Manager, but can this same
sort of thing be done in Query Analyzer... like what I see done on the Server
tab of Visual Studio?
thanks
kevin
No, that functionality is not available in QA. All you have is the pre-defined folders for user
tables and system tables. No such for stored procedures, but I hope that you don't have user
procedures in master? :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kevin" <kevin@.discussions.microsoft.com> wrote in message
news:56016547-01C2-4E59-9F6B-5FD784744711@.microsoft.com...
> ...using SQL SERVER 2k
> I know how to hide system objects in Enterprise Manager, but can this same
> sort of thing be done in Query Analyzer... like what I see done on the Server
> tab of Visual Studio?
> thanks
> kevin
|||"Tibor Karaszi" wrote:

> No, that functionality is not available in QA. All you have is the pre-defined folders for user
> tables and system tables. No such for stored procedures, but I hope that you don't have user
> procedures in master? :-)
No, of course not. And I am not referring to the master, model, etc database.
In Enterprise Manager, in user created databases there are a number of SPs,
tables and views that are hidden if you select to hide system objects.
Obviously SQL SERVER/EM is intelligent enough to recognize the difference,
but Query Analyzer doesn't seem to be able to. Even users restricted to a
single DB can see master in QA.
It leads to a lot of scrolling to get to that one SP.
thanks
kevin
|||I see what you mean.
QA:
Tables:
These are already in separate folders, right?
Procedures:
You can delete the dt_ procedures, but they will come back when anyone uses EM to create diagram
etc.
Views:
The three system views will always be shown.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kevin" <kevin@.discussions.microsoft.com> wrote in message
news:7BC4ED53-51A9-441C-BA8F-F5318B56FE7B@.microsoft.com...
> "Tibor Karaszi" wrote:
>
> No, of course not. And I am not referring to the master, model, etc database.
> In Enterprise Manager, in user created databases there are a number of SPs,
> tables and views that are hidden if you select to hide system objects.
> Obviously SQL SERVER/EM is intelligent enough to recognize the difference,
> but Query Analyzer doesn't seem to be able to. Even users restricted to a
> single DB can see master in QA.
> It leads to a lot of scrolling to get to that one SP.
> thanks
> kevin
|||Ah!!! Now you see. Its only the SP's that are a pain... honestly my middle
finger is cramping from all this damn scrolling. I just have to increase the
number of lines the scroll button moves with the mouse setup.
peace
kevin
"Tibor Karaszi" wrote:

> I see what you mean.
> QA:
> Tables:
> These are already in separate folders, right?
> Procedures:
> You can delete the dt_ procedures, but they will come back when anyone uses EM to create diagram
> etc.
> Views:
> The three system views will always be shown.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "kevin" <kevin@.discussions.microsoft.com> wrote in message
> news:7BC4ED53-51A9-441C-BA8F-F5318B56FE7B@.microsoft.com...
>
>

can i get the output of 'sp_columns' system SP into a table through T-SQL

Hi,
I want to collect the output of system stored procedure 'sp_columns' into a temporary table. Please suggest how can i achieve this.

Ashu Sharma

Create a temp table with columns as described at sp_columns in BOL and then do
INSERT INTO your_temp_table EXEC sp_columns
--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de|||Thanks Franksql

Can I connect without server?

Hi,
I have a customers program on my system - Omin 7 as at
http://www.omnis.net/products/omnis7/ - so I can pull the data into an
Access Database. I'd like to do this work at my place not theirs!
Is there anyway I can set up an ODBC connection so that I can read the
files. The .dsn file reads:
[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=salesteam
WSID=JERRY
APP=Microsoft(R) Windows(R) Operating System
SERVER=NTSERVER
if that helps at all.
I'm running Windows XP Pro. I guess the problem is that I don't have a
server '
Any help would be greatly appreciated, thank you.
JonAre you saying you are running SQL Server on XP? Then it should work
provided you've got file and printer sharing enabled.
If this is not the case, please elaborate on what you are attempting?
Steve
"Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
news:btk6qv$t3f$1@.hercules.btinternet.com...

quote:

---

> Hi,
> I have a customers program on my system - Omin 7 as at
> http://www.omnis.net/products/omnis7/ - so I can pull the data into an
> Access Database. I'd like to do this work at my place not theirs!
> Is there anyway I can set up an ODBC connection so that I can read the
> files. The .dsn file reads:
> [ODBC]
> DRIVER=SQL Server
> UID=sa
> DATABASE=salesteam
> WSID=JERRY
> APP=Microsoft(R) Windows(R) Operating System
> SERVER=NTSERVER
> if that helps at all.
> I'm running Windows XP Pro. I guess the problem is that I don't have a
> server '
> Any help would be greatly appreciated, thank you.
> Jon
>

---

|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.odbc:41677
Steve,
I have NOT got sql server running, just XP PRo with IIS.
Is there any way around this - without installing sql server?
Thanks
Jon
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:uNlSD3u1DHA.2184@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Are you saying you are running SQL Server on XP? Then it should work
> provided you've got file and printer sharing enabled.
> If this is not the case, please elaborate on what you are attempting?
> Steve
> "Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
> news:btk6qv$t3f$1@.hercules.btinternet.com...
>

---

|||"Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
news:btpipc$mtu$1@.hercules.btinternet.com...

quote:

---

> I have NOT got sql server running, just XP PRo with IIS.

---

It's still not clear to me what you are attempting, I asked you to elaborate
and I'm only getting little tidbits.

quote:

---

> Is there any way around this - without installing sql server?

---

Is the source data you need in SQL Server? You can get the SQL Server 2000
developers edition for $49 USD.
I wish I could provide a better answer, however lack of detail is not
helping...
Steve

quote:

---

> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:uNlSD3u1DHA.2184@.TK2MSFTNGP12.phx.gbl...
a[QUOTE]
>

---

Can connect to 'ServerName' but not to its IP address

I'm using SQL Manager from my Enterprise server to connect to my SQL Express server that will act as a witness to a db mirroring system. If I try to connect to the SQL Express server using its IP address, I get a "named pipes error 53." If I connect by browsing the network and connect to the Name of the Server "Machinename\SQLExpress", I am successful. I would like to be able to connect to the IP directly as it's not dependant upon certain services to be started or configured a certain way.

Thank you,

ChadTry Data Source=tcp:192.168.0.3,1433 in your connection string using applicable IP and port number (remember to setup port number in SQL Configuration Manager on the SQL Express machine).

Can CASE match more than once ?

Hi
I'm tring to write a statement to analyse what orders were open on the first
day of each month from a system and return one data set with the months
listed and all the orders open during that month. eg.
Mon Order_No
Jan 001
Jan 002
Jan 003
Feb 002
Feb 003
Feb 004
The orders all have an open and closed date, so I want to check for each
month if the first of the month falls between the open and closed date of
each order.
I've set up a dummy database for testing - what I'd like to know is whether
CASE statements be made to match more than once :
SELECT MyNewField =
CASE
WHEN data1 = 1 THEN 'Is One'
WHEN data1 > 1 then 'Not One'
end,
data2
FROM APW_Test
my table is as follows
data1
1
2
3
4
So I would hope to see one result for the number 1 (Is One) and two results
for the remaining numbers because they match both case statements. However,
CASE seems to match the first statement and then stop for each record.
Is there a way I can achieve the result I want fairly simply ?
Thanks in advance.
AndrewHi ... I made a mistake in my logic. What I meant was

> WHEN data1 = 1 THEN 'Is One'
> WHEN data1 > 0 then 'Greater Than Zero'
so I expect 1 to appear twice. All else the same.
"Andrew Webb" <andrew.webb@.eme-med.co.uk> wrote in message
news:uMs5zBpuFHA.1256@.TK2MSFTNGP09.phx.gbl...
> Hi
> I'm tring to write a statement to analyse what orders were open on the
> first day of each month from a system and return one data set with the
> months listed and all the orders open during that month. eg.
> Mon Order_No
> Jan 001
> Jan 002
> Jan 003
> Feb 002
> Feb 003
> Feb 004
> The orders all have an open and closed date, so I want to check for each
> month if the first of the month falls between the open and closed date of
> each order.
> I've set up a dummy database for testing - what I'd like to know is
> whether CASE statements be made to match more than once :
> SELECT MyNewField =
> CASE
> WHEN data1 = 1 THEN 'Is One'
> WHEN data1 > 1 then 'Not One'
> end,
> data2
> FROM APW_Test
> my table is as follows
> data1
> 1
> 2
> 3
> 4
> So I would hope to see one result for the number 1 (Is One) and two
> results for the remaining numbers because they match both case statements.
> However, CASE seems to match the first statement and then stop for each
> record.
> Is there a way I can achieve the result I want fairly simply ?
> Thanks in advance.
> Andrew
>|||Andrew
you can simply use procedure/function to use if condition.
However post DDL,Sample data to help you better
Regards
R.D
"Andrew Webb" wrote:

> Hi ... I made a mistake in my logic. What I meant was
>
> so I expect 1 to appear twice. All else the same.
>
> "Andrew Webb" <andrew.webb@.eme-med.co.uk> wrote in message
> news:uMs5zBpuFHA.1256@.TK2MSFTNGP09.phx.gbl...
>
>|||On Fri, 16 Sep 2005 08:39:06 +0100, "Andrew Webb"
<andrew.webb@.eme-med.co.uk> wrote:

> Hi ... I made a mistake in my logic. What I meant was
>
> so I expect 1 to appear twice. All else the same.
CASE returns only the first match.|||Andrew,
It sounds to me like you need a JOIN operation, not a CASE expression.
Post the CREATE TABLE and INSERT statements for some specific
data if you want a more careful answer, but this might be close:
select data1, DisplayAnswer
from T join (
select 'equal 1' as TestCondition, 'Is One' as DisplayAnswer
union all
select 'above 1', 'Not One'
) C
on (
TestCondition = 'equal 1' and data1 = 1
) or (
TestCondition = 'above 1' and data1 > 1
)
If you select only from your 4-row table, with no other table
joined in, you cannot obtain a result that contains any row
more than once.
Steve Kass
Drew University
"Andrew Webb" <andrew.webb@.eme-med.co.uk> wrote in message
news:uMs5zBpuFHA.1256@.TK2MSFTNGP09.phx.gbl...
> Hi
> I'm tring to write a statement to analyse what orders were open on the
> first day of each month from a system and return one data set with the
> months listed and all the orders open during that month. eg.
> Mon Order_No
> Jan 001
> Jan 002
> Jan 003
> Feb 002
> Feb 003
> Feb 004
> The orders all have an open and closed date, so I want to check for each
> month if the first of the month falls between the open and closed date of
> each order.
> I've set up a dummy database for testing - what I'd like to know is
> whether CASE statements be made to match more than once :
> SELECT MyNewField =
> CASE
> WHEN data1 = 1 THEN 'Is One'
> WHEN data1 > 1 then 'Not One'
> end,
> data2
> FROM APW_Test
> my table is as follows
> data1
> 1
> 2
> 3
> 4
> So I would hope to see one result for the number 1 (Is One) and two
> results for the remaining numbers because they match both case statements.
> However, CASE seems to match the first statement and then stop for each
> record.
> Is there a way I can achieve the result I want fairly simply ?
> Thanks in advance.
> Andrew
>|||On Fri, 16 Sep 2005 08:30:00 +0100, Andrew Webb wrote:

>Hi
>I'm tring to write a statement to analyse what orders were open on the firs
t
>day of each month from a system and return one data set with the months
>listed and all the orders open during that month. eg.
>Mon Order_No
>Jan 001
>Jan 002
>Jan 003
>Feb 002
>Feb 003
>Feb 004
>The orders all have an open and closed date, so I want to check for each
>month if the first of the month falls between the open and closed date of
>each order.
Hi Andrew,
You could use a calendar table or a table of integers to get this. I'll
give an example with a table of integers that's made up "on the fly".
You can expand it as needed, or make a real table of integers (as
explained on http://www.aspfaq.com/show.asp?id=2516).
DECLARE @.StartDate smalldatetime
,@.EndDate smalldatetime
SET @.StartDate = '20050101' -- Should be first of the month
SET @.EndDate = '20051201'
SELECT DATEADD(month, Numbers.n, @.StartDate) AS Mon,
Orders.Order_No
FROM Orders
INNER JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL
SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL
SELECT 9 UNION ALL SELECT 9 UNION ALL SELECT 10 UNION ALL
SELECT 11 UNION ALL SELECT 12 UNION ALL SELECT 13 UNION ALL
SELECT 14 UNION ALL SELECT 15) AS Numbers(n)
WHERE Orders.OpenDate < DATEADD(month, Numbers.n, @.StartDate)
AND Orders.CloseDate > DATEADD(month, Numbers.n, @.StartDate)
AND DATEADD(month, Numbers.n, @.StartDate) <= @.EndDate
ORDER BY Numbers.n, Orders.Order_No
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Can anyone Help me ?

Hi all,
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
sam
Let me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>
|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>
|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
[vbcol=seagreen]
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doamin
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able to
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...

Can anyone Help me ?

Hi all,
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
samLet me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doamin
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able to
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> > Hi all,
> >
> > I am very new to SQL Server 2000
> > my problem is that to connect to sql server from a client computer
> > first i have to log in to the system in which the sql server is
> > installed
> > is it possible that i dont have to login to the computer
> > so that i just open the query analyzer and just login with the sql
> > server user account i dont want to give the login & the password of the
> > windows
> >
> >
> > can any one help me in this
> > is this possible
> >
> > sam
> >

Can anyone Help me ?

Hi all,
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
samLet me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
[vbcol=seagreen]
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doami
n
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able t
o
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...

Can anyone help and tell me what i am doing wrong?

Here is the code

Line 84:
Line 85: searchDataAdapter = New System.data.sqlclient.sqldataadapter("SELECT * FROM Inventory Where title=" & title, searchConnection)
Line 86: searchDataAdapter.Fill(objItemInfo, "ItemInfo")
Line 87:
Line 88: Return objItemInfo

here is the error
Line 1: Incorrect syntax near '='.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '='.

Source Error:

Try adding single quotes:

searchDataAdapter = New System.data.sqlclient.sqldataadapter("SELECT * FROM Inventory Where title='" & title & "'", searchConnection)

HTH,
Ryan

|||Hey Thanks, it worked....I knew it was something simple like that|||

try this

SELECT * FROM Inventory Where title=' " & title & " '

Can an Optron X2 be used as a SQL server

Hello,
A DBA friend of mine wants to know if he can use an Optron X2 based system
as a SQL server. He tried running:
Win2003 64bit Server
MS SQL 2000 w/SP4
2 Gig of RAM
1 TB HD array.
He wants to process a lot of financial data and use the MS SQL to do it.
When he ran the above setup everything seemed fine but 15 hours later all his
data was corrupted. He said it was the Optron processor's fault as they are
not 100% compatable. He is an experienced DBA.
Questions:
1. Will the above configuration work?
2. My DBA friend said that SP4 only supported Intel chips and would not
work for AMD, is that true? I have looked through the SP4 page and found no
reference to Intel or AMD only updates.
3. Since Win2003 64-bit only runs SQL 2000 SP4 through a 32-bit emulator, is
there an advantage in going with Win2003-64 or would the 32-bit version be
fine?
4. What about the upcomming SQL 2005, will that have native support for
64-bit?
5. Will the Upcomming SQL 2005 on Win2003-64bit Server work with AMD Optron
X2 (Dual Core) Chips? Is there anything Intel Only about the design?Hello,
If no one can answer this questions directly, can you at least point me into
the right direction. As far as I can tell AMD is 100% compatable with
Win2003 64-bit and SQL 2000 SP4 should work fine, but I am not a DBA and my
friend will not just take my word for it.
Does anyone know how I can get MS to answer these questions?
"Roger Huston" wrote:
> Hello,
> A DBA friend of mine wants to know if he can use an Optron X2 based system
> as a SQL server. He tried running:
> Win2003 64bit Server
> MS SQL 2000 w/SP4
> 2 Gig of RAM
> 1 TB HD array.
> He wants to process a lot of financial data and use the MS SQL to do it.
> When he ran the above setup everything seemed fine but 15 hours later all his
> data was corrupted. He said it was the Optron processor's fault as they are
> not 100% compatable. He is an experienced DBA.
> Questions:
> 1. Will the above configuration work?
> 2. My DBA friend said that SP4 only supported Intel chips and would not
> work for AMD, is that true? I have looked through the SP4 page and found no
> reference to Intel or AMD only updates.
> 3. Since Win2003 64-bit only runs SQL 2000 SP4 through a 32-bit emulator, is
> there an advantage in going with Win2003-64 or would the 32-bit version be
> fine?
> 4. What about the upcomming SQL 2005, will that have native support for
> 64-bit?
> 5. Will the Upcomming SQL 2005 on Win2003-64bit Server work with AMD Optron
> X2 (Dual Core) Chips? Is there anything Intel Only about the design?|||Changes to SQL Server 2000 Service Pack 4 operating system support
http://support.microsoft.com/default.aspx?scid=kb;en-us;898042
Reading this article indicates that SQL 2000 SP4 is specifically compatible
with x64 operating systems running on Opteron processors. My suspicion
would be on the disk subsystem. SQL tends to push a disk system far harder
than any other application.
Here is a tool to stress your disk system and tell whether it can hold up to
SQL Server or not:
How to use the SQLIOStress utility to stress a disk subsystem such as SQL
Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;231619
SQL 2005 will run native on x64 architecture instead of in the 32-bit WOW
environment. Note that SQL 2005 has been in development as a native x64 app
for several years and Intel only recently released an x64 processor. That
should give a clue to what environment it must have been developed and
tested on. I would not worry about AMD compatibility going forward.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Roger Huston" <Roger Huston@.discussions.microsoft.com> wrote in message
news:25357B88-5460-4127-B97C-C020F57AD15A@.microsoft.com...
> Hello,
> A DBA friend of mine wants to know if he can use an Optron X2 based system
> as a SQL server. He tried running:
> Win2003 64bit Server
> MS SQL 2000 w/SP4
> 2 Gig of RAM
> 1 TB HD array.
> He wants to process a lot of financial data and use the MS SQL to do it.
> When he ran the above setup everything seemed fine but 15 hours later all
> his
> data was corrupted. He said it was the Optron processor's fault as they
> are
> not 100% compatable. He is an experienced DBA.
> Questions:
> 1. Will the above configuration work?
> 2. My DBA friend said that SP4 only supported Intel chips and would not
> work for AMD, is that true? I have looked through the SP4 page and found
> no
> reference to Intel or AMD only updates.
> 3. Since Win2003 64-bit only runs SQL 2000 SP4 through a 32-bit emulator,
> is
> there an advantage in going with Win2003-64 or would the 32-bit version be
> fine?
> 4. What about the upcomming SQL 2005, will that have native support for
> 64-bit?
> 5. Will the Upcomming SQL 2005 on Win2003-64bit Server work with AMD
> Optron
> X2 (Dual Core) Chips? Is there anything Intel Only about the design?|||Well, he has a SATA II array. Since this was not a multi-user system more
just plugging through large tables, he thought he could get by with this for
personal work, but I will use your tool just to be sure.
Thanks,
Roger
"Geoff N. Hiten" wrote:
> Changes to SQL Server 2000 Service Pack 4 operating system support
> http://support.microsoft.com/default.aspx?scid=kb;en-us;898042
> Reading this article indicates that SQL 2000 SP4 is specifically compatible
> with x64 operating systems running on Opteron processors. My suspicion
> would be on the disk subsystem. SQL tends to push a disk system far harder
> than any other application.
> Here is a tool to stress your disk system and tell whether it can hold up to
> SQL Server or not:
> How to use the SQLIOStress utility to stress a disk subsystem such as SQL
> Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;231619
> SQL 2005 will run native on x64 architecture instead of in the 32-bit WOW
> environment. Note that SQL 2005 has been in development as a native x64 app
> for several years and Intel only recently released an x64 processor. That
> should give a clue to what environment it must have been developed and
> tested on. I would not worry about AMD compatibility going forward.
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Roger Huston" <Roger Huston@.discussions.microsoft.com> wrote in message
> news:25357B88-5460-4127-B97C-C020F57AD15A@.microsoft.com...
> > Hello,
> >
> > A DBA friend of mine wants to know if he can use an Optron X2 based system
> > as a SQL server. He tried running:
> >
> > Win2003 64bit Server
> > MS SQL 2000 w/SP4
> > 2 Gig of RAM
> > 1 TB HD array.
> >
> > He wants to process a lot of financial data and use the MS SQL to do it.
> > When he ran the above setup everything seemed fine but 15 hours later all
> > his
> > data was corrupted. He said it was the Optron processor's fault as they
> > are
> > not 100% compatable. He is an experienced DBA.
> >
> > Questions:
> > 1. Will the above configuration work?
> >
> > 2. My DBA friend said that SP4 only supported Intel chips and would not
> > work for AMD, is that true? I have looked through the SP4 page and found
> > no
> > reference to Intel or AMD only updates.
> >
> > 3. Since Win2003 64-bit only runs SQL 2000 SP4 through a 32-bit emulator,
> > is
> > there an advantage in going with Win2003-64 or would the 32-bit version be
> > fine?
> >
> > 4. What about the upcomming SQL 2005, will that have native support for
> > 64-bit?
> >
> > 5. Will the Upcomming SQL 2005 on Win2003-64bit Server work with AMD
> > Optron
> > X2 (Dual Core) Chips? Is there anything Intel Only about the design?
>
>

Can a recompile lock up system tables?

One developer complained he could not use EM to see the list of UDFs,
it seemed hung. Running sp_who2 showed another developer was blocking
him. This second developer had been running a hundred lines of code
in QA, and had aborted the batch. Apparently this left the
transaction hanging open, we see that a lot. But my question is, how
did this end up blocking EM from enumerating UDFs? What else was
locked out? Is this serious, or just a problem with EM?
I speculate that SQLServer decided to recompile a UDF inside of this
transaction, and that aborting it somehow left the lock in place on
some important system table. Is this likely?
Thanks.
J.jxstern wrote:
> One developer complained he could not use EM to see the list of UDFs,
> it seemed hung. Running sp_who2 showed another developer was blocking
> him. This second developer had been running a hundred lines of code
> in QA, and had aborted the batch. Apparently this left the
> transaction hanging open, we see that a lot. But my question is, how
> did this end up blocking EM from enumerating UDFs? What else was
> locked out? Is this serious, or just a problem with EM?
> I speculate that SQLServer decided to recompile a UDF inside of this
> transaction, and that aborting it somehow left the lock in place on
> some important system table. Is this likely?
> Thanks.
> J.
If you stop a transaction from Query Analyzer, then you must issue a
rollback if you are in a transaction. If you don't, you leave the
transaction open. The procedure could have accessed a system table and
without the rollback, left the locks in place on the table.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Can a recompile lock up system tables?

One developer complained he could not use EM to see the list of UDFs,
it seemed hung. Running sp_who2 showed another developer was blocking
him. This second developer had been running a hundred lines of code
in QA, and had aborted the batch. Apparently this left the
transaction hanging open, we see that a lot. But my question is, how
did this end up blocking EM from enumerating UDFs? What else was
locked out? Is this serious, or just a problem with EM?
I speculate that SQLServer decided to recompile a UDF inside of this
transaction, and that aborting it somehow left the lock in place on
some important system table. Is this likely?
Thanks.
J.jxstern wrote:
> One developer complained he could not use EM to see the list of UDFs,
> it seemed hung. Running sp_who2 showed another developer was blocking
> him. This second developer had been running a hundred lines of code
> in QA, and had aborted the batch. Apparently this left the
> transaction hanging open, we see that a lot. But my question is, how
> did this end up blocking EM from enumerating UDFs? What else was
> locked out? Is this serious, or just a problem with EM?
> I speculate that SQLServer decided to recompile a UDF inside of this
> transaction, and that aborting it somehow left the lock in place on
> some important system table. Is this likely?
> Thanks.
> J.
If you stop a transaction from Query Analyzer, then you must issue a
rollback if you are in a transaction. If you don't, you leave the
transaction open. The procedure could have accessed a system table and
without the rollback, left the locks in place on the table.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Can a recompile lock up system tables?

One developer complained he could not use EM to see the list of UDFs,
it seemed hung. Running sp_who2 showed another developer was blocking
him. This second developer had been running a hundred lines of code
in QA, and had aborted the batch. Apparently this left the
transaction hanging open, we see that a lot. But my question is, how
did this end up blocking EM from enumerating UDFs? What else was
locked out? Is this serious, or just a problem with EM?
I speculate that SQLServer decided to recompile a UDF inside of this
transaction, and that aborting it somehow left the lock in place on
some important system table. Is this likely?
Thanks.
J.
jxstern wrote:
> One developer complained he could not use EM to see the list of UDFs,
> it seemed hung. Running sp_who2 showed another developer was blocking
> him. This second developer had been running a hundred lines of code
> in QA, and had aborted the batch. Apparently this left the
> transaction hanging open, we see that a lot. But my question is, how
> did this end up blocking EM from enumerating UDFs? What else was
> locked out? Is this serious, or just a problem with EM?
> I speculate that SQLServer decided to recompile a UDF inside of this
> transaction, and that aborting it somehow left the lock in place on
> some important system table. Is this likely?
> Thanks.
> J.
If you stop a transaction from Query Analyzer, then you must issue a
rollback if you are in a transaction. If you don't, you leave the
transaction open. The procedure could have accessed a system table and
without the rollback, left the locks in place on the table.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Can a recompile lock up system tables?

One developer complained he could not use EM to see the list of UDFs,
it seemed hung. Running sp_who2 showed another developer was blocking
him. This second developer had been running a hundred lines of code
in QA, and had aborted the batch. Apparently this left the
transaction hanging open, we see that a lot. But my question is, how
did this end up blocking EM from enumerating UDFs? What else was
locked out? Is this serious, or just a problem with EM?
I speculate that SQLServer decided to recompile a UDF inside of this
transaction, and that aborting it somehow left the lock in place on
some important system table. Is this likely?
Thanks.
J.jxstern wrote:
> One developer complained he could not use EM to see the list of UDFs,
> it seemed hung. Running sp_who2 showed another developer was blocking
> him. This second developer had been running a hundred lines of code
> in QA, and had aborted the batch. Apparently this left the
> transaction hanging open, we see that a lot. But my question is, how
> did this end up blocking EM from enumerating UDFs? What else was
> locked out? Is this serious, or just a problem with EM?
> I speculate that SQLServer decided to recompile a UDF inside of this
> transaction, and that aborting it somehow left the lock in place on
> some important system table. Is this likely?
> Thanks.
> J.
If you stop a transaction from Query Analyzer, then you must issue a
rollback if you are in a transaction. If you don't, you leave the
transaction open. The procedure could have accessed a system table and
without the rollback, left the locks in place on the table.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Can "Date Modified" col be automatically updated w/o trigger for each table?

Hello,

I am using SQL Server 2005 and ASP.NET 2.0. We have a very simple content management system where we have to keep track of date last modified for each row in all of our content tables. I know there's a "timestamp" datatype that is used for replication scenarios, but is there anything similar that I can use to set up a date_modified column for each of my content tables that will automatically update with GETDATE() whenever anything in a given row is updated?

Or do I have to create a date_modified column of smalldatetime datatype and write a trigger on update for EVERY single table of content that I have in the database? It seems there should be an easier way to do this than to write 20 triggers for my 20 content tables.

Thanks!

Using triggers is the only way I can think out for this issue, as you want to record every modification to each table:)