Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

How To Create A Database On Pendrive Using MSSQL 7.0??

Hey friends,
I want create a database on a usb pendrive and acess it my server is
MSSQL 7.0 when ever i plugin the pend drive.
Please let me know the the procedure .. this is a chellenging job..
Thank You

*** Sent via Developersdex ***
Don't just participate in USENET...get rewarded for it!

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Connecting DB On A Pendrive In MSSQL 7.0
I am developing an application in VB. I want to know whether we can keep the database file (.mdf) on the pendrive in MS SQL 7.0. If this can be done HOW CAN THIS BE DONE Please guide me. It should be that when i connect my pendrive to the machine / server then i should be able to acess the database. This is a chellenging job which i have taken. Please guide me if this is possible.
Hoping for you HELP
THank YOu
Vikram Jain

View Replies !   View Related
Simply Create A Table In A MsSQL Express Database Through
Hello there,Now I'm really down, how do I simply create a Table in a database?It must be something likeCreate Table TableName
column_name data_type
But first how do I execute that string, so it create the table..And if we get that far, how do you then set a table to primarykey?
Hope really for help, because this is a importen thing, and I cant find the answer? :S

View Replies !   View Related
Create Temp Table To Store Data From Database(mssql)
I am a starter of and trying to build a web application. Do anyone know how to create a temp table to store data from database? I need to extract data from 3 different tables (Profile,Family,Quali). Therefore, i need to use 3 different queries to extract from the 3 tables and then store it in the temp table. Then, i need to output the data from temp table to the screen. Do anyone can help me?

View Replies !   View Related
Conversion Of MSSql 2000 Database To MSSQL 2005 Database
How to convert a database in MSSQL 2000 to MSSQL 2005 database.Is there any tool or documentation available for this?

View Replies !   View Related
Database Migration Plan - (mssql/msde To -&> Pgsql/mssql)

i was planning to create a database migration tool ..
its a certain database of a DMS (document management system) to
another DMS (two different DMS)... from DMS using msde 2000 server .. and tranfer to a DMS using a postgre sql or mssql .. depends ..

they have different table structures and names . . :D

i was thing of what language shall i use.. or what language is the best to work on this kind of project :)

hoping for your kind help guys. thanks :)


View Replies !   View Related
Cant Create New Database / CREATE DATABASE Permission Denied In Database Master (error 262)
 I am using SQL express and Visual web developer on windows Vista.
When I try to create a new database the following message appears.
CREATE DATABASE permission denied in database master (error 262)
I log on to my computer as an administrator.
Help appreciated

View Replies !   View Related
Hi all,

I am writing an application that is required to create specific Databases on the fly.

I am coding with PHP and have no troubles in creating DB's, example code as follows:

//Create new DB
$create_db = "CREATE DATABASE " . $_POST['name'] . "
( NAME = " . $_POST['name'] . "_dat, FILENAME = 'c:program filesmicrosoft sql servermssqldata\" . $_POST['name'] . ".mdf SIZE = 10,MAXSIZE = 50,FILEGROWTH = 5 )
( NAME = " . $_POST['name'] . "_log, FILENAME = 'c:program filesmicrosoft sql servermssqldata\" . $_POST['name'] . ".ldf',

The problem occurs when I try to view the database through a third party application (MSSQL Manager), it wont appear until its registered.

Therein lies my problem, how to register the database via code or scripts.

Am I even on the right track here?



View Replies !   View Related
Create Table In MSSQL
Hi anyone can tell me how to create a table from an existing table in MSSQL.
In oracle we issue " create table <tablea> as select * from <tableb>; " ?
Thanks in Advance.

View Replies !   View Related
Create A View In MSSQL 2000
I have created a view in MS SQL2000 as followed:

Select order_NO, shiptoname, Shiptoaddress, Shiptocity,shiptostate, shiptozip,
FROM orders;

my question is: If the email exist in the EMAILaddress column then I need to have a Y show in another column called EMAILflag, if the EMAILaddress does not exist then I would need the EMAILflag to be a N.

Any HELP would be GREAT.
Thank You!!

View Replies !   View Related
How Do I Create A Ranking Query In MSSQL
I need to use mssql to create a ranking of some kind. This is the situation:
I need to assign position to a list of students based on thier scores. e.g
Student Score Position
StudentA 56 4
StudentB 78 1
StudentC 66 2
StudentD 56 4

I need to create the positions based on the scores of the ctudents.
I will appreciate any assistance.
Thank you.

View Replies !   View Related
How To Create A Linked Server To MySQL From MsSQL?
I can create a linked server to another MsSQL from MsSQL,but encounter error when create a linked server to MySQL:
Error 7399:OLE DB provider 'MSDASQL' reported an error.
Data source name not found and no default driver specified.

Anyone can help me?

View Replies !   View Related
How To Run Mysql Create Table Script Into MsSQL
Dear All,

I have the table creation script and insret record script.
This is MySQl Format.
What changes I have to do so can I run this scripts into SQL Server 2000.
If any body has successfully done it then please tell me the procedure.

CREATE TABLE `activity` (
`id` bigint(20) NOT NULL auto_increment,
`object_type` varchar(60) default NULL,
`object_id` varchar(20) default NULL,
`person_id` bigint(20) NOT NULL default '0',
`activity_dtm` datetime NOT NULL default '0000-00-00 00:00:00',
`activity_type_cd` varchar(25) NOT NULL default '',
`description_code` varchar(200) default NULL,
KEY `FK9D4BF30FB4715636` (`activity_type_cd`),
KEY `FK9D4BF30F270CDEE0` (`person_id`)

-- Dumping data for table `activity`

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

-- Table structure for table `actv_type`

CREATE TABLE `actv_type` (
`code` varchar(25) NOT NULL default '',
`description` varchar(100) NOT NULL default '',
`void_ind` char(1) NOT NULL default '',
PRIMARY KEY (`code`)

-- Dumping data for table `actv_type`

INSERT INTO `actv_type` VALUES ('job_create', 'Created job', 'F');
INSERT INTO `actv_type` VALUES ('job_update', 'Changed job', 'F');
INSERT INTO `actv_type` VALUES ('job_void', 'Voided job', 'F');
INSERT INTO `actv_type` VALUES ('job_activate', 'Activated job', 'F');
INSERT INTO `actv_type` VALUES ('job_deactivate', 'Changed job to deactive', 'F');
INSERT INTO `actv_type` VALUES ('job_appl_create', 'Created application', 'F');
INSERT INTO `actv_type` VALUES ('job_appl_update', 'Updated application', 'F');
INSERT INTO `actv_type` VALUES ('intrv_create', 'Created interview', 'F');
INSERT INTO `actv_type` VALUES ('intrv_update', 'Updated interview', 'F');
INSERT INTO `actv_type` VALUES ('person_update', 'Update person', 'F');
INSERT INTO `actv_type` VALUES ('person_create', 'Create person', 'F');
INSERT INTO `actv_type` VALUES ('company_void', 'Voided company', 'F');
INSERT INTO `actv_type` VALUES ('company_create', 'Created company', 'F');
INSERT INTO `actv_type` VALUES ('company_update', 'Updated Company', 'F');

Thanks in Advance.

View Replies !   View Related
How To Create VBActivex Script(scheduler) Mssql 2005
 hi all, Iam using Activex Script in mssql2000, now i want to run the same in msql 2005. i cant run that script. what can i do to run the script in 2005 

View Replies !   View Related
Needful Parts Of MSSQL To Create Local Cube
I'm creating local cube with Delphi. On my server with MSSQL it work well, but i need to know, which parts of MSSQL is needful to create this local cube (on the server) if i will creat and instal new server with MS SQL.

Thanks for reply.

View Replies !   View Related
Boolean: {[If [table With This Name] Already Exists In [this Sql Database] Then [ Don't Create Another One] Else [create It And Populate It With These Values]}
the subject pretty much says it all, I want to be able to do the following in in code):
{[If [table with this name] already exists [in this sql database] then [ don't create another one] else [create it and populate it with these values]}
How would I do this?

View Replies !   View Related
Dynamic Create Table, Create Index Based Upon A Given Database
Can I dynamically (from a stored procedure) generatea create table script of all tables in a given database (with defaults etc)a create view script of all viewsa create function script of all functionsa create index script of all indexes.(The result will be 4 scripts)Arno de Jong,The Netherlands.

View Replies !   View Related
Not All Database Failover To Mirrored Database Server When MSSQL Service Stopped
We have a Prinicipal, a Mirror and a Witness server.  We have automatic failover configured between the Prinicipal and Mirrored server.  When we stop MMSQL service on Prinicipal, not all the databases failover to the Mirrored instance. 
Any suggestions would be welcomed as we have a tight deadline to get this in Production. 

View Replies !   View Related
MSSQL 2005 User Database Now Shows Up In System Database Folder
While attempting to set up sql replication in MSSQL 2005 one of my user databases is now in the systems database folder.  I need to move it back to the user databases folder.  Any help would be greatly appreciated.

View Replies !   View Related
Create Script To Create/Refresh Identical Database

I'm new to using SSIS and have been reading and learning slowly how to use it.  I'm trying to create an identical copy of our database for reporting.  I've used the Import/Export wizard, but have had some issues with foreign keys and with sql_variant columns. 
I've tried searching for anything but haven't had any luck as of yet.  I guess I don't even know where to start or what to look for.
Any help would be appreciated.  Thanks!

View Replies !   View Related
Adding Data To Database Or Viewing Database In MsSQL
I am new to ms SQL. I only have the use of the Enterprise Manager.
Creating tables I understand. However I am confused on how to add data to
a table or view the data in a table. Can this be done through Enterprise Manager? If I am adding a large amount of data do I have to use the query window. This seems like a tedious method. In Access yo have a form basically pop up where you can type in the record sets. Any advice would be appreciated! Sincerely,
Bill Bequette

View Replies !   View Related
Lotus Nsf File Database To MsSQL Database
Would any body be able to suggest the best way switch a Lotus .nsf file to Ms SQL database or even to an Access?

I have a .nsh file that I am able to see the contents of but not the database structure, and rather then rebuilding the database and manually inserting the content I would like to import all the information from an old .nsf file that appears to have restriction on it.

Any Suggestions

View Replies !   View Related
Create Database And Create Table

Hope someone can help.

I am writing a stored procedure that searchs for a database and if it doesn't exist in Master will create the database and within the same stored procedure will create the necessary tables.

Currently I am finding that because it is processing both from within the same transaction it will create the database and not the tables. Can someone please advise on whether this is possible and if so how.


View Replies !   View Related
Best Way To Connect To A MSSQL Database
 Hello,Is it better to use a DSN connection or using a connection string  Set Connection = Server.CreateObject("ADODB.Connection")  Which is easier to use and more reliable? Also could I have all the connection info on one page and then just include it with a include statment everytime I need to query the database?? Thank you, Rich    

View Replies !   View Related
How To Write To Mssql Database
I am very new to I really mainly use PHP but want to migrate to, but it doesn't seem that easy.I am creating a page for peson to pay a subscription page where they will enter personal information an credit card information.I created the form for this with validation controls.I don't know however how to write the form data to the mssql database.I am using mssql 2005, but i would need a work out for the 2000 version as well.

View Replies !   View Related
Mssql Database Connection
I've come from the asp world into .NET and I have looked all over the web for the proper way to make a database connection to a MSSQL server and all I have found is samples of connections to Access databases. Can anyone point me in the direction of how to create a db connection for microsoft sql server.thanks

View Replies !   View Related
Security Of Mssql Database?
Hello, another question from a newbie to mssql.Is there a way of allowing access to database only by providing username andpassword (disabling trusted connection and preventing administrator toaccess database through enterprise manager or otherwise without supplyingusername and password)?What I would like is that my application upon instalation creates databasewith appropriate tables (already done this) and somehow solely creates andmanages user list and passwords so that there is no access to database otherthrough application. (Application would create a backdoor account shouldsomething go wrong)

View Replies !   View Related
Export From Mssql Database
Hello,I try to export a mssql database into a csv-file.I tried this with asp, but it doesn't work.<%Dim objConnDim csv_pathSet objConn = Server.CreateObject("ADODB.Connection") "database","username","passwd"csv_path =Server.MapPath("./") & "csv_test.csv"SQL ="SELECT * INTO OUTFILE 'C:inetpubwwwrootcsv_test.csv' FIELDSTERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' FROM GROUPS"objConn.Execute SQLobjConn.CloseSet objConn = Nothing%>There is a problem near 'C:inetpubwwwrootcsv_test.csv'Can anyone help? Thank you.Manuel

View Replies !   View Related
Database Trigger In MSSQL
How can i create database level triggers in MS SQL? i m not talkingabout table trigger or view trigger.Khurram.

View Replies !   View Related
New To MSSQL - Creating A Database
Hello all,

I'm new to MS SQL server.

When using the "Management Studio" how do I create a database? When it starts up, I only seem to have the option of connecting to a database, while not actually creating one :S


View Replies !   View Related
Rename A Database Under Mssql 6.5?

I am supporting a mssql 6.5, sp 4 application.

We have set up an user acceptance server with a database that is the same as production. However, I have been told that this database and server may be used for applying fixes rather than user acceptance.

To avoid confusion over which database is on which server, it might be a good idea to rename the database. I am not sure if this can be done un der mssql 6.5?

1)Can I rename a database?

2)If so, how can I do so?

Which system tables would I use to update?

Any information you can furnish will be appreciated. THanks.

David Spaisman

View Replies !   View Related
How Do I Log Into The MSSQL Express Database
David writes "Dear sir,
I've installed VS.NET 2005 Professional many times and find that the MS SQL Express 2005 is running.
My ambition is to log into this server so that I can convert my MySQL database into it. What is the default;

What tool is provided so that I might execute my schema to create a database in this server. This 'schema' will obviously have many tables inside. Most SQL products provide some type of utility program where one can create, edit, delete databases and an adminstration program. I see nothing of yours in my Programs -> MS SQL Server 2005 -> SQL Computer Manager.
Thank you,
David Kennedy"

View Replies !   View Related
MDF Database To MSSQL 2005
I'm pretty new at this so bear with med


I've made af site in Visual Web Developer. On that site i've made a database and it worked finde when I first uploaded it to my FTP as a database file on the server. But due to security problems, my web hotel host has deactivated that possibility. SÃ¥ now I have to put my data and tables into the MSSQL 2005 Database the host uses. Now here's the problem.


1: How do I do that?


2: How do I get tha tables I've made i Visual Web Developer over in SQL Server Management Studio Express så that I can upload it?

View Replies !   View Related
MSSQL Database Comparison Tool
Does anyone know of a good (free) tool that will compare the structure of two databases.  Something that will compare Stored Procedures and Views would be great.Thanks.

View Replies !   View Related
Transfering MSSQL Database To Server
Has anyone had a problem transfering a database to a server.
This is the first time I have done this.
I have a site and sqldatabase hosted by a hosting company and I am supposed to transfer my database
This is what I'm doing

From the Start Menu, select "Programs" -> "Microsoft SQL Server" -> "Import and Export Data" then click "Next".
In the "Server" field, type in the Name or IP of the source server (your server), choose "Use SQL Server Authentication," type in your username and password, choose your database from the "Database" field, click "Next".
Note: You can also use Windows Authentication if the SQL server is a local server.
In the "Server" field, type in the hostname of the DiscountASP SQL Server (this is listed in your hosting control panel), choose "Use SQL Server Authentication," type in your DiscountASP database username and password (this was sent in your database order confirmation email), choose your database from the "Database" field, click "Next".
Choose "Copy objects…", click "Next".
Uncheck Use Default Option.
Click Options, uncheck "Copy Database users and database roles", "Copy SQL Server logins", "Copy object-level Permissions".
Leave next window as is, click "Next".
Click "Finish".

It seems to work ok untill it gets to about 90% done then a message says "There has been an error" and gives no more info.
Can anyone help me out

View Replies !   View Related
How To Convert MSSQL Database Into .sql Files?
Hello ,
I'd like to convert the database + sp + tables + data into .sql file?

View Replies !   View Related
MSSQL Database Synchronization With Oracle
Hi all,
Well, I have created an applicatin in and it connect to MSSQL database, and it work fine.

There is another application which was developed in Oracle and the database is oracle 8i.

Well, wat i want is whenever a form is submitted from the
application, the data is inserted in the MSSQL server database and the
Oracle8i database also.

Can anyone help me how to proceed with it.

Thnks in advance for your help.

View Replies !   View Related
Restoring Database MSSQL 2000
Hi All

We restored a database but the user asscociated with that database is not being restored. Is there a way to do this?

Question: Is there a way to restore the complete database including the users.



View Replies !   View Related
Update MSSQL Database From .MDX Files
Hello guys,

Here is the case. I have up and running database on MSSQL server. My client deliver me updates. Since now they were as INSERT statements, but they decided to change some stuff at their side. Now the updates will come as pairs of files (.dbf and .mdx) for each table...

How I can insert them in the running database?

View Replies !   View Related
MSSQL Database Server Expired !
Several months ago I installed what I thought was an unlimited license of MSSQL Database Server 2000. This weekend the database expired. What can I do? I don't want to lose the data. If I attempt to reinstall the software, will that work? We are in the process in purchasing the software but not for a few months. The database is used to store and retrieve data in our OutStart server. Any idea is helpful.

View Replies !   View Related
Paging MSSQL Database Result With PHP..Can Any One Help Me Plz..
hi guys..

i have got stucked into one programming problems which is called paging.i m using mssql as my database.i m using php for displaying data in to several pages but it is not supporting LIMIT functions, so can any one help me how to create php+mssql paging with accurate coding..? plz help me its urgent


View Replies !   View Related
Mssql 6.5 Database As Publisher And Subscriber?

I am running an application on mssql 6.5, sp4.

We are working on using a database as a publisher and a remote database as a subscriber for one replication in Canada.

WE havw just been told that another application on a different server(publisher/ distribution) wants to replication to our database as a subscriber.

We also will need(as a publisher/distribution) to replication to a second subscriber database after we completely test the first replication to Canada.

Therefore my questions are:

1) Can a database on a local database -- our database -- on one server be a publisher and subscriber to ther different databases?

2)has any one been involved with replication on a database used both as a publisher and subscriber to different replications requirements?

What are the pitfalls aside from the scheduling conflicts?

3) In terms of database space requirements, how much disk space extra do we need? What guidelines should we use? For each table as an article, assuming we are doing the full table, do we add 100% more space or what?

4) Any other pitfalls we should be aware of?


David Spaisman

View Replies !   View Related
How Many Users Can Connect To One Database In MSSQL
Dear Sir,
Can you please let me know as to how many users can MSSQL support at one time on a single database say test.

Aman Gupta

View Replies !   View Related
MSSQL Database File Question
Hi.. When I go to my MSSQL 2000 database-->
properties-->Databse size is 1500MG and the space
available is 305MB

But I don't understand how space available come from.
As I had put my Database file and Transaction log file
as unrestricted file grow. And put automatically file
grow by 10% for both file and log

Why is the limit come from ?

Besides, I have a database which indicate space
available as 0M in the database properties but it is
still functioning. why?

View Replies !   View Related
MsSql Server Database Recovery
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.

My costumer HDD some files Deleted mybe elektric prblem -Elektric
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
Recover mdf and ldf files. but I can not not attach mdf. file,

I am recovery .mdf file some table ok.
but my importand table is not ok.

if I can recover another recovery software , my database correct recover or
I am using RecoverMyFiles.

Pleace help me.


View Replies !   View Related
MSSQL 2000: Copying Database

I am using MSSQL 2005 but we have to work in compatibility mode with MSSQL 2000 and also we are only allowed to use 2000-compatible features, now my question:

I need to programmatically copy a database within the same server (including all stored procs, triggers and tables, indices) ...

Can anybody give me a hint what is the best way for reaching this target??

Thanks a lot in advance


View Replies !   View Related
MSSQL - MySql Database Connectivity
A third party development company is creating a third party application for us in PHP and uses a MYSQL database.  The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database.  There are some cases where the two databases require connectivity since a few fields need to relate. We are having issues connecting the two databases on the server and after reading some forums have identified it to be a configuration issue.
I was wondering if anyone could be of any help in solving this issue, or lead us in the right direction (i.e. where to begin, forums, etc.). Here is a description and some questions from our developer:
We are trying to get a PHP application (.php pages running on the webserver which is the same physical machine as the MS SQL server) to connect to the database (MS SQL server). In order to facilitate this, php.ini was configured in the following manner:
mssql.secure_connection = ON
We ensured that IIS/Windows was setup properly too:
System32 and php both contain ntwdblib.dll ver 2000.80.194.0
enable pipe name protocol [Default was disable]
enable TCP/IP IP1 [Default was disable]
MS SQL Server is set to Windows AND SQL server authentication (Mixed mode).
When the PHP application attempts to connect to the database by using:
mssql_connect('localhost', '<userid>', '<password>')
produces this error message:
Login failed for user 'MAILIUSR_<computername>'. (severity 14)
Why doe this occur?  Why is this IUSR userid being used?  the userid we sent in with PHP was a sql userid that we know works (we use it with .NET, and to connect to the database remotely).  Also, why is it using the MAIL domain?  In anycase, shouldn't this IUSR userid work? it's a valid windows account, and mixed mode authentication is allowed.
Any assistance would be greatly appreciated!

View Replies !   View Related
Problems When I Used Big Texts In MSSql Database!

I have Big texts And I Want To searching In These texts By MSSql Database,

i saved this texts in about 4800 rows in one table with one ntext field.

when I finished I surprised with some problems:

1- when I want to search in this table by simple Select Command like this: "Select topicID from topicstbl where topictxt like '%vb forums%'
I faced this ERR MSG "Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding." And It does not continue searching to the last row so it returns only some of the results.

2- it is too slow and it took three minuites to performe one incomplete search operation because it was "TIMEOUT".

3- the size of original texts is 300MB but when i saved these texts to MSSql Database its size becomes too large its more than 1GB.

what can I do with these problems taking into concideration that I do not want to use FULL TEXT SEARCH?

View Replies !   View Related
Need Help With A MySQL To MSSQL Database Migration...
Hello there..... im currently running a mysql database and i want to switch to a mssql database structure... creating the database is not a issue, but inserting values is a problem...

my forum has a lot of data and moving one row at a time is near insanity....

i tried this. ---

Code Snippet

INSERT INTO si_acl_groups ("group_id", "forum_id", "auth_option_id", "auth_role_id", "auth_setting") VALUES
(100, 0, 0, 14, 0),
(96, 0, 15, 0, 1);

but i only get this error. ---

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ','.

any suggestion...

i was able to dump the mysql database into a .sql file but it just gives the same error when i execute...

please help...

View Replies !   View Related
How To Upload / Publich A MSSQL Database
Hi all!
I am a newbie with SQL Server and need some advice. I have developed a small database with Microsoft SQL Server 2005 Express on my local computer. I am using it in conjunction with SQL Server Management Studio Express. Now I want to upload it to an online web host. What is the best way to upload? Do I use replication or some other means? Can I do so with Management Studio Express? My web host has an administration Console which does not seem to work with the database, and their support service is very slow. So I do not know what to do.
Any advice would be helpful.
Thank you

View Replies !   View Related
Insert Data To MsSQL Express Database?
Hello there,I'm to, so please be patient :DMy question is, how do I simply add some data to my database? - With code, not a grid view or something like that..I want to connect to my database, insert some data to a table.It shouldn't be that hard?- Hope someone will take the 5 minutes, and help me :)Regards Jeppe

View Replies !   View Related

Copyright © 2005-08, All rights reserved