Does SQL substitute float = 0 with DBNull.Value?

Hi
I have only been coding in .Net for about six months, and am not sure if this is a C# problem or an SQL one. I use the Data Access Application Block in my program.

I have two optional fields on my form (RangeFrom and RangeTo). If the user chooses not to enter data into these textboxes(textbox = ""), an entry on the db is created with null values. It works.

But sometimes the user wants to enter 0 as either an upper or lower end of a range. This is where my problem comes in. My program saves 0 as null too.

In my program I do a test on the textboxes and populate two float values in a business object (objQuestion) accordingly, like this:

if (txtrangefrom.Text != "") {
objQuestion.RangeFrom=float.Parse(txtrangefrom.Text);
objQuestion.RangeTo=float.Parse(txtrangeto.Text);
}
else {
objQuestion.RangeFrom=Convert.ToSingle(null);
objQuestion.RangeTo=Convert.ToSingle(null);
}

And this is what my Business object look like. It sets up the parameters and calls the Data Access Application Block to create an entry in my table:

// fieldslist
float cvintRangeFrom;
float cvintRangeTo;
//properties
public float RangeFrom {
get {
return cvintRangeFrom;
}
set {
cvintRangeFrom = value;
}
}
public float RangeTo {
get {
return cvintRangeTo;
}
set {
cvintRangeTo = value;
}
}
// some code deleted for readability...
public int AddOption() {
string cvstrSpName = "addOption";
SqlParameter [] cvstrStoredParams = SqlHelperParameterCache.GetSpParameterSet(gcstrConnectionString, cvstrSpName, true);
//lines deleted for readability...
//check if the optional fields have a value associated with them. if not, assign dbnull.value.
cvstrStoredParams[4].Value=(cvintRangeFrom != Convert.ToSingle(null) ? cvintRangeFrom : (object)DBNull.Value);
cvstrStoredParams[5].Value=(cvintRangeTo != Convert.ToSingle(null) ? cvintRangeTo : (object)DBNull.Value);
//lines deleted for readability...
SqlHelper.ExecuteNonQuery(gcstrConnectionString, CommandType.StoredProcedure, cvstrSpName, cvstrStoredParams);
return(cvintOptionID = Convert.ToInt32(cvstrStoredParams[0].Value));
}

I use Convert.ToSingle when working with nulls (or possible nulls) because I get an error when I use float.parse for this.

The thing is, after this method AddOption has been executed, I test the value if the business object's rangefrom (that is where I entered 0) and display it on my form. I still shows a 0, but on my database table it is null!

objQuestion.AddOption();
//txtrangefrom.Text=""; on the next line I test the value in the business object...
txtrangefrom.Text=objQuestion.RangeFrom.ToString(); // and this displays 0!!!
//txtrangeto.Text="";
txtrangeto.Text=objQuestion.RangeTo.ToString();

So to me it seems the problem seems to be either the DAAB or on the SQL side, but hopefully somebody can prove me wrong! I was thinking that it could also be float.parse/Convert.ToSingle methods and have done various tests, but I am none the wiser...
Any help or ideas will be greatly appreciated...I had this same problem with a VB project.

Just change the value of the floats to something that is not within the valid range (-1 or something) instead of null. It's not pretty or elegant, but it's better than fiddling with nulls ;)

SQLServer (I think) does implicitly convert 0 to null in some occasions, but I don't know the full details.

HTH|||You're right, it's not pretty, but I'll give it a go.
Thanks.

Does SQL Server Exist

Hi All,

I am trying to write an application to install a product that my company has developed. As part of the install I want to perform some validation ie is IIS running is SQL 2000 running etc before installation. The application is in VB .net can anyone tell me if it is possible to check if SQL Server 2000 exists and is running?

Thanks in advance for your help.

Cheers,

SamBefore using SQL DMO or something to check the service state of SQL Server, why not issuing a simple command like "Select 1" to check whether the server is up or not. Of you want to check for the presence of a database you might issue the command:
Select 1 from master..sysdatabases Where name = 'YourDBNametoCheckfor'

HTH, Jens Suessmeyer|||i would first check if network is available, after check if the server (not sql database server) is on-line... and then check if database server is installed... i'm using this for now till i find something better
i open connection to the server for default database and if its not there (exception) then the sql server is either not runing or it's service is stoped...
hope this helps a bit.... its not perfect but it helps for now...
Private Function CheckServer() As Boolean
Try
Dim MyCnn As New SqlClient.SqlConnection(m_CnnString)
Dim MyCmd As New SqlClient.SqlCommand
MyCnn.Open()
MyCnn.Close()
Return True
Catch ex As SqlException
Return False
Catch ex As Exception
Return False
End Try
End Function

and here i check if database with that name exists
Private Function CheckDb() As Boolean
Dim MyCnn As New SqlClient.SqlConnection(m_CnnString)
Dim MyCmd As New SqlClient.SqlCommand
MyCnn.Open()
With MyCmd
.Connection = MyCnn
'this line of code well sql query i found somewhere on this forums
.CommandText = "Select 1 from master..sysdatabases Where name = '" & m_dbName & "'"
.CommandType = CommandType.Text
End With
Try
Select Case (MyCmd.ExecuteScalar).ToString
Case 1
Return True
MyCnn.Close()
Exit Function
Case Else
Return False
MyCnn.Close()
Exit Function
End Select
Catch ex As NullReferenceException
Return False
MyCnn.Close()
Exit Function
End Try
MyCnn.Close()
End Function

Does SQL Server Exist

Hi All,

I am trying to write an application to install a product that my company has developed. As part of the install I want to perform some validation ie is IIS running is SQL 2000 running etc before installation. The application is in VB .net can anyone tell me if it is possible to check if SQL Server 2000 exists and is running?

Thanks in advance for your help.

Cheers,

SamBefore using SQL DMO or something to check the service state of SQL Server, why not issuing a simple command like "Select 1" to check whether the server is up or not. Of you want to check for the presence of a database you might issue the command:
Select 1 from master..sysdatabases Where name = 'YourDBNametoCheckfor'

HTH, Jens Suessmeyer|||i would first check if network is available, after check if the server (not sql database server) is on-line... and then check if database server is installed... i'm using this for now till i find something better
i open connection to the server for default database and if its not there (exception) then the sql server is either not runing or it's service is stoped...
hope this helps a bit.... its not perfect but it helps for now...
Private Function CheckServer() As Boolean
Try
Dim MyCnn As New SqlClient.SqlConnection(m_CnnString)
Dim MyCmd As New SqlClient.SqlCommand
MyCnn.Open()
MyCnn.Close()
Return True
Catch ex As SqlException
Return False
Catch ex As Exception
Return False
End Try
End Function

and here i check if database with that name exists
Private Function CheckDb() As Boolean
Dim MyCnn As New SqlClient.SqlConnection(m_CnnString)
Dim MyCmd As New SqlClient.SqlCommand
MyCnn.Open()
With MyCmd
.Connection = MyCnn
'this line of code well sql query i found somewhere on this forums
.CommandText = "Select 1 from master..sysdatabases Where name = '" & m_dbName & "'"
.CommandType = CommandType.Text
End With
Try
Select Case (MyCmd.ExecuteScalar).ToString
Case 1
Return True
MyCnn.Close()
Exit Function
Case Else
Return False
MyCnn.Close()
Exit Function
End Select
Catch ex As NullReferenceException
Return False
MyCnn.Close()
Exit Function
End Try
MyCnn.Close()
End Function

Does SQL Server 2005 Support the List Statement?

We have a comprehensive windows based application which uses a database othe
r
than SQL Server. We have been considering moving our application to SQL
server but have been stymied by limitations in the ANS SQL implementation as
well has hidden restrictions in Decalarative Referential integrity.
One statement we use a lot in reporting is the ANS List statment (a scalar
aggregate function for strings which can return a set of results in a
appropriate delimited string).
Does anyone know if the List statement is implemented fully in SQL Server
2005.
If not, we would be interested in what techniques others use to get around
this limitation.
Thanks> One statement we use a lot in reporting is the ANS List statment (a scalar
> aggregate function for strings which can return a set of results in a
> appropriate delimited string).
> Does anyone know if the List statement is implemented fully in SQL Server
> 2005.
NO, it is not.

> If not, we would be interested in what techniques others use to get around
> this limitation.
http://www.aspfaq.com/2529|||"Glenn" wrote:

> We have a comprehensive windows based application which uses a database ot
her
> than SQL Server. We have been considering moving our application to SQL
> server but have been stymied by limitations in the ANS SQL implementation
as
> well has hidden restrictions in Decalarative Referential integrity.
> One statement we use a lot in reporting is the ANS List statment (a scalar
> aggregate function for strings which can return a set of results in a
> appropriate delimited string).
> Does anyone know if the List statement is implemented fully in SQL Server
> 2005.
> If not, we would be interested in what techniques others use to get around
> this limitation.
> Thanks
When you say "ANS SQL" do you mean ANSI SQL? If so, I think you are
mistaken. The LIST "aggregate" has never been part of standard SQL. It is a
proprietary feature in DB2 I believe (and possibly others).
There are a number of logical and practical problems with the concept of a
"string concatenation aggregate". The problems are to do with the fact that
concatentation implies order, which implies sorting. Furthermore, determinis
m
requires unique sorting. This means that "LIST" is A) potentially expensive
on performance B) difficult to ensure reliable results in queries C) totally
contrary to the way other SQL queries and aggregates work.
The ANSI response to "ordered" functions is the Windowed functions and these
*are* supported by SQL Server 2005. Theoretically you can kludge your own
string aggregate using standard SQL, provided you can set some reasdonable
upper limit to the number of items to be concatenated. Allternatively there
are non-standard workarounds in TSQL as there apparently are in your current
database.
Rather than try to support such a potential kludge in the database I suggest
you look at doing this client-side. In ADO you have the GetString method to
serve that purpose.
David Portas
SQL Server MVP
--|||Thanks very much for your response. This is a bit disappointing. We had so
hoped they would address this item as it is so commonly used in other SQL
implementations.
I took a look at the faq sample - and though helpful - and it looks like it
might add quite a lot of complexity to the SQL in many of our queries. I
think it is unfortunate that Microsoft continues to add many new features to
its SQL implementation, yet seems to have long ignored the ANS standard SQL.
It makes it difficult for developers and ISV's to move their applications
from other vendors to the M/S platform.
Glenn
"Aaron Bertrand [SQL Server MVP]" wrote:

> NO, it is not.
>
> http://www.aspfaq.com/2529
>
>|||> yet seems to have long ignored the ANS standard SQL.
Why do you think LIST is ANSI standard?
A|||Hi, this is pretty helpful, although it was my understanding that the SELECT
LIST command was ANSI standard although there were various vendor extensions
to the feature added for control of concatenation, separators, and order.
We are a bit spoiled by the iAnywhere implementation which works very
efficiently for our application and allows for ordering of the result (an
obvious Vendor extention). We have also tried doing this on the client side
,
and it was much-much slower.
Thanks for your help, looks like we are going to need to engage a SQL port
specialist.
BTW - We utilize quite a few Scalar Subqueries in our application, do you
feel that using these on SQL Server 2005 will introduce any special
performance or implementation problems.
Glenn
"David Portas" wrote:

> "Glenn" wrote:
>
> When you say "ANS SQL" do you mean ANSI SQL? If so, I think you are
> mistaken. The LIST "aggregate" has never been part of standard SQL. It is
a
> proprietary feature in DB2 I believe (and possibly others).
> There are a number of logical and practical problems with the concept of a
> "string concatenation aggregate". The problems are to do with the fact tha
t
> concatentation implies order, which implies sorting. Furthermore, determin
ism
> requires unique sorting. This means that "LIST" is A) potentially expensiv
e
> on performance B) difficult to ensure reliable results in queries C) total
ly
> contrary to the way other SQL queries and aggregates work.
> The ANSI response to "ordered" functions is the Windowed functions and the
se
> *are* supported by SQL Server 2005. Theoretically you can kludge your own
> string aggregate using standard SQL, provided you can set some reasdonable
> upper limit to the number of items to be concatenated. Allternatively ther
e
> are non-standard workarounds in TSQL as there apparently are in your curre
nt
> database.
> Rather than try to support such a potential kludge in the database I sugge
st
> you look at doing this client-side. In ADO you have the GetString method t
o
> serve that purpose.
> --
> David Portas
> SQL Server MVP
> --
>|||In our database documentation it was descibed as ANS 92/99 with optional
vendor extensions.
--
Glenn
"Aaron Bertrand [SQL Server MVP]" wrote:

