I want my application to create a new database/tables when run for the
first time. I have created a stored procedure to create the new
database named "budget". When I run the stored procedure, it creates
the budget database but the tables are created in the "master"
database. Please help. 6 13018
Before the CREATE TABLE statements you should put this:
USE Budget
go
"Shiller" <sh******@gmail.comha scritto nel messaggio
news:11**********************@8g2000cwh.googlegrou ps.com...
I want my application to create a new database/tables when run for the
first time. I have created a stored procedure to create the new
database named "budget". When I run the stored procedure, it creates
the budget database but the tables are created in the "master"
database. Please help.
On Feb 28, 10:44 am, "Massimo-Mastino" <mast...@hotmail.itwrote:
Before the CREATE TABLE statements you should put this:
USE Budget
go
"Shiller" <shill...@gmail.comha scritto nel messaggionews:11**********************@8g2000cwh.g ooglegroups.com...
I want my application to create a new database/tables when run for the
first time. I have created a stored procedure to create the new
database named "budget". When I run the stored procedure, it creates
the budget database but the tables are created in the "master"
database. Please help.- Hide quoted text -
- Show quoted text -
I tried using the USE statement, but it's not allowed in stored
procedure: "a USE database statement is not allowed in a procedure,
function or trigger."
"Shiller" <sh******@gmail.comwrote in message
news:11*********************@k78g2000cwa.googlegro ups.com...
On Feb 28, 10:44 am, "Massimo-Mastino" <mast...@hotmail.itwrote:
>Before the CREATE TABLE statements you should put this:
USE Budget go
"Shiller" <shill...@gmail.comha scritto nel messaggionews:11**********************@8g2000cwh. googlegroups.com...
I want my application to create a new database/tables when run for the
first time. I have created a stored procedure to create the new
database named "budget". When I run the stored procedure, it creates
the budget database but the tables are created in the "master"
database. Please help.- Hide quoted text -
- Show quoted text -
I tried using the USE statement, but it's not allowed in stored
procedure: "a USE database statement is not allowed in a procedure,
function or trigger."
Correct, USE is not really transact-SQL it's a control statement for query
analyzer, etc.
Off hand I'm not sure of a solution to your problem, but google may. I seem
to recall others having similar problems.
Generally though what you want to do is done by a series of scripts, not a
single stored proc.
Shiller,
Use a three part qualifier in your create table statement:
create table MyDB.dbo.MyTable ...
-- Bill
"Greg D. Moore (Strider)" <mo****************@greenms.comwrote in message
news:K_*****************@newsread1.news.pas.earthl ink.net...
"Shiller" <sh******@gmail.comwrote in message
news:11*********************@k78g2000cwa.googlegro ups.com...
>On Feb 28, 10:44 am, "Massimo-Mastino" <mast...@hotmail.itwrote:
>>Before the CREATE TABLE statements you should put this:
USE Budget go
"Shiller" <shill...@gmail.comha scritto nel messaggionews:11**********************@8g2000cwh .googlegroups.com... I want my application to create a new database/tables when run for the first time. I have created a stored procedure to create the new database named "budget". When I run the stored procedure, it creates the budget database but the tables are created in the "master" database. Please help.- Hide quoted text -
- Show quoted text -
I tried using the USE statement, but it's not allowed in stored procedure: "a USE database statement is not allowed in a procedure, function or trigger."
Correct, USE is not really transact-SQL it's a control statement for query
analyzer, etc.
Off hand I'm not sure of a solution to your problem, but google may. I
seem to recall others having similar problems.
Generally though what you want to do is done by a series of scripts, not a
single stored proc.
On Feb 28, 12:10 pm, "AlterEgo" <altereg...@dslextreme.comwrote:
Shiller,
Use a three part qualifier in your create table statement:
create table MyDB.dbo.MyTable ...
-- Bill
"Greg D. Moore (Strider)" <mooregr_deletet...@greenms.comwrote in messagenews:K_*****************@newsread1.news.pas .earthlink.net...
"Shiller" <shill...@gmail.comwrote in message
news:11*********************@k78g2000cwa.googlegro ups.com...
On Feb 28, 10:44 am, "Massimo-Mastino" <mast...@hotmail.itwrote: Before the CREATE TABLE statements you should put this:
>USE Budget go
>"Shiller" <shill...@gmail.comha scritto nel messaggionews:11**********************@8g2000cwh. googlegroups.com...
I want my application to create a new database/tables when run for the
first time. I have created a stored procedure to create the new
database named "budget". When I run the stored procedure, it creates
the budget database but the tables are created in the "master"
database. Please help.- Hide quoted text -
>- Show quoted text -
I tried using the USE statement, but it's not allowed in stored
procedure: "a USE database statement is not allowed in a procedure,
function or trigger."
Correct, USE is not really transact-SQL it's a control statement for query
analyzer, etc.
Off hand I'm not sure of a solution to your problem, but google may. I
seem to recall others having similar problems.
Generally though what you want to do is done by a series of scripts, not a
single stored proc.- Hide quoted text -
- Show quoted text -
Thank you so much Bill, your technique works.
Shiller (sh******@gmail.com) writes:
I want my application to create a new database/tables when run for the
first time. I have created a stored procedure to create the new
database named "budget". When I run the stored procedure, it creates
the budget database but the tables are created in the "master"
database. Please help.
This is a case where it's better to run statements from the client. After
all, somehow that stored procedure needs to be written somewhere, and I
don't think it's a good idea to write it to the master database.
Alternatively, you can put it a file that you run from OSQL or SQLCMD.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Robin Tucker |
last post by:
Is it possible to execute a stored procedure in one database, which then
itself executes a stored procedure from another database? We have decide to
split our data into a tree structure (DB1) and...
|
by: marc |
last post by:
I've been developing a stored procedure that uses a user defined
function in the query portion of the procedure. However, since the end
product needs to allow for dynamic table names, the UDF will...
|
by: Thanos |
last post by:
Hello, Im a novice at this so bare with me.
I have two tables which will be match merged based on 10 conditions
(select statements). For example, if a record exists in table A but
not in Table...
|
by: Eli |
last post by:
Hi all
We currently have a strange problem with calling a Stored Procedure
(SQL Database) in our C# Project. The only error I get is "System
error" which says a lot :)
Background:
We have...
|
by: Joe Campbell |
last post by:
I have a DBA that wrote a stored procedure that does a SELECT from a
particluar SQL Server table. Within that stored procedure he links over to
grab a column from another database table. I need to...
|
by: masoumeh |
last post by:
please help me
I use this code
TA_Insert_Language as new DataSetName.Insert_LanguageTableAdapter
DT_Insert_Language as new DataSetName.Insert_LanguageDataTable
dim MaxRow as new DataRow
dim...
|
by: comp_databases_ms-sqlserver |
last post by:
This post is related to SQL server 2000 and SQL Server 2005 all
editions.
Many of my stored procedures create temporary tables in the code. I
want to find a way to find the query plan for these...
|
by: fniles |
last post by:
I am using VB.NET 2003 and SQL2000 database.
I have a stored procedure called "INSERT_INTO_MYTABLE" that accepts 1
parameter (varchar(10)) and returns the identity column value from that
table....
|
by: Phil Barber |
last post by:
I have a stored procedure that contains several temp tables, I am attempting
to assign a tableadapter to the Sp. when it goes to create the persistent
fields (in the wizard) I get Select command...
|
by: ajay kumar chada |
last post by:
Can anybody help me in finding error in the following SP please,
(actullay i need to drop the tables which had been created six months ago
CREATE PROCEDURE TGNSX00.TAB_DROP_PROC(OUT OUT_SQLCODE...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |