database compatibility level

A couple of weeks ago we had upgraded our SQL Server 6.5
to ver. 7.0. We've just observed that for all of our
databases, the database compatibility level remains at 65.
My concern here is... can we change this compatibility
level to 70 on the fly? Would this incur an outage of any
sort? Are there any precautions that I should be aware of
before set the database compatibility level to 70?
Thanks in advance for your help and suggestions.You can certainly change on the fly, but there will be some semantic =changes to the SQL that may catch out your application. BOL has a =summary of the differences, but it is things like:
SELECT 'a' + '' + 'b' -- Nothe there is no space between the middle pair =of single quotes -
At 65 will give 'a b' - ie the zerolength string is interpreted as a =single space.
At 7 will give 'ab' - which I would say is right.
Others such as =3D NULL behaving non-standard at 65 but fixed at 7 can =catch you if the app uses it.
BOL has a description of all the differences.
Mike John
"Rob" <rhchin@.hotmail.com> wrote in message =news:01fc01c3425c$c76bc8a0$a301280a@.phx.gbl...
> A couple of weeks ago we had upgraded our SQL Server 6.5 > to ver. 7.0. We've just observed that for all of our > databases, the database compatibility level remains at 65.
> > My concern here is... can we change this compatibility > level to 70 on the fly? Would this incur an outage of any > sort? Are there any precautions that I should be aware of > before set the database compatibility level to 70?
> > Thanks in advance for your help and suggestions.

database attaching

we have a pllication that uses MSDE databases, we send out updates we detach
copy new file in and reattach.
Problem: I have a couple of machine the MSDE server want allow the mdb files
to attach. WE remove the current log files after the detatch. Almost like the
machine does't know the SQL server exists anymore.
Hi,
Are you facing the issue to attach the database only with MDF? If yes then
try to attach the database using below command:-
EXEC sp_attach_single_file_db @.dbname = 'DBNAME', @.physname =
'd:\MSSQL\Data\DBNAME.mdf'
Thanks
Hari
SQL Server MVP
"msatullo" <msatullo@.discussions.microsoft.com> wrote in message
news:FA3791F6-F23A-44FE-B6BD-95753C70628C@.microsoft.com...
> we have a pllication that uses MSDE databases, we send out updates we
> detach
> copy new file in and reattach.
> Problem: I have a couple of machine the MSDE server want allow the mdb
> files
> to attach. WE remove the current log files after the detatch. Almost like
> the
> machine does't know the SQL server exists anymore.
|||The databases are attached when the program starts
I get the following errors when the program tries to attach
-2147024769 automation error- the specified proceedure not found
"Hari Prasad" wrote:

> Hi,
> Are you facing the issue to attach the database only with MDF? If yes then
> try to attach the database using below command:-
> EXEC sp_attach_single_file_db @.dbname = 'DBNAME', @.physname =
> 'd:\MSSQL\Data\DBNAME.mdf'
> Thanks
> Hari
> SQL Server MVP
> "msatullo" <msatullo@.discussions.microsoft.com> wrote in message
> news:FA3791F6-F23A-44FE-B6BD-95753C70628C@.microsoft.com...
>
>

database

We are a couple of student on the area of system development. We are
trying to make a database system that will treat the manipulation and
updating of sounds. The input/output of it, has to be sounds in
graphic, acoustic, form etc. Are there any database systems that
support these kinds of data?
Hi
SQL Server 2005 does have BLOB datatypes
http://msdn2.microsoft.com/en-US/library/ms131277.aspx
http://msdn2.microsoft.com/en-us/library/ms130896.aspx and a XML datatype
http://msdn2.microsoft.com/en-us/library/ms131375.aspx that could be used for
holding this type of data; although you may wish to store these files on the
O/S see
http://databases.aspfaq.com/database...ilesystem.html
John
"Farhad" wrote:

> We are a couple of student on the area of system development. We are
> trying to make a database system that will treat the manipulation and
> updating of sounds. The input/output of it, has to be sounds in
> graphic, acoustic, form etc. Are there any database systems that
> support these kinds of data?
>

database

We are a couple of student on the area of system development. We are
trying to make a database system that will treat the manipulation and
updating of sounds. The input/output of it, has to be sounds in
graphic, acoustic, form etc. Are there any database systems that
support these kinds of data?Hi
SQL Server 2005 does have BLOB datatypes
http://msdn2.microsoft.com/en-US/library/ms131277.aspx
http://msdn2.microsoft.com/en-us/library/ms130896.aspx and a XML datatype
http://msdn2.microsoft.com/en-us/library/ms131375.aspx that could be used for
holding this type of data; although you may wish to store these files on the
O/S see
http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
John
"Farhad" wrote:
> We are a couple of student on the area of system development. We are
> trying to make a database system that will treat the manipulation and
> updating of sounds. The input/output of it, has to be sounds in
> graphic, acoustic, form etc. Are there any database systems that
> support these kinds of data?
>

database

We are a couple of student on the area of system development. We are
trying to make a database system that will treat the manipulation and
updating of sounds. The input/output of it, has to be sounds in
graphic, acoustic, form etc. Are there any database systems that
support these kinds of data?Hi
SQL Server 2005 does have BLOB datatypes
http://msdn2.microsoft.com/en-US/library/ms131277.aspx
http://msdn2.microsoft.com/en-us/library/ms130896.aspx and a XML datatype
http://msdn2.microsoft.com/en-us/library/ms131375.aspx that could be used fo
r
holding this type of data; although you may wish to store these files on the
O/S see
http://databases.aspfaq.com/databas...filesystem.html
John
"Farhad" wrote:

> We are a couple of student on the area of system development. We are
> trying to make a database system that will treat the manipulation and
> updating of sounds. The input/output of it, has to be sounds in
> graphic, acoustic, form etc. Are there any database systems that
> support these kinds of data?
>

Data Types

Hello, I am following this article about building an ASP.Net application which uses SQL Express 2005. The document calls for building a couple of tables. One column is identified with data type of "Byte" which are is available for selection within the Visual Studio 2005 interface. The following values show in the drop down of data type in VS2005:

Bigint

Binary(5)

Bit

Char(10)

DateTime

Decimal (18,0)

Float

Image

Int

Money

NChar(10)

NText

Numeric(18,0)

Nvarchar(50)

Nvarchar(max)

Real

SmallDateTime

SmallInt

SmallMoney

Sql_Variant

Text

Timestamp

TinyInt

UniqueIdentifier

Varbinary(50)

VarBinary(max)

varchar(10)

Varchar(max)

XML

I choose Char with a size of 1. Would this be correct, or am I missing something?

Thanks in advance for your assistance!!

SqlByte maps to tinyint.