> Why do you think LIST is ANSI standard?
> A
>
>|||LIST isn't ANSI Standard and never has been - I just checked the
standards docs. The reason is probably related to some of the logical
problems I mentioned. It just doesn't make sense as an "aggregate"
function.
I think SQL Server is actually reasonably good on standard SQL
compliance, and it goes further with 2005 - the SQL1999 OLAP functions
for example -although it certainly could do better.
David Portas
SQL Server MVP
--|||I do not wish to offend anyone, but this is - after all - the 21st century:
consider using XML (e.g. in SQL 2005) to replace the less useful LIST
function, if you really need to move sets of data about on the server.
ML|||Can you give me link to the ANSI SQL specification documents?
Thanks
--
Glenn
"David Portas" wrote:

> LIST isn't ANSI Standard and never has been - I just checked the
> standards docs. The reason is probably related to some of the logical
> problems I mentioned. It just doesn't make sense as an "aggregate"
> function.
> I think SQL Server is actually reasonably good on standard SQL
> compliance, and it goes further with 2005 - the SQL1999 OLAP functions
> for example -although it certainly could do better.
> --
> David Portas
> SQL Server MVP
> --
>

Does SQL Server (either 2005 or 2008) have some things similar to Oracle Real Application

Dear all,
Does Microsoft SQL Server (either 2005 or 2008) have some things similar to
Oracle Real Application Clusters ?
As my company's database system work load is getting heavier and heavier,
many colleagues ask me whether we can join a couple of machines as a one
logical machines for a SQL Server database.
However, I know Microsoft Clustering can only provide an Active/Passive mode
and only Oracle Real Application Cluster might fulfill what they want.
So, can you tell me will SQL Server 2005 or 2008 also has this Real
Application Clusters feature ?I believe you mean "load balancing" and SQL Server does not have a feature
like that.
SQL Server has Active\Passive and Active\Active cluster structures. Which
are not about load balancing exactly.
You may use the cluster structure named Active\Active or a better term "more
than one active node" in a meaning load balancing if you divide your
database into 2 pieces. Locate half of it on one of the nodes in the cluster
and locate the other one on the other node. Or you may want to perform OLTP
processes on the first node and replicate the database on the first node to
the second node and perform OLAP, reporting processes on the second node.
I'm not sure about SQL Server 2008.
--
Ekrem Önsoy
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:47008666$1@.127.0.0.1...
> Dear all,
> Does Microsoft SQL Server (either 2005 or 2008) have some things similar
> to
> Oracle Real Application Clusters ?
> As my company's database system work load is getting heavier and heavier,
> many colleagues ask me whether we can join a couple of machines as a one
> logical machines for a SQL Server database.
> However, I know Microsoft Clustering can only provide an Active/Passive
> mode
> and only Oracle Real Application Cluster might fulfill what they want.
> So, can you tell me will SQL Server 2005 or 2008 also has this Real
> Application Clusters feature ?
>
>|||Thanks
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:B0D0F3D9-C4BC-44C5-A025-3437562E86B3@.microsoft.com...
> I believe you mean "load balancing" and SQL Server does not have a feature
> like that.
> SQL Server has Active\Passive and Active\Active cluster structures. Which
> are not about load balancing exactly.
> You may use the cluster structure named Active\Active or a better term
"more
> than one active node" in a meaning load balancing if you divide your
> database into 2 pieces. Locate half of it on one of the nodes in the
cluster
> and locate the other one on the other node. Or you may want to perform
OLTP
> processes on the first node and replicate the database on the first node
to
> the second node and perform OLAP, reporting processes on the second node.
> I'm not sure about SQL Server 2008.
> --
> Ekrem Önsoy
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:47008666$1@.127.0.0.1...
> > Dear all,
> >
> > Does Microsoft SQL Server (either 2005 or 2008) have some things similar
> > to
> > Oracle Real Application Clusters ?
> >
> > As my company's database system work load is getting heavier and
heavier,
> > many colleagues ask me whether we can join a couple of machines as a one
> > logical machines for a SQL Server database.
> >
> > However, I know Microsoft Clustering can only provide an Active/Passive
> > mode
> > and only Oracle Real Application Cluster might fulfill what they want.
> >
> > So, can you tell me will SQL Server 2005 or 2008 also has this Real
> > Application Clusters feature ?
> >
> >
> >
>|||> I'm not sure about SQL Server 2008.
SQL2008 doesn't have any native support that is similar to Oracle RAC or DB2
DPF.
Linchi
"Ekrem Ã?nsoy" wrote:
> I believe you mean "load balancing" and SQL Server does not have a feature
> like that.
> SQL Server has Active\Passive and Active\Active cluster structures. Which
> are not about load balancing exactly.
> You may use the cluster structure named Active\Active or a better term "more
> than one active node" in a meaning load balancing if you divide your
> database into 2 pieces. Locate half of it on one of the nodes in the cluster
> and locate the other one on the other node. Or you may want to perform OLTP
> processes on the first node and replicate the database on the first node to
> the second node and perform OLAP, reporting processes on the second node.
> I'm not sure about SQL Server 2008.
> --
> Ekrem nsoy
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:47008666$1@.127.0.0.1...
> > Dear all,
> >
> > Does Microsoft SQL Server (either 2005 or 2008) have some things similar
> > to
> > Oracle Real Application Clusters ?
> >
> > As my company's database system work load is getting heavier and heavier,
> > many colleagues ask me whether we can join a couple of machines as a one
> > logical machines for a SQL Server database.
> >
> > However, I know Microsoft Clustering can only provide an Active/Passive
> > mode
> > and only Oracle Real Application Cluster might fulfill what they want.
> >
> > So, can you tell me will SQL Server 2005 or 2008 also has this Real
> > Application Clusters feature ?
> >
> >
> >
>|||Thanks for the info mate.
--
Ekrem Ã?nsoy
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:1BA00B04-8543-4ED8-ADAE-741773F05BD6@.microsoft.com...
>> I'm not sure about SQL Server 2008.
> SQL2008 doesn't have any native support that is similar to Oracle RAC or
> DB2
> DPF.
> Linchi
> "Ekrem Ã?nsoy" wrote:
>> I believe you mean "load balancing" and SQL Server does not have a
>> feature
>> like that.
>> SQL Server has Active\Passive and Active\Active cluster structures. Which
>> are not about load balancing exactly.
>> You may use the cluster structure named Active\Active or a better term
>> "more
>> than one active node" in a meaning load balancing if you divide your
>> database into 2 pieces. Locate half of it on one of the nodes in the
>> cluster
>> and locate the other one on the other node. Or you may want to perform
>> OLTP
>> processes on the first node and replicate the database on the first node
>> to
>> the second node and perform OLAP, reporting processes on the second node.
>> I'm not sure about SQL Server 2008.
>> --
>> Ekrem nsoy
>>
>> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> news:47008666$1@.127.0.0.1...
>> > Dear all,
>> >
>> > Does Microsoft SQL Server (either 2005 or 2008) have some things
>> > similar
>> > to
>> > Oracle Real Application Clusters ?
>> >
>> > As my company's database system work load is getting heavier and
>> > heavier,
>> > many colleagues ask me whether we can join a couple of machines as a
>> > one
>> > logical machines for a SQL Server database.
>> >
>> > However, I know Microsoft Clustering can only provide an Active/Passive
>> > mode
>> > and only Oracle Real Application Cluster might fulfill what they want.
>> >
>> > So, can you tell me will SQL Server 2005 or 2008 also has this Real
>> > Application Clusters feature ?
>> >
>> >
>> >

