Saving SQL 2000 Databases in SQL 7 format

Hi
I understand 2000 databases are not backward compatible
but is there any way to save 2000 databases in 7 format?
Is there an option?
Thanks
Tony
Hi,
You can set the user databases to SQL 7.0 compatible in SQL2000. You can do
that using Enterprise manager as well as Query Analyzer.
Enterprise manager:
1.Expand databases -- Right click and select properties
2. Choose option tab -- In the compatibility combo box select "Database
compatibilty level 70"
3. Click ok
Query ANalyzer:
1. Execute the below script.
EXEC sp_dbcmptlevel 'pubs', 70
Thanks
Hari
MCDBA
"Tony" <anonymous@.discussions.microsoft.com> wrote in message
news:298601c4709c$5dc1af40$a401280a@.phx.gbl...
> Hi
> I understand 2000 databases are not backward compatible
> but is there any way to save 2000 databases in 7 format?
> Is there an option?
> Thanks
> Tony
|||What exactly do you mean by "Save"? Do you want to know how to get it into
a 7.0 db or did Hari address your issue?
Andrew J. Kelly SQL MVP
"Tony" <anonymous@.discussions.microsoft.com> wrote in message
news:298601c4709c$5dc1af40$a401280a@.phx.gbl...
> Hi
> I understand 2000 databases are not backward compatible
> but is there any way to save 2000 databases in 7 format?
> Is there an option?
> Thanks
> Tony
|||Tony,
To add to Andrew's post, if you want to export data from 2000 to 7, then
you can use DTS.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Andrew J. Kelly wrote:
> What exactly do you mean by "Save"? Do you want to know how to get it into
> a 7.0 db or did Hari address your issue?
>
sql

Saving SQL 2000 Databases in SQL 7 format

Hi
I understand 2000 databases are not backward compatible
but is there any way to save 2000 databases in 7 format?
Is there an option?
Thanks
TonyHi,
You can set the user databases to SQL 7.0 compatible in SQL2000. You can do
that using Enterprise manager as well as Query Analyzer.
Enterprise manager:
1.Expand databases -- Right click and select properties
2. Choose option tab -- In the compatibility combo box select "Database
compatibilty level 70"
3. Click ok
Query ANalyzer:
1. Execute the below script.
EXEC sp_dbcmptlevel 'pubs', 70
Thanks
Hari
MCDBA
"Tony" <anonymous@.discussions.microsoft.com> wrote in message
news:298601c4709c$5dc1af40$a401280a@.phx.gbl...
> Hi
> I understand 2000 databases are not backward compatible
> but is there any way to save 2000 databases in 7 format?
> Is there an option?
> Thanks
> Tony|||What exactly do you mean by "Save"? Do you want to know how to get it into
a 7.0 db or did Hari address your issue?
Andrew J. Kelly SQL MVP
"Tony" <anonymous@.discussions.microsoft.com> wrote in message
news:298601c4709c$5dc1af40$a401280a@.phx.gbl...
> Hi
> I understand 2000 databases are not backward compatible
> but is there any way to save 2000 databases in 7 format?
> Is there an option?
> Thanks
> Tony|||Tony,
To add to Andrew's post, if you want to export data from 2000 to 7, then
you can use DTS.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Andrew J. Kelly wrote:
> What exactly do you mean by "Save"? Do you want to know how to get it int
o
> a 7.0 db or did Hari address your issue?
>

Saving data to another table

Hi

I'm making a very primitive shopping cart. I've created a table containing a list of products and using an SQLdataSource with a GridView I've got the products displayed – simple.

What I now need is to add a button with an Insert command, but the SQL needs to add a row of data to a different table – tblShoppingBasket. I've tried adding in the insert command and changing the SQL but it doesn't add a new record, although is also doesn't through and error.

The second part of the problem is need to pass the productID from the row they selected (pressed the button that triggered the insert command) and add this to the shoppingBasket table via the insert SQL.

I'd really be grateful for any help (code below).

Thanks
Richard

<asp:SqlDataSourceID="SqlDataSource_GenralProducts"runat="server"ConnectionString="<%$ ConnectionStrings:AquilaConnectionString %>"

SelectCommand="SELECT * FROM [tblProducts] WHERE ([productAgeGroup] = @.productAgeGroup)"

