match columns and replace according to match..

Hey all,

I used to work with Microsoft Foxpro 6 regularly but now I haven't touched it in months and forgot the proper syntax

I have two databases, they're both the same except that one is outdated. I'd like to match the outdated one up to the good one by product code, and replace all product weights with the newer weight, when the codes match.

foxpro is giving me hell about it though, here's the command I'm trying to execute

-------

repla all prods428.product_we with prods.product_we where prods428.product_co = prods.product_co

--------------

in english, replace all old products weight with new products weight, where old products code equals the new product code..

Any help? I'm sure it's just a minor syntax thing. Thanks in advance :)Hey all,
-------
repla all prods428.product_we with prods.product_we where prods428.product_co = prods.product_co
--------------

in english, replace all old products weight with new products weight, where old products code equals the new product code..

Any help? I'm sure it's just a minor syntax thing. Thanks in advance :)
Now I am not a foxpro guru but I have a hunch that you may want to say repace instead of repla. How's that?|||I'd suggest that you start with the REPLACE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/lngreplace.asp) documentation. Your example looks like you are combining the syntax for REPLACE with SQL syntax, and that VFP is having trouble sorting out what you meant!

-PatP

Matadata translations - Editions

Hi,

the link http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Mentions "Metadata Translations" is a feature of the enterprise edition only - is this true ?

Means if i want to have a dimension name in german and english this is only possible in the Enterprise edition ?
The Sample shows translations and it works in the standard edition - I guess its only a mistake in the documentation - is it ?

HANNES

No it is not a mistake. Usage of translations reserved only for the Enterprise and Developer edition.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||But it works in the Standard edition on my test server - I could deploy translation, but i cannot deplay perspectives . therefore i guess this is wrong in doc.

I use 32 Bit Standard edition with SP1 - and Cummulative Build 2153

Meens this is a bug in SP1 ? and maybe getting removed in further fixes?

MFG
Hannes Mayer|||

If some of the limitations are not enforced by Analysis Server this doesnt mean you can use it in the way it is not intended.

If documentation clearly states you cannot use one of the features in certain edition, you should not. If, say, tomorrow Analysis Server starts enforcing the limitation, you might not be able to see your database.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

mastlog.ldf and other locked files

Whenever I back up my laptop, I get a series of messages that the files
in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
folder such as mastlog.ldf are being used by another application. The
backup stalls until I manually tell it to skip these files.
Is there any way to identify what application is using these files?
I am running WIndows XP.
Thanks,
Dani<reachdani@.gmail.com> wrote in message
news:1131309673.446106.52540@.g44g2000cwa.googlegroups.com...
> Whenever I back up my laptop, I get a series of messages that the files
> in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
> folder such as mastlog.ldf are being used by another application. The
> backup stalls until I manually tell it to skip these files.
> Is there any way to identify what application is using these files?
> I am running WIndows XP.
> Thanks,
> Dani
>
Mastlog.ldf is the log file for master. SQL Server will open the Master
database whether or not other applications are in use.
If you want to backup SQL databases then the best way is usually to use the
SQL BACKUP command. That's doubly so for Master. If you want to back them up
via the file system then shutdown the SQL Server service first - I assume
that won't be a problem on your laptop.
--
David Portas
SQL Server MVP
--|||Hi
Looks like BCM = Business Contact Manager, a option for Microsoft Office
2003.
It seems to use MSDE to store data. MSDE is the free version of SQL Server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:kLSdnSlrKtLb4fPeRVnyuQ@.giganews.com...
> <reachdani@.gmail.com> wrote in message
> news:1131309673.446106.52540@.g44g2000cwa.googlegroups.com...
>> Whenever I back up my laptop, I get a series of messages that the files
>> in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
>> folder such as mastlog.ldf are being used by another application. The
>> backup stalls until I manually tell it to skip these files.
>> Is there any way to identify what application is using these files?
>> I am running WIndows XP.
>> Thanks,
>> Dani
> Mastlog.ldf is the log file for master. SQL Server will open the Master
> database whether or not other applications are in use.
> If you want to backup SQL databases then the best way is usually to use
> the SQL BACKUP command. That's doubly so for Master. If you want to back
> them up via the file system then shutdown the SQL Server service first - I
> assume that won't be a problem on your laptop.
> --
> David Portas
> SQL Server MVP
> --
>