Does reporting services need SQL Server for the RS application tables?

Would it be possible to buy a license for SQL server, not install SQL
server and then have both the data and application tables in an Oracle
database?
A customer of ours does not want to support SQL Server at all. I can
accept that they need a SQL license to use RS, but is there a way to
get around the SQL requirment for the app tables? Will moving the
tables from SQL to Oracle (and the configuring RS to use Oracle)
result in application errors?
I was hoping someone knew the answers before I started testing the
scenarios above.No. SQL Server is needed by Reporting Services. The data can be anywhere but
RS needs SQL Server to operate (the database can be on a separate server but
it has to be somewhere).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"coldfact" <bryan@.coldfact.com> wrote in message
news:249185cd.0410261208.1283bdf1@.posting.google.com...
> Would it be possible to buy a license for SQL server, not install SQL
> server and then have both the data and application tables in an Oracle
> database?
> A customer of ours does not want to support SQL Server at all. I can
> accept that they need a SQL license to use RS, but is there a way to
> get around the SQL requirment for the app tables? Will moving the
> tables from SQL to Oracle (and the configuring RS to use Oracle)
> result in application errors?
> I was hoping someone knew the answers before I started testing the
> scenarios above.

does not install SQL Query Analyzer

Hi,

I am developing and application in pocket pc windows mobile 2003. I have added a reference to System.Data.SqlServerCe.dll but when i deploy the application query analyzer doesnt seem to install. Any help please?

cheers,

michael

Hi,

Sorry... for info I am using CS VS2005 and SQL Mobile.

Thank you.

michael

|||

Query Analyzer 3.0 should deploy automatically if you are building and deploying a DEBUG build in VS2005 given your reference to System.Data.SqlServerCe.dll version 2.0. You can also just grab the dev tools CAB and install it to your device/emulator to save time. it is located (depending on your device's WinCE kernel) at:

<drive:>\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4\sqlce30.dev.ENU.ppc.wce4.armv4.CAB

or

C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\<device CPU architecture>\

Darren

Does MSDE fit my need?

I am creating an application that need store data locally (the new data
are downloaded from my webserver daily). Here is what I want:
1. Secure - Only my application can read the database. I don't want the
user be able to look at the data using other tools, or be able to
export the data for other purpose.
2. Handle large amount of data and be very fast.
3. How MSDE is distributed?
Thanks
John
hi,
Q. John Chen wrote:
> I am creating an application that need store data locally (the new
> data are downloaded from my webserver daily). Here is what I want:
> 1. Secure - Only my application can read the database. I don't want
> the user be able to look at the data using other tools, or be able to
> export the data for other purpose.
>
SQL Server/MSDE is secure as long as you provide an accurate login logic...
SQL Server uses a so called "2 phase" authentication policy:
first an SQL Server Login or a Windows login must be created of granted
access to the SQL Server instance... at the server level a login can be made
member of none, 1 or all of the fixed server roles, which include "sysadmin"
role and so on...
the second authentication phase is at database level, where each login will
be granted database access mapping to a database user... here access
permissions are set, as granting user/role SELECT/DELETE/EXECUTE (and so on)
privileges at an object level (or column level for tables and views)..
the mapping is performed in the JOIN database..sysusers.sid =
master..syslogins.sid , so the only link is the provided Login's sid, it's
Security IDentification number
so, the second phase regards a database security implementation... in order
to access a specified database the simple login existance does not provide
database access, but a (database) user must be mapped to the corresponding
login.. and is about verifying that at each object level (including
database, tables, views, columns, procedures and so on) the Login/User
association is permitted access to... please go on reading at
http://msdn.microsoft.com/library/de...urity_05bt.asp ,
http://msdn.microsoft.com/library/de...ar_da_0n77.asp
and following chapters..
but, back to the first phase, you can choose between 2 authentication modes:
WinNT (trusted) connections or SQL Server authenticated connections... the
latter always requires full user's credential such as "User
Id=sa;Password=pwd", the password can be NULL so it must not be specified,
but I strongly advise you always to ensure strong passwords are present...
WindowsNT authentication, on the contrary, does not requires user's
credential becouse it's directly provided by Windows via the logins'ID
(sid), which authenticate user's login at the windows login step... SQL
Server only needs to verify that the corresponding login and/or group is
granted to log on the instance...
Microsoft recommends to use the Windows NT (trusted) model as it grants more
and reliable security patterns
you can start reading about authentication modes at
other articles worth reading can be found at
http://www.sql-server-performaXnce.c...l_security.asp
http://www.microsoft.com/technet/pro.../sp3sec03.mspx
http://www.microsoft.com/technet/pro.../sp3sec00.mspx

> 2. Handle large amount of data and be very fast.
about large amount of data, MSDE is limited to 2gb data file per database..

> 3. How MSDE is distributed?
I do not understand this question... if it's about legal permissions, MSDE
is free to download and use, where you have to register (for free) at
http://www.microsoft.com/sql/msde/ho...stregister.asp for
redistribution rights...
frmo a technical point of view, it isa provided as a package including a
boostrap installer based on Windows Installer technology, to be run from a
command line prompt in order to provide all the required parameters
http://msdn.microsoft.com/library/de...stsql_84xl.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||About security the OP asked. His intention is not allowing user to see his
database design and data. On this regard, login logic only guard very
innocent users. For any reasonably knowledgable network/computer
administrator, who allows MSDE being installed or who does his own MSDE
installation (thanks to MSDE, many non-database administrators know how to
do it now), can install/uninstall, attach/detach your *.mdf , then be able
to see the database, unless some sort of encryption is applied. After all,
you cannot prevent an Administrator to install/uninstall MSDE. Say, your app
installs MSDE with SQL Security only with a long SA password. The user can
easily enable Win Security by going to Registry, or simply uninstall the
MSDE (note, user database *.mdf does not get erased during uninstallation)
and re-install it with Windows security. And he can create whatever login
and give the login whatever role he wants and then attach your database and
open it.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3drhk9F6n6b9nU1@.individual.net...
> hi,
> Q. John Chen wrote:
> SQL Server/MSDE is secure as long as you provide an accurate login
logic...
> SQL Server uses a so called "2 phase" authentication policy:
> first an SQL Server Login or a Windows login must be created of granted
> access to the SQL Server instance... at the server level a login can be
made
> member of none, 1 or all of the fixed server roles, which include
"sysadmin"
> role and so on...
>
> the second authentication phase is at database level, where each login
will
> be granted database access mapping to a database user... here access
> permissions are set, as granting user/role SELECT/DELETE/EXECUTE (and so
on)
> privileges at an object level (or column level for tables and views)..
> the mapping is performed in the JOIN database..sysusers.sid =
> master..syslogins.sid , so the only link is the provided Login's sid, it's
> Security IDentification number
> so, the second phase regards a database security implementation... in
order
> to access a specified database the simple login existance does not provide
> database access, but a (database) user must be mapped to the corresponding
> login.. and is about verifying that at each object level (including
> database, tables, views, columns, procedures and so on) the Login/User
> association is permitted access to... please go on reading at
>
http://msdn.microsoft.com/library/de...urity_05bt.asp ,
>
http://msdn.microsoft.com/library/de...ar_da_0n77.asp
> and following chapters..
>
> but, back to the first phase, you can choose between 2 authentication
modes:
> WinNT (trusted) connections or SQL Server authenticated connections... the
> latter always requires full user's credential such as "User
> Id=sa;Password=pwd", the password can be NULL so it must not be specified,
> but I strongly advise you always to ensure strong passwords are
present...
> WindowsNT authentication, on the contrary, does not requires user's
> credential becouse it's directly provided by Windows via the logins'ID
> (sid), which authenticate user's login at the windows login step... SQL
> Server only needs to verify that the corresponding login and/or group is
> granted to log on the instance...
>
> Microsoft recommends to use the Windows NT (trusted) model as it grants
more
> and reliable security patterns
> you can start reading about authentication modes at
>
> other articles worth reading can be found at
> http://www.sql-server-performaXnce.c...l_security.asp
>
http://www.microsoft.com/technet/pro.../sp3sec03.mspx
>
http://www.microsoft.com/technet/pro.../sp3sec00.mspx
>
> about large amount of data, MSDE is limited to 2gb data file per
database..
>
> I do not understand this question... if it's about legal permissions, MSDE
> is free to download and use, where you have to register (for free) at
> http://www.microsoft.com/sql/msde/ho...stregister.asp for
> redistribution rights...
> frmo a technical point of view, it isa provided as a package including a
> boostrap installer based on Windows Installer technology, to be run from a
> command line prompt in order to provide all the required parameters
>
http://msdn.microsoft.com/library/de...stsql_84xl.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||It seems that I can not use MSDE for my application thanks to you
answer. (unless I can find a way to remove your post :-))
Any recommendation on a local database that provide the security I
wanted. (not a good place to ask for an alternative here though).
Thanks
John
|||hi Norman,
I do not understand if you are just claiming for security...
Norman Yuan wrote:
> About security the OP asked. His intention is not allowing user to
> see his
> database design and data.
and of course you have to manage your WinNT users/groups accordingly to your
security needs and policy.. never give permissions your user is not
interested/accorded with..
and again, of course, we are dealing with SQL Server security and not OS
security, you should already know and manage accordingly to your needs

> On this regard, login logic only guard very
> innocent users. For any reasonably knowledgable network/computer
> administrator, who allows MSDE being installed or who does his own
> MSDE
> installation (thanks to MSDE, many non-database administrators know
> how to
> do it now), can install/uninstall, attach/detach your *.mdf , then be
> able
> to see the database, unless some sort of encryption is applied. After
> all,
> you cannot prevent an Administrator to install/uninstall MSDE.
do not understand this point... you can actually prevent your administrators
from logging in SQL Server... but you can not prevent them to uninstall SQL
Server... that's ok... but, what kind of employee do you have in your
organization? usually, if you can not trust your (fews) administrator, I
really think you have to fire them... the very same applys to SQL Server
(not os) administrator(s)..

>Say,
> your app
> installs MSDE with SQL Security only with a long SA password. The
> user can
> easily enable Win Security by going to Registry,
not the user, the local administrator...

>or simply uninstall the
> MSDE (note, user database *.mdf does not get erased during
> uninstallation)
> and re-install it with Windows security. And he can create whatever
> login
> and give the login whatever role he wants and then attach your
> database and
> open it.
again... I think you should fire your employees :D
as a local admin can do whatever operation he likes to do, you can not
prevent him to stop the server and trash your data.. he can perhaps even
eventually log on SQL Server, if you did not remove the
BUILTIN\Administrator login group (as I usually do) from the MSDE istance,
and of course, as part of the sysamin server role, even access the company
database and increase his salary by 20%...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||The original OP are concerned about protecting his software, including the
database design and data the software used. He does not want the software
user, be it individual or organization, to peek into his software logic by
openning database on MSDE. So my point is the software user has the power to
open a SQL Server database installed on his computer unless some encryption
is implemented on the database. It has nothing to do with how the employee
is behaves and is regulated.
Actually, from the point of view of pretecting software, lot of your unique
business logic are reflected on the database design. And when using MSDE in
your application, we are educated to use as much stroed procedures as
possible, meaning more business logic in the DB. Obviously, there is need to
protect them (I know and you know there are tools for encypting SPs). In
most cases of SQL Server being used in a organization, it is most likely
that app used there are custom-developed, so protecting software wouldn't be
a problem. But when you are developing a stand-alone app for sale, with MSDE
integrided, concerns on user peeking into the DB is understandable.
I developed a windows app package a couple of years ago and used MSDE with
tons of SPs in it. It was aimed to small business in certain business. There
is nothing to prevent them to find a knowledgable guy to get into the
database and uses those Tables/SPs and develop there new UI app, although
they did not do that. Since MSDE is a powerful data engine and very easy to
be integrited into your app, protecting software resulted in by this should
be a concern. How to safyly regulating SQL Server/MSDE in a organization is
not my topic here.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3dsa5rF6tlqnqU1@.individual.net...
> hi Norman,
> I do not understand if you are just claiming for security...
> Norman Yuan wrote:
> and of course you have to manage your WinNT users/groups accordingly to
your
> security needs and policy.. never give permissions your user is not
> interested/accorded with..
> and again, of course, we are dealing with SQL Server security and not OS
> security, you should already know and manage accordingly to your needs
>
> do not understand this point... you can actually prevent your
administrators
> from logging in SQL Server... but you can not prevent them to uninstall
SQL
> Server... that's ok... but, what kind of employee do you have in your
> organization? usually, if you can not trust your (fews) administrator, I
> really think you have to fire them... the very same applys to SQL Server
> (not os) administrator(s)..
>
> not the user, the local administrator...
>
> again... I think you should fire your employees :D
> as a local admin can do whatever operation he likes to do, you can not
> prevent him to stop the server and trash your data.. he can perhaps even
> eventually log on SQL Server, if you did not remove the
> BUILTIN\Administrator login group (as I usually do) from the MSDE istance,
> and of course, as part of the sysamin server role, even access the company
> database and increase his salary by 20%...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Norman,
You read my mind. The software I developed is an application analyzing
commodity trading data. The user is not of a single organization but in
different organization or individuals all over the world. What we are
selling is the data not the software ifself. So protect the data is the
first priority.
Still, I want thank Andrea for giving me all the information about
MSDE.
Again, thanks both.
John
|||Q. John Chen wrote:
> Norman,
> You read my mind. The software I developed is an application analyzing
> commodity trading data. The user is not of a single organization but in
> different organization or individuals all over the world. What we are
> selling is the data not the software ifself. So protect the data is the
> first priority.
> Still, I want thank Andrea for giving me all the information about
> MSDE.
> Again, thanks both.
> John
>
Hi,
My company sells data and ships an MSDE application. What we ended up
doing was coding in application encryption logic. Numbers are not
encrypted but databae column with anything in text (like say
COMPANYNAME) was encrypted.
We can't stop the end-users looking at the database through Access, but
what they do see is a garbled mess !
|||Encrypt the data before storing it in the database, and decrypt it on the
application side when you read it. Of course this will affect overall
performance, but if security is your primary concern, performance is going
to take a hit no matter what.
"Q. John Chen" <qjchen@.email.com> wrote in message
news:1115221772.287953.148830@.o13g2000cwo.googlegr oups.com...
> It seems that I can not use MSDE for my application thanks to you
> answer. (unless I can find a way to remove your post :-))
> Any recommendation on a local database that provide the security I
> wanted. (not a good place to ask for an alternative here though).
> Thanks
> John
>

