I am developing a test solution using Visual Studio and need a sql database. I have sql Management Studio (2008 & 2014) but when I try to create the database I get an error saying I need administrator permissions (or similar). This is a personal laptop with only me as a user and I AM the administrator.How do I create the database?
View 6 RepliesHere is my code
ALTER PROCEDURE Test
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @From varchar(10)
DECLARE @To varchar(10)
DECLARE @DBName varchar
SELECT TOP 1 @From = CONVERT(char,CreateDate,101) FROM CustomerInfo
WHERE TicketNum =
(SELECT TOP 1 TicketNum FROM CustomerInfo
WHERE CreateDate <= DATEADD(mm, -30, CURRENT_TIMESTAMP)
ORDER BY CreateDate DESC)
SELECT @To = CONVERT(char,GETDATE(),101)
SET @DBName = 'Archive_SafeHelp'
CREATE DATABASE @DBName + ' ' + @From + ' ' + @To
END
I am trying to create a database based on the name contained in the variables. I get the error 'Incorrect syntax near '@DBName'. How do i accomplish this?
Thanks
Ganesh
Hi guys, can I know the steps on creating a database snapshot on a mirror database? Thx for the assistance. :)
Best Regards,
Hans
How do you create a SQL database (Sql Express 2005) in real time using VB.Net 2005 ASP.net 2.0?
View 2 Replies View RelatedI am working on site in asp.net with c# and using database sql server 2000 and managing all the data on server i have created one database on server and in that i have created 15 table. should i continue with the same or create another database for table.
tell me how many tables should i maintain in one database. and what precausion should i take while mainting database to increse the speed of site.and what precausion should i take to avoid serverload
please guide me i dont have an idea.
thanks for spending ur valuable time for me.
Sorry, I'm a newbie out there when it comes to creating database. I currently have an ASP.Net project which requires a database. I spent the past few days thinking about how to create a proper database for the application but to no avail. I think tis thread might be out of point for tis forum, but i am really in need of help.
Here goes the storyline of my database:
The project is an online project management system, meant for students to submit their deliverables (reports, eg. Minutes, agenda, project monitor chart) Lecturers will access the web application to grade the student’s submission. The application must allow administrators to add in new subjects. When a new subject is added, the subject leader will set a dateline for a particular module to be submitted. Eg, minutes dateline. Once the dateline is due, the system will inform the lecturers in charge of who/which group did not submit the module. Lecturers and subject leaders can then generate warning letters to be sent via email to the students involved. Lecturers and subject leaders will be able to make announcements through the system as well.
A student can either submit his/her work as an individual or as a group.
A student will be studying more than 1 subject.
A subject will consist of more than 1 module.
Every module will have a dateline for its submission.
Students can make more than 1 submission for each module.
Students belong to different groups/classes for different subjects.
For different modules, there will be different fields to be inserted into the database.
Example, in the “Minutes module�, the student will have to be able to key in the objectives, the date of the meeting, the venue, its members, absent members, actual minutes, action by and meeting end time.
In the “Project monitor chart module�, the student will have to key in the week/date, the name of the member, task involved, as well as the status.
When a new subject is created, the subject leader will have to specify the percentage of each different module. (Eg, Exams – 40%, Term test 15%, and so on.)
A subject will also be taught by more than 1 lecturer. So subject leader will specify the lecturers teaching that particular subject.
I hope someone out there can help me out on the construction of a database for the above storyline. Thanks a lot.
Hi All,
Can anybody help me/does anybody have the code to create a database on ms sql server 2000 using asp.net?
This needs to be done without being asked for the sql server login credentials (i.e the sa username/password can be inserted in the code)
Is there any tools to create a database with tables, views, and all that jazz with a GUI. I went through the exammle on beta.asp.net but the way they created their db was with a script. I want to create everything with a GUI app. If this gui app doesn't exist can someone point me to where I can find more info about creating db, tables etc with sql server 2005 express? Thanks in advance.-Daticus
View 2 Replies View RelatedI have an excel document that Imported to access database. That database should count the number of tickets created by each tech rep; list the area, sub area and description of call created by a the tech rep. Can access perform this task and if yes, any idea I to approach that project or should i use SQL, And if access won't be able to do it. please make a suggestion how to approach this project. it will be nice if i can get the steps.
EXAMPLE
Request Id SRS Started Call Description Area Sub Area Request Status Closed Date Assign To Created By
I created a database using the following command :
create database krish on (Name='krish', filename='C:Program FilesMicrosoft SQL ServerMSSQLdatakrish.mdf', size=25, maxsize=50,filegrowth=5%)
This actually created the database. Now, I wanted to view this database info being stored inside the SQL Server system tables. I looked at "sysdatabases" table and found an entry as expected for "krish" but I could not trace where the info corresponding to the size of the database was stored ie.25MB . (I looked ad "sysdevices" but couldn't find any entry for the newly created database).
In which table is it stored ?
Any help is appreciated.
suppose if we want to create a database and all it relative things to a new server , for that if we restore the backup copy of that databas in a new server will it create the database and restore the data.
Is it enough to restore the backup copy or we need to restore the log also.
I've done a lot of stored procs and modified tables but now I need to create a very basic database from scratch and wonder on how the best way to get started or any good tutorials out there.
I need a db with the following
Content Table
Customer Table
User Table
Hello everybody, my name is Andy,
I need help for creating a database, it's an exercise for my school, we just began to learn SQL, about entities, relationships (one to one, one to many...), creating tables, but the thing is i don't know where to start, i think i need to practise but it's hard to transform a text into a database, i think i need some help from you guys and i hope you will help me.
I give you the exercise, and what i found :
Project wants users to be able to initiate debates, post articles and get to the achieved items. A user should be able to write as many articles as desired after having register with login and passport
However articles should contain these references for more http links, URL, summary of the content; 1 or more books, article, doc, case studies …
1)Identify the data objects and relationship and draft the initial ER Diagram with entities and relationships. Normalize model as far as you can
2)write the SQL query / link (url) and corresponding summary
About the 1)
Entities : users --> login and password associated (one to one relationships one user = one login/password)
Articles --> associated with the users accounts (one to many)
I am not sure for creating the different tables, im a bit lost... :s
About the 2) totally lost, i need the 1) to make the SQL Query (i know a bit about queries)
I hope you will help me, i am a beginner in SQL (only one course taken) and it is our first exercise, thanks for your help all!!!
Hi,
I am developing a Translator for a Mobile Phone and i have to create a database for storing English, Esperanto and French words. What are the SQL statements should i write to create the database and how can i deploy the database in a Mobile Phone/PDA?
Hi,
I have a test database running on the server. Now what I want to do is to create a dev db that has the exact same data model as the test one so that I can test out my application on the dev db and then migrate it to the test db. Can somebody tell me how I can achieve something like that.
Thanks...
OK,
I have downloaded and installed 2005 express. All I want to do now is create a new database. I do not see where to do that. All that was installed was the SQL Server Configuration Manager and the Surface Area configuration. Am I missing something. I guess I am looking for something similar to Enterprise Manager. Where is it?
I'm rusty with database design just yet so trying to improve. This is my way of creating a database in Access but before i swap over to SQL structure i would like a good foundation.
Overall the way i looked at it was you had to have one table that held all your results that users entered and the query took care of the rest??? So for example (Red indicates a Primary Key)
tbl_Products
ProductID
ProductCode
ProductDescription
ProductUnit
ProductQuantity
ProductPrice
tbl_Month
MonthID
Month
tbl_year
YearID
Year
tbl_Department
DepartmentID
DepartmentName
tbl_Employee
EmployeeID
EmployeeFirstname
EmployeeLastname
tbl_Orders
OrderID
OrderProductCode
OrderProductDescription
OrderProductUnit
OrderProductQty
OrderProductPrice
OrderMonth
OrderYear
OrderDepartment
OrderEmployee
I then have the following relationships (1 to Many):
ProductCode (1) - OrderProductCode (Many)
MonthID (1) - OrderMonth (Many)
YearID (1) - OrderYear (Many)
DepartmentID (1) - OrderDepartment (Many)
EmployeeID (1) - OrderEmployee (Many)
Ok your'e probably thinking what if i need to add another Employee or how would i retrieve Employee or month details - to add another Employee the user would have to enter the details on another form which allows them to add another Employee. To select an Employee on the Order Form i would create a combo box which allows the user to pick an Employee.
To create a query to pull product Code, Description, qty, price and Employee name (to see which employee placed the order) i would add the following to a query
ProductCode (From tbl_Products)
OrderProductDescription (From tbl_Orders)
OrderProductQty (From tbl_Orders)
OrderProductPrice (From tbl_Orders)
EmployeeFirstname (From tbl_Employee)
EmployeeLastname (From tbl_Employee)
This is the way i thought you should create a database but i'm a developer therefore only work with databases when the query is created by a db admin. Guess i have something wrong here?? if so how would you go about creating this type of database? Overall purpose of the database is usually a user entering data and retrieving data every so often.
Thanks in advance.
Hi. Im brand new to using SQL. I downloaded the SQL Server 2005 Trial Edition (Enterprise Evaluation Edition) and installed it. How do i create a database ? The only thing i can seem to open is the SQL Server Configuration Manager which just lets me start the Server. Did I install it wrong or open the wrong program? If someone could help I would greatly appreciate it.
View 10 Replies View RelatedI have been using microsoft office access to create database and connect to application built. This is the first time trying to create database using the sql server. How do i create a database using this?
Do i use the sql server management to create it?
Is there any step by step tutorials?
How do i connect the database to the web developer?
I've seen several post asking for that possibility, but all 've read, didn't help me.Some sing SQLDMO, other suggest to use SQLSMO, others only explaining to connect to a server and then do "CREATE DATABASE".I will do this within .Net. Connecting to a SQL Server 2005 and execute "CREATE DATABASE" I could realize.But how doing this with SQLExpress? Trying to do SqlConnection.Open with a non existing DB does not work., says "file not exists".Or do I only have the wrong connection string? Can someone post here an excample connection string, which works with a non existing database?Some hints I've read make me considering to use SQLSMO. But I don't have it on my computer. Where do I get it from? Any links would be nice.
View 6 Replies View RelatedI've tried copying the tutorials and this is the result:
test6 below is accepted:
CREATE TABLE test6(id smallint,first_name nvarchar(50) NOT NULL,last_name nvarchar(50) NOT NULL,movie nvarchar(50) NOT NULL,PRIMARY KEY(id));
test7 below is rejected:
CREATE TABLE test7(id smallint auto_increment,first_name nvarchar(50) NOT NULL,last_name nvarchar(50) NOT NULL,movie nvarchar(50) NOT NULL,PRIMARY KEY(id));
My provider is GoDaddy, the error message is -2147217900, with "Line 2: Incorrect syntax near 'auto_increment'.
I've made a form and now all I want to do is save everything in the form into a new database file but I don't know how. I'm using Visual Web Developer 2005. Somehow I'm guessing that I have to set something somewhere so when the submit button is hit, it knows to save it to a database file which doesn't exist yet so it would have to create it. It should be easy but I can't figure it out.
View 1 Replies View RelatedHi,
I have my MSSQL database developed in Visual Web Developer 2005 Express Edition. I am trying to create a backup file of this databse (.bak). Is SQL Server 2005 Studio Express the program that will let me do this?
Also in SQL Server, how can I attach to my database that I have made in Web Developer 2005? if I go to attach it doesn't list anything.
Thanks for any help.
Hi i want to create a test environment for a system, therefore i need an exact replica of the database that is currently standing, how can i go about doing this, i am using SQL enterprise manager 2000, thank you.
View 2 Replies View RelatedHi genius minds,
Suppose I have database backup file.
Can I create a new database(different than the database whose backup it is) and restore the backup into newly created database.
I'm having a backup file of some database, I want to create database from it. Suggest any way to do it?
Thx
Hi,
I need to create a table and a few fields in the SQL database programmatically in asp.net.
I know the tabes name, the server which it resides on, username/password. Would anyone have a small sample of this code?
Thanks
rad
im creating a ecommerce website, and i need to create a database, im using visual studio .net
and when i try to create a new database using VS.net i choose "use sql server authentication" and no matter what i type in for the login id, i get the following ado error
"ADO Error : ' Login failed for user "blank". Reason. Not associated with a trusted SQL server connection.'
thanks in advance.
Hi,
for my website im going to be selling rims, and i need to have available a search by vehicle
SKU: 8438743
CAT: RIM
BRAND: ADVAN
MODEL: KREUZER_SERIES_V
DIAMETER: 17
WIDTH: 8
OFFSET: 45
LUGS: 5
LUG SPACING: 114.3
FINISH: GMETAL
that would be the determing factors of the results, heres what would define for example a
2002 Accord V6
LUGS = 5
LUG SPACING = 114.3
55 > OFFSET > 40
DIAMETER < 20
WIDTH < 9
so for the accord
the required attributes are a 5X114.3 lug pattern
the offset needs to be 40-55
max diameter is 19"
max width = 8"
My question is this, how many databases do i need to make? and what catagories do I use in each database? Also is it possible to do less than, greater than, etc, in databases? I think thats everything, thanks!
Hi I have two SQL server 2000 machine in my corporateHow to create a SQL View if the database table is located on another SQL server?Example :I am currently working at SQL Server "S01", but need to create a sql view to table customer on "Marketing" database located on SQL Server "S02"if the table is reside on the same machine then it's simple for me, but this customer table is not located on "S01" but located on different machine "S02"how to do this? any tutorial?thanks a lotYonscun
View 2 Replies View RelatedHi,
I am using SQL Server 7.0..When I go to the Enterprise Manager and try to Create a New database, the Datafile defaults to C:MSSQL7 and the Transaction Log Defaults to C:MSSQL7 folders...
Is there some setting on the Server itself so that the defaults are different..Like D:Data etc....
I know I can type in the correct folder but my main question is that is there some setting in Enterprise Manager or some System Table so that a new database and its Transaction Log is created on a different default drive..
Thankx
KP
Hi,
Is there a SQL call or some other way "scripted" way to create a database in SQL 7.0? We have an application that runs on a client's local database and we want them to be able to run a package that creates the database (as opposed to an administrator logging onto their database and doing it manually through the wizard). There are commands to detach and attach databases(i.e. move them) but not to create them.
Thanks in advance...
Ryan
Hi,
1- I have given a dbo permission on a database named F12345-1, now I want to create a job on that server using this database.
2- I tried to create the first step in the new job but I don’t see my database name on the databases drop down menu (I only see the system databases)
3- I tried being under Master and using the USE sql command (Ex: Use F12345-1) at the beginning of my step but I get a message saying that the database F12345 doesn’t exist (The message doesn’t say the whole database name only the part before the hyphen)
4- I tried putting quotes around the database name with no luck, although that worked in SQL Query Analyzer but the Job didn’t like it.
Can you please help with this, knowing that I have no control on the database name (In order to remove the hyphen from the name which I am assuming is the cause of this problem)
Thanks
Instead of me testing my scripts on my main commerce database I was wondering if there was an easy way to duplicate my most currnet database as another database...
that way if I screw up I can just delete it and try again
I looked at the restore as in enterpirse manager, but I don't think thats it