InsertCommand="INSERT INTO [tblShoppingBasket] ([userID], [productID]) VALUES (@.userID, @.productID)">

<SelectParameters>

<asp:ParameterDefaultValue="3"Name="productAgeGroup"Type="Int32"/>

</SelectParameters>

<InsertParameters>

<asp:ParameterName="userID"Type="Object"DefaultValue="123"/>

<asp:ParameterName="productID"Type="Int32"/>

</InsertParameters>

</asp:SqlDataSource>

<asp:GridViewID="GridView3"runat="server"AutoGenerateColumns="False"DataKeyNames="productsID"

DataSourceID="SqlDataSource_GenralProducts">

<Columns>

<asp:ImageFieldDataImageUrlField="productThumbNail"DataImageUrlFormatString="../images/shop/thumbNails/{0}">

</asp:ImageField>

<asp:BoundFieldDataField="productLabel"HeaderText="Product:"SortExpression="productLabel"/>

<asp:BoundFieldDataField="productDescription"HeaderText="Description:"SortExpression="productDescription"/>

<asp:BoundFieldDataField="productCost"HeaderText="Cost:"SortExpression="productCost"/>

<asp:ButtonFieldButtonType="Button"CommandName="insert"Text="Add to Shopping Basket"/>

</Columns>

</asp:GridView>

Hi,

You can use RowDataBound event to handle the problem. Here's a sample for you.

In your aspx:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowDataBound="InsertEvent"> <Columns> <asp:BoundField DataField="CategoryName" /> <asp:TemplateField> <ItemTemplate><asp:Button ID="button1" Text="Button" runat="server" OnClick="InsertEvent" /> </ItemTemplate> </asp:TemplateField> </Columns></asp:GridView>

In your code-behind:

protected void InsertEvent(object sender, GridViewRowEventArgs e) {string CategoryDescription = e.Row.Cells[0].ToString(); /// Here, it depends on which datafield do you want to insert into your datatable? You also can use Cell[int] to access other datafield in the current row.string conn_str=ConfigurationManager.ConnectionStrings["AquilaConnectionString"].ConnectionString; SqlConnection myconn =new SqlConnection(conn_str);string insert_command ="Your insert command here."; SqlCommand mycomm =new SqlCommand(myconn, insert_command); myconn.Open(); mycomm.ExecuteNonQuery(); mycomm.Dispose(); myconn.Close(); }

Thanks.sql

Saving Auto Recovery Information

Hi

I am using the Microsoft SQL Server Management Studio to manage our database objects over a VPN connection. At scheduled intervals the system saves recovery information.

The problem is that the location of the recovery files appears to be located on a remote server. This causes the UI to completely freeze while the operation is in progress.

How can I change the location of the recovery files or turn off the Auto Recovery functionality completely.

In VS2005 this is configurable in the Tools-->Options-->Environment settings.

Thanks.

There is not configurable today in SQL 2005. We have a tracking bug for this issue.

Thanks,

Gops Dwarak

|||

Thanks for the reply.

Do you know when a fix may be released for this? Are you aware of how I can get the Enterprise Manager working on the same pc as the SQL Server Management Studio or do I need to uninstall SQL Server 2005?

Regards

David

|||

Enterprise manager and SQL Server Management studio can be run side by side on the same box. Answer is, you do not need to uninstall SQL 2005 to get Enterprise Manger working.

On the fix for the Autorecovery, it is planned to be fixed in next service pack. We are in planning stage for next service pack and to not have dates for this release now.

Thanks,

Gops Dwarak, MSFT

|||

I haven't tried this but this registry mod should disable AutoRecovery. If it doesn't work let me know and I'll dig a bit deeper. All the standard disclaimers about registry manipulation apply.

Go to HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover and change the “AutoRecover Enabled” value to zero.

|||

Bruce,

I have tried your fix on an XP SP2 machine and it seems to have worked. The only thing was that the reg key path for me (using SQL Server Management Studio Express) was:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\General\AutoRecover

Thanks.

|||

Hi everybody.

I'm having the same problem in Microsoft Visual Studio 2005, Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework Version 2.0.50727 but not only the IDE freezes when saving autorecovery information but also when saving any modified file.

Do you guys know of a thread like this related to this issue? Any ideas?

Thanks a lot!

|||

Hi,

I have the same problem.

There is a conflict between the antivirus and the source control.

I did not find a solution yet. Does somebody have an idea?

Thanks.

Saving Auto Recovery Information

Hi

I am using the Microsoft SQL Server Management Studio to manage our database objects over a VPN connection. At scheduled intervals the system saves recovery information.

The problem is that the location of the recovery files appears to be located on a remote server. This causes the UI to completely freeze while the operation is in progress.

How can I change the location of the recovery files or turn off the Auto Recovery functionality completely.

In VS2005 this is configurable in the Tools-->Options-->Environment settings.

Thanks.

There is not configurable today in SQL 2005. We have a tracking bug for this issue.

Thanks,

Gops Dwarak

|||

Thanks for the reply.

Do you know when a fix may be released for this? Are you aware of how I can get the Enterprise Manager working on the same pc as the SQL Server Management Studio or do I need to uninstall SQL Server 2005?

Regards

David

|||

Enterprise manager and SQL Server Management studio can be run side by side on the same box. Answer is, you do not need to uninstall SQL 2005 to get Enterprise Manger working.

On the fix for the Autorecovery, it is planned to be fixed in next service pack. We are in planning stage for next service pack and to not have dates for this release now.

Thanks,

Gops Dwarak, MSFT

|||

I haven't tried this but this registry mod should disable AutoRecovery. If it doesn't work let me know and I'll dig a bit deeper. All the standard disclaimers about registry manipulation apply.

Go to HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover and change the “AutoRecover Enabled” value to zero.

|||

Bruce,

I have tried your fix on an XP SP2 machine and it seems to have worked. The only thing was that the reg key path for me (using SQL Server Management Studio Express) was:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\General\AutoRecover

Thanks.

|||

Hi everybody.

I'm having the same problem in Microsoft Visual Studio 2005, Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework Version 2.0.50727 but not only the IDE freezes when saving autorecovery information but also when saving any modified file.

Do you guys know of a thread like this related to this issue? Any ideas?

Thanks a lot!

|||

Hi,

I have the same problem.

There is a conflict between the antivirus and the source control.

I did not find a solution yet. Does somebody have an idea?

Thanks.

sql

Saving Auto Recovery Information

Hi

I am using the Microsoft SQL Server Management Studio to manage our database objects over a VPN connection. At scheduled intervals the system saves recovery information.

The problem is that the location of the recovery files appears to be located on a remote server. This causes the UI to completely freeze while the operation is in progress.

How can I change the location of the recovery files or turn off the Auto Recovery functionality completely.

In VS2005 this is configurable in the Tools-->Options-->Environment settings.

Thanks.

There is not configurable today in SQL 2005. We have a tracking bug for this issue.

Thanks,

Gops Dwarak

|||

Thanks for the reply.

Do you know when a fix may be released for this? Are you aware of how I can get the Enterprise Manager working on the same pc as the SQL Server Management Studio or do I need to uninstall SQL Server 2005?

Regards

David

|||

Enterprise manager and SQL Server Management studio can be run side by side on the same box. Answer is, you do not need to uninstall SQL 2005 to get Enterprise Manger working.

On the fix for the Autorecovery, it is planned to be fixed in next service pack. We are in planning stage for next service pack and to not have dates for this release now.

Thanks,

Gops Dwarak, MSFT

|||

I haven't tried this but this registry mod should disable AutoRecovery. If it doesn't work let me know and I'll dig a bit deeper. All the standard disclaimers about registry manipulation apply.

Go to HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover and change the “AutoRecover Enabled” value to zero.

|||

Bruce,

I have tried your fix on an XP SP2 machine and it seems to have worked. The only thing was that the reg key path for me (using SQL Server Management Studio Express) was:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\General\AutoRecover

Thanks.

|||

Hi everybody.

I'm having the same problem in Microsoft Visual Studio 2005, Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework Version 2.0.50727 but not only the IDE freezes when saving autorecovery information but also when saving any modified file.

Do you guys know of a thread like this related to this issue? Any ideas?

Thanks a lot!

|||

Hi,

I have the same problem.

There is a conflict between the antivirus and the source control.

I did not find a solution yet. Does somebody have an idea?

Thanks.

saving and retreivig the files on sqlserver

Hi!

I want to save and retreive some files on sqlserver. I want to save the files in binary format on sqlserver and I want to get back them in their format.Is it possible in c#? If possible please help me to do this. I already succeeded to save a file in binary format, but i am getting problem to retreive that in its format.

Thanks in adance

Fro Exmple, to save Image Files in Sql Server...

Inserting Images to SqlServer in ASP .NET: ASP Alliance

Retrieving Images from SqlServer in ASP .NET: ASP Alliance

Excellent Tutorial regarding storing / retriving files on server as well as in database:Storing Uploaded Files in a Database or in the File System with ASP.NET 2.0

hope it helps./.

Saving a package into a folder in MSDB

Hi

I am trying to load a ssis package into a folder (lets say SSIS packages) that I created in MSDB but its geeting saved in the root (MSDB) not into the SSIS packages folder...I am doing this thru C#...

Have you tried using the Application.SaveToSqlServerAs method? The 3rd parameter is the package path and there you can specify the "\folder\folder1....\packageName" format for your package.

More info about Application.SaveToSqlServerAs can be found at http://msdn2.microsoft.com/ko-kr/library/microsoft.sqlserver.dts.runtime.application.savetosqlserveras.aspx

HTH,
Ovidiu

|||Thanx Ovidiu... I also checked that before and now its working fine...

SAN And Drive Config

Hi
I have been reading recently that the most important area of design in a SQL
system is the drive subsystem. With this I would appreciate some feedback on
the type of issues relating to this, drive spindles, speed of drives, LUN
configs on the SAN and so on.
ThanksIn an ideal world, you would have these all on different spindles:
O/S, SQL Server program files
TempDB
Data files
Log files
Backup files
Make sure the SAN admin(s) gets actual different spindles, not just
different LUNs in the same disk group. My terminology is probably off, but
I think the point is clear
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"News Microsoft" <thestig@.nobody.com> wrote in message
news:O98pYd$dFHA.2960@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have been reading recently that the most important area of design in a
> SQL system is the drive subsystem. With this I would appreciate some
> feedback on the type of issues relating to this, drive spindles, speed of
> drives, LUN configs on the SAN and so on.
> Thanks
>
>|||Well, actually the MOST important area where the most performance can be
gained is in the database design. Assuming the database design is
optimal, then you are correct, look at the disk subsystem.
Disk subsystem design could be summarised in a white paper, not in a
single usenet message. Have a search in google - there' plenty of topics
online that discusses this. Sorry I don't have any links for you at the mo.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
News Microsoft wrote:
> Hi
> I have been reading recently that the most important area of design in a S
QL
> system is the drive subsystem. With this I would appreciate some feedback
on
> the type of issues relating to this, drive spindles, speed of drives, LUN
> configs on the SAN and so on.
> Thanks
>
>|||awesome article on this topic on SQLServerCentral.com
check it out
Greg Jackson
PDX, Oregon

SAN And Drive Config

Hi
I have been reading recently that the most important area of design in a SQL
system is the drive subsystem. With this I would appreciate some feedback on
the type of issues relating to this, drive spindles, speed of drives, LUN
configs on the SAN and so on.
Thanks
In an ideal world, you would have these all on different spindles:
O/S, SQL Server program files
TempDB
Data files
Log files
Backup files
Make sure the SAN admin(s) gets actual different spindles, not just
different LUNs in the same disk group. My terminology is probably off, but
I think the point is clear
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"News Microsoft" <thestig@.nobody.com> wrote in message
news:O98pYd$dFHA.2960@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have been reading recently that the most important area of design in a
> SQL system is the drive subsystem. With this I would appreciate some
> feedback on the type of issues relating to this, drive spindles, speed of
> drives, LUN configs on the SAN and so on.
> Thanks
>
>
|||Well, actually the MOST important area where the most performance can be
gained is in the database design. Assuming the database design is
optimal, then you are correct, look at the disk subsystem.
Disk subsystem design could be summarised in a white paper, not in a
single usenet message. Have a search in google - there' plenty of topics
online that discusses this. Sorry I don't have any links for you at the mo.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
News Microsoft wrote:
> Hi
> I have been reading recently that the most important area of design in a SQL
> system is the drive subsystem. With this I would appreciate some feedback on
> the type of issues relating to this, drive spindles, speed of drives, LUN
> configs on the SAN and so on.
> Thanks
>
>
|||awesome article on this topic on SQLServerCentral.com
check it out
Greg Jackson
PDX, Oregon