Does MS Access installation is required for running application that uses Access mdb file

Hi,

I am developing an application that uses Access database (mdb file) to store the user data. The user of this application is not interested in the database file (to view in MS Access Environment). Does the user machine requires MS Access installation to run my application or just some couple of dlls (OleDB driver, Access DB Engine,..) should be enough to run my application?

Thanks,

Rao

No, they don't need Access. They will simply need to have MDAC installed, and chances are it will already be there. If not get it here

http://msdn.microsoft.com/data/ref/mdac/

|||

The Information is helpful.

Thanks

Does Log Shipping Handle Schema Changes from Primary to Secondary

Anyone, we have a Vendor application where we install modules or
software that updates our primary production database. We have a
reporting database that is updated via log shipping. I believe that
the article by Paul Ibison log shipping v. replication answers my question
but wanted
to know if I was missing something. So here goes. When we do an
install of a module or software it modifies our primary database. From
Paul is saying in his article it looks like any schema changes in
the primary database would not be done in the reporting database. Is
this correct?
References:
Log Shipping v. Replication
http://www.sqlservercentral.com/columnists/pibison/logshippingvsreplication.asp
Using Secondary Servers for Query Processing
http://msdn2.microsoft.com/en-us/library/ms189572.aspx
Thanks,
Chad
Hi Chad - absolutely. This is one of the differences cf replication - ALL
schema changes are replicated. In SQL Server 2005 you can replicate ddl
changes which makes it closer but not all changes are replicated to the
subscribers.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Does LoadFromSqlServer2 method work?

Hi. There's little documentation on the Microsoft.SqlServer.Dts.Runtime.Application "LoadFromSqlServer2" method, and even less via any search engine.

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.loadfromsqlserver2.aspx

I cannot seem to ever get the method to work; it returns "InvalidCastException: No such interface supported."

Is this code-speak for "does not work at this time" ?

Sample code (add a reference to c:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll)

Dim app As New Microsoft.SqlServer.Dts.Runtime.Application

Dim pkg As Microsoft.SqlServer.Dts.Runtime.Package

Dim cnDatasource As New System.Data.SqlClient.SqlConnection

cnDatasource.ConnectionString = _

"Data Source=SQLOLEDB;SERVER=" & m_Datasource & ";Initial Catalog=msdb;Integrated Security=SSPI"

cnDatasource.Open()

pkg = app.LoadFromSqlServer2(m_PackageFolderPath & m_PackageName, cnDatasource, Nothing)

I am aware of the "LoadFromSqlServer" and "LoadFromDtsServer" methods; I like the idea of the Win-NT authentication (theoretically) available in the "LoadFromSqlServer2" method.

Did you read the first line of that link you sent?

"This method supports the SQL Server 2005 infrastructure and is not intended to be used directly from your code. "

|||

I guess I didn't. I've not met documentation that I wasn't supposed to use.

Thanks for the fact... it would have really been useful.

Does JOINs and VIEWs lose performance when used with more than one DataBase?

Hi,
My application consist of 2 big parts, which work together but are in some
way seperate.
In case I should store the 2 parts in different databases (but on the same
server), will I lose performance when doing a query that joins tables from
both databases? And what about views?
Any help our hints would be really appreciated.
Thanks a lot in advance,
Pieter
On Fri, 4 Nov 2005 17:59:02 +0100, Pieter wrote:

> Hi,
> My application consist of 2 big parts, which work together but are in some
> way seperate.
> In case I should store the 2 parts in different databases (but on the same
> server), will I lose performance when doing a query that joins tables from
> both databases? And what about views?
> Any help our hints would be really appreciated.
> Thanks a lot in advance,
> Pieter
Hello,
You will have no performance decrease. Try to always include the owner in
the object naming (dbo I hope), to ease the work of SQL Server.
What you physically loose splitting your model, is of course the DRIs, but
you can manage it with triggers.
Rudi Bruchez
MCDBA
|||ok! thanks a lot!
"Rudi Bruchez" <rudi#no-spam#at.babaluga.com> wrote in message
news:1goqk59i7hqzp$.146q0p9y2vigx$.dlg@.40tude.net. ..
> On Fri, 4 Nov 2005 17:59:02 +0100, Pieter wrote:
>
> Hello,
> You will have no performance decrease. Try to always include the owner in
> the object naming (dbo I hope), to ease the work of SQL Server.
> What you physically loose splitting your model, is of course the DRIs, but
> you can manage it with triggers.
> --
> Rudi Bruchez
> MCDBA

Does JOINs and VIEWs lose performance when used with more than one DataBase?

Hi,
My application consist of 2 big parts, which work together but are in some
way seperate.
In case I should store the 2 parts in different databases (but on the same
server), will I lose performance when doing a query that joins tables from
both databases? And what about views?
Any help our hints would be really appreciated.
Thanks a lot in advance,
PieterOn Fri, 4 Nov 2005 17:59:02 +0100, Pieter wrote:

> Hi,
> My application consist of 2 big parts, which work together but are in some
> way seperate.
> In case I should store the 2 parts in different databases (but on the same
> server), will I lose performance when doing a query that joins tables from
> both databases? And what about views?
> Any help our hints would be really appreciated.
> Thanks a lot in advance,
> Pieter
Hello,
You will have no performance decrease. Try to always include the owner in
the object naming (dbo I hope), to ease the work of SQL Server.
What you physically loose splitting your model, is of course the DRIs, but
you can manage it with triggers.
Rudi Bruchez
MCDBA|||ok! thanks a lot!
"Rudi Bruchez" <rudi#no-spam#at.babaluga.com> wrote in message
news:1goqk59i7hqzp$.146q0p9y2vigx$.dlg@.40tude.net...
> On Fri, 4 Nov 2005 17:59:02 +0100, Pieter wrote:
>
> Hello,
> You will have no performance decrease. Try to always include the owner in
> the object naming (dbo I hope), to ease the work of SQL Server.
> What you physically loose splitting your model, is of course the DRIs, but
> you can manage it with triggers.
> --
> Rudi Bruchez
> MCDBA

Does JOINs and VIEWs lose performance when used with more than one DataBase?

Hi,
My application consist of 2 big parts, which work together but are in some
way seperate.
In case I should store the 2 parts in different databases (but on the same
server), will I lose performance when doing a query that joins tables from
both databases? And what about views?
Any help our hints would be really appreciated.
Thanks a lot in advance,
PieterOn Fri, 4 Nov 2005 17:59:02 +0100, Pieter wrote:
> Hi,
> My application consist of 2 big parts, which work together but are in some
> way seperate.
> In case I should store the 2 parts in different databases (but on the same
> server), will I lose performance when doing a query that joins tables from
> both databases? And what about views?
> Any help our hints would be really appreciated.
> Thanks a lot in advance,
> Pieter
Hello,
You will have no performance decrease. Try to always include the owner in
the object naming (dbo I hope), to ease the work of SQL Server.
What you physically loose splitting your model, is of course the DRIs, but
you can manage it with triggers.
--
Rudi Bruchez
MCDBA|||ok! thanks a lot!
"Rudi Bruchez" <rudi#no-spam#at.babaluga.com> wrote in message
news:1goqk59i7hqzp$.146q0p9y2vigx$.dlg@.40tude.net...
> On Fri, 4 Nov 2005 17:59:02 +0100, Pieter wrote:
>> Hi,
>> My application consist of 2 big parts, which work together but are in
>> some
>> way seperate.
>> In case I should store the 2 parts in different databases (but on the
>> same
>> server), will I lose performance when doing a query that joins tables
>> from
>> both databases? And what about views?
>> Any help our hints would be really appreciated.
>> Thanks a lot in advance,
>> Pieter
> Hello,
> You will have no performance decrease. Try to always include the owner in
> the object naming (dbo I hope), to ease the work of SQL Server.
> What you physically loose splitting your model, is of course the DRIs, but
> you can manage it with triggers.
> --
> Rudi Bruchez
> MCDBA

Does anyone know of a web based SQL Query tool?

Hi

I want to be able t give my users access to our SQL server database via a eb application published o our web server. I have found one freeware tool but it only supports SQL Server 2000 and the developer doesn't returns any emails.

Has anyone come across a web ui SQL query tool either freeware or one that can be purhcase

thanks for your help

Marcus

Do you just want to have a tool sending out a query from a textbox and getting the results back in a grid or something ? Or do you want tome graphical designer for your users ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

search for

SQL Server Web Data Administrator

on microsoft website

|||

Here is the link to SQL Server Web Data Administrator

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

Sethu Srinivasan, Software Design Engineer, SQL Server Manageability
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

|||ASP Enterprise Manager http://sourceforge.net/projects/asp-ent-man/

Does anyone know if guest account must be enabled?

Hi a user is not able to run a windows application that uses SQL
authentication and was just wondering if the guest account have to be enabled
on the SQL Server for SQL authentication to work?
Thanks.
Paul G
Software engineer.
There is a thread from Kimberly:
http://groups.google.de/group/micros...b922f9b1e2a009
HTH, Jens Suessmeyer.
"Paul" wrote:

> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enabled
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.
|||No need for any type of guest account.
Only time I heard about that is if you are in separate domains and you don't have trusts and you are
using the Named Pipes netlib, which depends on the IPC$ share). I don't know if this is still the
case, but in any case moving to the IP netlib should remove that need.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:690F2DCE-4020-48A3-ACE7-36006029871C@.microsoft.com...
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enabled
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.
|||ok thanks for the information. Sounds like it does not effect SQL login
Paul G
Software engineer.
"Jens Sü?meyer" wrote:
[vbcol=seagreen]
> There is a thread from Kimberly:
> http://groups.google.de/group/micros...b922f9b1e2a009
> HTH, Jens Suessmeyer.
> "Paul" wrote:
|||To me it wasn't clear whether you refer to the guest user inside a database, if so see Jens' reply.
Or if you refer to a Gust Windows account, if so, see my reply.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:C9EE6BC1-2F9B-4E9B-A585-DABB6A6F22B6@.microsoft.com...[vbcol=seagreen]
> ok thanks for the information. Sounds like it does not effect SQL login
> --
> Paul G
> Software engineer.
>
> "Jens Sü?meyer" wrote:

Does anyone know if guest account must be enabled?

Hi a user is not able to run a windows application that uses SQL
authentication and was just wondering if the guest account have to be enable
d
on the SQL Server for SQL authentication to work?
Thanks.
--
Paul G
Software engineer.There is a thread from Kimberly:
http://groups.google.de/group/micro...8b922f9b1e2a009
HTH, Jens Suessmeyer.
"Paul" wrote:

> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enab
led
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.|||No need for any type of guest account.
Only time I heard about that is if you are in separate domains and you don't
have trusts and you are
using the Named Pipes netlib, which depends on the IPC$ share). I don't know
if this is still the
case, but in any case moving to the IP netlib should remove that need.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:690F2DCE-4020-48A3-ACE7-36006029871C@.microsoft.com...
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enab
led
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.|||ok thanks for the information. Sounds like it does not effect SQL login
--
Paul G
Software engineer.
"Jens Sü?meyer" wrote:
[vbcol=seagreen]
> There is a thread from Kimberly:
> http://groups.google.de/group/micro...8b922f9b1e2a009
> HTH, Jens Suessmeyer.
> "Paul" wrote:
>|||To me it wasn't clear whether you refer to the guest user inside a database,
if so see Jens' reply.
Or if you refer to a Gust Windows account, if so, see my reply.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:C9EE6BC1-2F9B-4E9B-A585-DABB6A6F22B6@.microsoft.com...[vbcol=seagreen]
> ok thanks for the information. Sounds like it does not effect SQL login
> --
> Paul G
> Software engineer.
>
> "Jens Sü?meyer" wrote:
>

Does anyone know if guest account must be enabled?

Hi a user is not able to run a windows application that uses SQL
authentication and was just wondering if the guest account have to be enabled
on the SQL Server for SQL authentication to work?
Thanks.
--
Paul G
Software engineer.There is a thread from Kimberly:
http://groups.google.de/group/microsoft.public.sqlserver.security/browse_thread/thread/ea9205103023d109/78b922f9b1e2a009?q=guest+account+sql+server+microsoft&rnum=3&hl=de#78b922f9b1e2a009
HTH, Jens Suessmeyer.
"Paul" wrote:
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enabled
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.|||No need for any type of guest account.
Only time I heard about that is if you are in separate domains and you don't have trusts and you are
using the Named Pipes netlib, which depends on the IPC$ share). I don't know if this is still the
case, but in any case moving to the IP netlib should remove that need.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:690F2DCE-4020-48A3-ACE7-36006029871C@.microsoft.com...
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enabled
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.|||ok thanks for the information. Sounds like it does not effect SQL login
--
Paul G
Software engineer.
"Jens Sü�meyer" wrote:
> There is a thread from Kimberly:
> http://groups.google.de/group/microsoft.public.sqlserver.security/browse_thread/thread/ea9205103023d109/78b922f9b1e2a009?q=guest+account+sql+server+microsoft&rnum=3&hl=de#78b922f9b1e2a009
> HTH, Jens Suessmeyer.
> "Paul" wrote:
> > Hi a user is not able to run a windows application that uses SQL
> > authentication and was just wondering if the guest account have to be enabled
> > on the SQL Server for SQL authentication to work?
> > Thanks.
> > --
> > Paul G
> > Software engineer.|||To me it wasn't clear whether you refer to the guest user inside a database, if so see Jens' reply.
Or if you refer to a Gust Windows account, if so, see my reply.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:C9EE6BC1-2F9B-4E9B-A585-DABB6A6F22B6@.microsoft.com...
> ok thanks for the information. Sounds like it does not effect SQL login
> --
> Paul G
> Software engineer.
>
> "Jens Sü�meyer" wrote:
>> There is a thread from Kimberly:
>> http://groups.google.de/group/microsoft.public.sqlserver.security/browse_thread/thread/ea9205103023d109/78b922f9b1e2a009?q=guest+account+sql+server+microsoft&rnum=3&hl=de#78b922f9b1e2a009
>> HTH, Jens Suessmeyer.
>> "Paul" wrote:
>> > Hi a user is not able to run a windows application that uses SQL
>> > authentication and was just wondering if the guest account have to be enabled
>> > on the SQL Server for SQL authentication to work?
>> > Thanks.
>> > --
>> > Paul G
>> > Software engineer.

Does adding indexes affect how an Access/Jet application functions?

We have an Access application using Jet. I added some new indexes yesterday and now they are being blamed for poor Access application performance. I then dropped the new indexes. The poor performance continued until the Access application was re-linked to the SS2000 database. Then things returned to normal.

Question, does Access/Jet persist SqlServer schema info in its MDB (or elsewhere?) I am told that the MDB is copied from a share to the local PC where it grows during its use. Some people are saying the MDB persists schema info about the SS2000 schema which influences how Jet accesses the SS2000 database. Is that true? Is there a link where I can read about this? I am a dba and am not an Access developer . . .

Thanks!

Michael

For linked tables in a JET database, I believe the schema is cached locally but it's not clear to me how that could result in a performance issue. You might want to post this to a Jet/Access newsgroup.

Regards,

Uwa.

|||

Thanks for your response. Can you suggest an appropriate newsgroup?

Michael

|||access.tablesdbdesign
All Office forums & newsgroups

Does "text type" belong to SQL2 standard ?

Hi,

I am developping an application that should work with different RDBMS.

I need to store a field of 500 characters.

Hence, I thought of using the type "text" that works with MySQL, but I am wondering if it is part of SQL standard or if it is supported by the main RBDMS (Orcale, DB2, SQL Server ...).

Thanks in advance,

SylvainThe "Text" datatype is not part of the ANSI SQL99 standard. Most vendors also have their own variants of datatypes. The nearest agreements in datatypes for your purposes I guess would be to use a VARCHAR. However there is still variation, in Oracle this would be a VARCHAR2.

Hope this help you on your way.|||Hi,

Originally posted by gannet
The "Text" datatype is not part of the ANSI SQL99 standard. Most vendors also have their own variants of datatypes. The nearest agreements in datatypes for your purposes I guess would be to use a VARCHAR. However there is still variation, in Oracle this would be a VARCHAR2.


But with MySQL for example VARCHAR is limited to 255. We can't do VARCHAR(500).

So you see any solution ?

Regards
Sylvain|||Unfortunately there will be no vendor independent way araound this, you will need to generate some vendor specific translations. Not what you wanted to hear I know.