Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info.
SEARCH THE FOXITE.COM VISUAL FOXPRO FORUM ARCHIVES
Please enter one or more search terms:
search (case insensitive):


order by:


sort:
SEARCH RESULT Results 1 - 25 of 236 for MDF. (0.1404009 seconds)


ADD DATA *.MDF IN TO SQL 2005
Thread ID: 329287 Anh Phuc ADD DATA *.MDF IN TO SQL 2005 Dear Expert Any body have code add data file SQL *.MDF in to MS SQL server 2005 ? thanks very much +++++

Adding records to an SQL table
Thread ID: 131058 Bob Gatto Adding records to an SQL table Hell One And All, I trying to add records from a table in DBF format (created with Visual FoxPro) into an SQL table created with SQL Server 2005. I first converted the dbf fi...

Attach Database Failed (Northwind sample
Thread ID: 214683 Cecil Champenois Attach Database Failed (Northwind sample I have tried attaching the Northwind and Pubs databases from the "C:\SQL Server 2000 Sample Databases\" folder, but I receive an error saying the following: "Un...

attach SQL DataBase From VFP
Thread ID: 101683 yaser awwad attach SQL DataBase From VFP Hi All i use sql connection to get database from Sql server 2000 i want to know if i can attach database file 'account.mdf' to Sql server from foxpro without using 'Enterprise M...

BULK INSERT in MS Sequel 2005
Thread ID: 128605 Ilya Rabyy BULK INSERT in MS Sequel 2005 Colleagues, I am trying to transfer data from DBF to MDF by copying the data from DBF into a flat file (delimited with blank) and then to run BULK INSERT in the MS SQL Server 2005 Management Studio. Now, I always get the same error from Sequel: "Msg 4863, Level 16, State 1, Line 1 Bulk load data conversion error (truncation) for row 1, column 4 (MI)." "MI" is Middle Initial field, CHAR(1), in MDF's table (named "People"), as well as in the original DBF table. I tried other delimiters ("pipe" being the latest one), and the result was always an error, either the one above or "Msg 4832, Level 16, State 1, Line 1 Bulk load: An unexpected

Can't access SQL Server Sample Database
Thread ID: 258636 Cecil Champenois Can't access SQL Server Sample Database I have a local file for the NorthWnd database that was copied to the bin\debug folder of my C# 2008 project. When I run my ProductsForm, I immediately see an error...

change the default database
Thread ID: 63628 ANIL KAMAT change the default database anil I use SQl dmo to create databases on to SQL Server. I want to change the default database to the which created eg: osqlserver=CREATEOBJECT("sqldmo.sqlserver") OSQLSERVER.C...

convert dbf to mdb
Thread ID: 206966 Rabih Tawil convert dbf to mdb hello community, is there any code i can use to convert from DBF or DBC to mdb(data access tables), mdf (SQL server tables)??

Creating database in SQL 2005
>><>.mdf', SIZE = 100, MAXSIZE = 500, FILEGROWTH = 5 ) LOG ON ( NAME = '<>_log', FILENAME = '<><>.ldf', SIZE = 10MB, MAXSIZE = 50MB, FILEGROWTH = 15MB ) USE <
data type
Thread ID: 369498 Noel Cris data type Hi All, Suppose I have lastnames to be stored in a table and suppose that those lastnames maximum length never exceed 20 characters. What's the implications if my data type for lastnames is varchar(20) or varchar(255)? Does it really matter? How about the MDF size? Thanks all. -noel

Dbf to Mdf
Thread ID: 170077 Bernier Mejorada Dbf to Mdf Good day to all VFP people! Anybody who knows how to convert DBF TO MDF(ms-sql)? is there any 3rd party software that we can use? I have less knowledge about ms-sql. thanks in advance. bernz

dbf2sql
Thread ID: 249473 Tariq mehmood dbf2sql Dear Experts How to convert dbc2sql (mdf) dbc2sql (dbo) Please help

Dear Expert,Binod Binani,Michel Levy
', .F.) ENDIF **1 TEXT TO cmakedbc CREATE DATABASE <> ON ( NAME = <>_dat, FILENAME = '<><>.mdf', SIZE = 100, MAXSIZE = 500, FILEGROWTH = 5 ) LOG ON ( NAME

Executing xp_cmdshell in MS SQL/Attaching MDF
Thread ID: 101949 Rene Relucio Executing xp_cmdshell in MS SQL/Attaching MDF Hi Experts! I am trying to use xp_cmdshell, an extended stored procedure in MS SQL 2000. In the update trigger, I EXECUTE a stored procedure. In this stored procedure is the statement: EXEC xp_cmdshell 'copy c:\sqldumps\pubs.dmp \\server2\backups\sqldumps', NO_OUTPUT However, I get a message: Could not find stored procedure 'xp_cmdshell'. The User account initiating the update trigger has a system administrator role. HYCH Regards, Rene-PCSO

file copy for SQL Server database
Thread ID: 304131 Nilson Rishi file copy for SQL Server database Expert, I found I could copy and paste the database file, both mydata.MDF and mydata.LDF from the SQL Server installation DATA folder,even after I run my exe that queried ...

foreign key problem after copying DB
, @PhysicalName SET @LOGFILE = @LOGICALNAME+'_log' SET @ToLog = REPLACE(@TODB,'.mdf','.LDF') RESTORE DATABASE [<>] FROM DISK = @PhysicalName WITH FILE = 1, MOVE @LOGICALNAME TO @TODB, MOVE

Getting error while Restoring the Sql Se
Thread ID: 119227 Abdulla Rahiman Getting error while Restoring the Sql Se Dear Experts, When i m trying restore databse from backup,Using SQL server 2005. i got an error message like this MODIFY FILE encountered operating system error 112 (There is not enough space on the disk.) to expand the physical file. RESTORE DATABASE is terminating abnormally The size of Backup file is 800MB and 9.00 GB is free in Drive C:. (Note : I have seen that The original siz of Mdf is 800 MB and the size of Log file 9.2 GB) Can anybody help me to sovle this issue. I have one more doubts Since the size of Log file is 9.2 GB, How the backup file size become 800 MB ? With thanks and regards Abdulla

how restore sql databse file in new data
Thread ID: 291895 prasanna kunder how restore sql databse file in new data hi experts i copy sqlserver200 mdf and ldf file from my home computer, now i try to restore that file on my office system in sqlserver2000 pl.guide me how to do within sqlserver2000 prsanna

how to configure sql server 2000-remote
Thread ID: 291559 prasanna kunder how to configure sql server 2000-remote hi expert i have total 3 computer on my lan, i have adsl broad band with router, router ip is 192.168.1.1 , my local area network computer 192.168.10,11,12 my local system 192.168.1.10 have sql server 2000 installed, now i want to use remotely this sql database(mdf) when i configure my router with static ip address, what type of server i should take, ie web server, ftp or anything else please guide me prasanna

How to programmatically attach a database to a server
Thread ID: 104185 nyron williams How to programmatically attach a database to a server hello everyone, i was wondering if anyone knows how to programmatically attach the mdf & ldf files for a database to an insatance os ms sql server. thanks in advance!

Loading DE is very slow in VFP 8 with Sql Server
Thread ID: 56760 Abdulla Rahiman Loading DE is very slow in VFP 8 with Sql Server Dear all I created a CA through the dataenvironment and its working fine, this is good for DE with few tables, Loading DE become very slow with respect o...

Login .net components
Thread ID: 157327 Rene Relucio Login .net components Hi Experts! As part of my horizontal growth, I tried to learn ASP.NET by reading and doing the hands on exercises from the book Asp.net in 24 Hours. I tried to use the Login .net c...

MS Sql 2005 Express: Database Protection
Thread ID: 352005 Binod Binani MS Sql 2005 Express: Database Protection Dear Expert, I m using MS SQL 2005 Express Edition. I have different database created for my different Application. My Database is stored in different Folder rather than default path. ie.: d:\Stock_001\Stock_001.mdf d:\Stock_001\Stock_001.ldf here database name is 'STOCK_001'. I m using windows authentication & no special password for SQL server. Whenever I work in office I simply copy these two files and detach/attach the same in my home pc. Plz show me how cud i create/protect Password database for reason: No one wud install the same mdf/ldf files and attached in their own pc and cud have a look in structure/SP. Please

MS SQL Create database from VFP
Thread ID: 292935 Binod Binani MS SQL Create database from VFP Dear Expert This is in related to my Last Post 'MS SQL Create Database Scrip'. I m trying to create database in MS SQL 2005 through VFP. My Codes: ** makedbc.prg ** To create SQL DATAbase in MS SQL SERVER STORE "courier" TO cDatabasename STORE "d:\SQLDBC\" TO cDatapath ** Creating TEXT TEXT TO cmakedbc TEXTMERGE noshow USE master GO CREATE DATABASE <> ON ( NAME = <>_dat, FILENAME = '<><>.mdf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ) LOG ON ( NAME = '<>_log', FILENAME = '<><>.ldf', SIZE = 5MB, MAXSIZE

mssql7 attach database
Thread ID: 250607 mk sharma mssql7 attach database i have a mssql7 database i have copied the file MDF & LDF to mssql\data folder, but not showing in the sql server manager how i can attach this data files to sql server manger. warm regards, mk.


Result Page: 1 2 3 4 5 6 7 8 9 10