mastlog.ldf and other locked files

Whenever I back up my laptop, I get a series of messages that the files
in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
folder such as mastlog.ldf are being used by another application. The
backup stalls until I manually tell it to skip these files.
Is there any way to identify what application is using these files?
I am running WIndows XP.
Thanks,
Dani
<reachdani@.gmail.com> wrote in message
news:1131309673.446106.52540@.g44g2000cwa.googlegro ups.com...
> Whenever I back up my laptop, I get a series of messages that the files
> in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
> folder such as mastlog.ldf are being used by another application. The
> backup stalls until I manually tell it to skip these files.
> Is there any way to identify what application is using these files?
> I am running WIndows XP.
> Thanks,
> Dani
>
Mastlog.ldf is the log file for master. SQL Server will open the Master
database whether or not other applications are in use.
If you want to backup SQL databases then the best way is usually to use the
SQL BACKUP command. That's doubly so for Master. If you want to back them up
via the file system then shutdown the SQL Server service first - I assume
that won't be a problem on your laptop.
David Portas
SQL Server MVP
|||Hi
Looks like BCM = Business Contact Manager, a option for Microsoft Office
2003.
It seems to use MSDE to store data. MSDE is the free version of SQL Server.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:kLSdnSlrKtLb4fPeRVnyuQ@.giganews.com...
> <reachdani@.gmail.com> wrote in message
> news:1131309673.446106.52540@.g44g2000cwa.googlegro ups.com...
> Mastlog.ldf is the log file for master. SQL Server will open the Master
> database whether or not other applications are in use.
> If you want to backup SQL databases then the best way is usually to use
> the SQL BACKUP command. That's doubly so for Master. If you want to back
> them up via the file system then shutdown the SQL Server service first - I
> assume that won't be a problem on your laptop.
> --
> David Portas
> SQL Server MVP
> --
>

mastlog.ldf and other locked files

Whenever I back up my laptop, I get a series of messages that the files
in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
folder such as mastlog.ldf are being used by another application. The
backup stalls until I manually tell it to skip these files.
Is there any way to identify what application is using these files?
I am running WIndows XP.
Thanks,
Dani<reachdani@.gmail.com> wrote in message
news:1131309673.446106.52540@.g44g2000cwa.googlegroups.com...
> Whenever I back up my laptop, I get a series of messages that the files
> in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
> folder such as mastlog.ldf are being used by another application. The
> backup stalls until I manually tell it to skip these files.
> Is there any way to identify what application is using these files?
> I am running WIndows XP.
> Thanks,
> Dani
>
Mastlog.ldf is the log file for master. SQL Server will open the Master
database whether or not other applications are in use.
If you want to backup SQL databases then the best way is usually to use the
SQL BACKUP command. That's doubly so for Master. If you want to back them up
via the file system then shutdown the SQL Server service first - I assume
that won't be a problem on your laptop.
David Portas
SQL Server MVP
--|||Hi
Looks like BCM = Business Contact Manager, a option for Microsoft Office
2003.
It seems to use MSDE to store data. MSDE is the free version of SQL Server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:kLSdnSlrKtLb4fPeRVnyuQ@.giganews.com...
> <reachdani@.gmail.com> wrote in message
> news:1131309673.446106.52540@.g44g2000cwa.googlegroups.com...
> Mastlog.ldf is the log file for master. SQL Server will open the Master
> database whether or not other applications are in use.
> If you want to backup SQL databases then the best way is usually to use
> the SQL BACKUP command. That's doubly so for Master. If you want to back
> them up via the file system then shutdown the SQL Server service first - I
> assume that won't be a problem on your laptop.
> --
> David Portas
> SQL Server MVP
> --
>

mastlog.ldf

our mastlog.ldf file of Master database got deleted accidently by some user.
Is there anyway that the database could be started and new log file created
. master.mdf file is intact.
Thanks
ATDid you try restarting the server? If it won't start then you can rebuild
Master using the rebuildm utility (see Books Online for details). Then start
the server in single-user mode, restore Master from a backup (you do backup
the Master database don't you...?) or manually reattach your databases,
recreate logins, etc.
Make sure that the location of your database files is only accessible by the
administrator and the SQL Server service account so that this can't happen
again.
David Portas
SQL Server MVP
--|||David,
There is no backup available for master database. all I have is mdf file. Is
n't there any way that I can use this file to rebuild master database.
Thanks
AT|||HI
Maybe help for you:
I tested the following procedure, and successfully completed, but not guaran
tee your success.
And the future: Backup system databases periodically (daily)!
Copy to test server the master.mdf and rename
Use sp_attach_single_file_db wit another name than master (eg: NewMaser)
Use rebuilm.exe. (Copy SQL setup cd to hard disk and remove the read only fl
ag from files!)
Reinstall Service Packs and patches.
Stop the SQL server.
Create file backup from master.mdf and mastlog.ldf (Maybe You need restart
the restore)
Then start the server in single-user mode
--Like another way from here
Allow modifications to be made directly to the system catalogs
Update sysconfigures, syscurconfigs, tables from NewMaster database
Create insert statements and copy data from NewMaster to master database (US
E: WHERE NOT IN NEW MASTER..TABLE)
-sysaltfiles (or attach all production database and distribution if exist)
-sysservers (better: Recreate Linked Servers from documentation.)
-sysmessages (It is easy)
-sysxlogins (better: use the another way procedure for recreate logins)
-sysusers (or recreate users in master)
Disable modifications to be made directly to the system catalogs
Backup the master database
Test the server
Restart server
Backup master database
Another way:
-Recreate logins:
read the folowing: Microsoft Knowledge Base Article - 246133
< http://support.microsoft.com/defaul...133&Product=sql
>
Rewrite the sp_help_revlogin (use the attachaed database as source eg: FROM
master..sysxlogins --> FROM TESTSERVER.NewMaster.dbo.sysxlogins)
Recreate Linked Servers from documentation. (If You used remote server for r
eplication create linked server instead of remote)
Recreate users on master
Attach all production databases and distribution database.
Import custom sysmessages from NewMaster
Disable modifications to be made directly to the system catalogs
Backup the master database
Test the server
Restart server
Backup master database
At end:
Create scheduled backup for system databases.
And repair and repair until errors disappear. (The original values in NewMas
ter help You, do not drop!)
JBandi

Master-Details Insert

Master table (tlbProduct) having productID as Primary key and
which acts as reference key for table (tlbCategory).
Fields for tlbProduct are productID,productName
Fields for tlbCategort are productID,CategoryID(primary key),CategoryName,Prize
both productID,CategoryID are autoincrementing.
but when i write two inserts simultaneously as follows
insert into tlbProduct(productName)values(@.productName)
insert into tlbCategory(CategoryName,Prize) using sqldatasource
I get the error that ProductID value is null which is not provided
But (productId in both is autoincremented) and relationship is there in both tables
How to resolve this problem without adding ProductID in second Insert
?
SWati

Hello,

to create a relationship between two tables in sql, you need to match the primary key and the foreign key. So after the first insert, you would need to find out the id that was inserted by the database for the product (you can do this with SELECT SCOPE_IDENTITY()), and then you need to use this id in the second insert statement. If the keys don't match and the database is trying to enforce a relationship between the tables, you will get an error.

Good luck