SQL Server tables in wrong database Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) The Ask Question Wizard is Live! Data science time! April 2019 and salary with experience Should we burninate the [wrap] tag?Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerInsert results of a stored procedure into a temporary tableHow to connect to SQL Server database from JavaScript in the browser?What is the best way to auto-generate INSERT statements for a SQL Server table?SQL Server: How to Join to first rowHow do I UPDATE from a SELECT in SQL Server?Reset identity seed after deleting records in SQL Server
Is above average number of years spent on PhD considered a red flag in future academia or industry positions?
Output the ŋarâþ crîþ alphabet song without using (m)any letters
Why did the IBM 650 use bi-quinary?
How discoverable are IPv6 addresses and AAAA names by potential attackers?
What is the longest distance a 13th-level monk can jump while attacking on the same turn?
How to assign captions for two tables in LaTeX?
Doubts about chords
What makes black pepper strong or mild?
Should gear shift center itself while in neutral?
Single word antonym of "flightless"
Is there a concise way to say "all of the X, one of each"?
Check which numbers satisfy the condition [A*B*C = A! + B! + C!]
Is there a Spanish version of "dot your i's and cross your t's" that includes the letter 'ñ'?
What are the motives behind Cersei's orders given to Bronn?
Why was the term "discrete" used in discrete logarithm?
What are 'alternative tunings' of a guitar and why would you use them? Doesn't it make it more difficult to play?
What is the musical term for a note that continously plays through a melody?
Do I really need recursive chmod to restrict access to a folder?
Models of set theory where not every set can be linearly ordered
If 'B is more likely given A', then 'A is more likely given B'
How widely used is the term Treppenwitz? Is it something that most Germans know?
I am not a queen, who am I?
What LEGO pieces have "real-world" functionality?
Why does Python start at index 1 when iterating an array backwards?
SQL Server tables in wrong database
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
The Ask Question Wizard is Live!
Data science time! April 2019 and salary with experience
Should we burninate the [wrap] tag?Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerInsert results of a stored procedure into a temporary tableHow to connect to SQL Server database from JavaScript in the browser?What is the best way to auto-generate INSERT statements for a SQL Server table?SQL Server: How to Join to first rowHow do I UPDATE from a SELECT in SQL Server?Reset identity seed after deleting records in SQL Server
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I am new to SQL Server and have a strange problem, I have created a database named zed and a user zed which is mapped to the zed database but when I try to create the tables from a script :
sqlcmd -S DESKTOP-TEDE7TPSQLEXPRESS -U zed -P zedfinancials -i ../tables/static_tables.sql
The tables are created in the master database.
sql-server edited Mar 22 at 8:38
Fourat
1,27212343
asked Mar 22 at 8:20
david-zeddavid-zed
63
add a comment |
I am new to SQL Server and have a strange problem, I have created a database named zed and a user zed which is mapped to the zed database but when I try to create the tables from a script :
sqlcmd -S DESKTOP-TEDE7TPSQLEXPRESS -U zed -P zedfinancials -i ../tables/static_tables.sql
The tables are created in the master database.
sql-server edited Mar 22 at 8:38
Fourat
1,27212343
asked Mar 22 at 8:20
david-zeddavid-zed
63
You didn't specify the database in the command line or the script so the default database for that user is used
– Panagiotis Kanavos
Mar 22 at 8:25
add a comment |
I am new to SQL Server and have a strange problem, I have created a database named zed and a user zed which is mapped to the zed database but when I try to create the tables from a script :
sqlcmd -S DESKTOP-TEDE7TPSQLEXPRESS -U zed -P zedfinancials -i ../tables/static_tables.sql
The tables are created in the master database.
sql-server edited Mar 22 at 8:38
Fourat
1,27212343
asked Mar 22 at 8:20
david-zeddavid-zed
63
I am new to SQL Server and have a strange problem, I have created a database named zed and a user zed which is mapped to the zed database but when I try to create the tables from a script :
sqlcmd -S DESKTOP-TEDE7TPSQLEXPRESS -U zed -P zedfinancials -i ../tables/static_tables.sql
The tables are created in the master database.
sql-server sql-server edited Mar 22 at 8:38
Fourat
1,27212343
asked Mar 22 at 8:20
david-zeddavid-zed
63
edited Mar 22 at 8:38
Fourat
1,27212343
asked Mar 22 at 8:20
david-zeddavid-zed
63
edited Mar 22 at 8:38
Fourat
1,27212343
edited Mar 22 at 8:38
Fourat
1,27212343
edited Mar 22 at 8:38
Fourat
1,27212343
1,27212343
asked Mar 22 at 8:20
david-zeddavid-zed
63
asked Mar 22 at 8:20
david-zeddavid-zed
63
asked Mar 22 at 8:20
david-zeddavid-zed
63
63
You didn't specify the database in the command line or the script so the default database for that user is used
– Panagiotis Kanavos
Mar 22 at 8:25
add a comment |
You didn't specify the database in the command line or the script so the default database for that user is used
– Panagiotis Kanavos
Mar 22 at 8:25
You didn't specify the database in the command line or the script so the default database for that user is used
– Panagiotis Kanavos
Mar 22 at 8:25
You didn't specify the database in the command line or the script so the default database for that user is used
– Panagiotis Kanavos
Mar 22 at 8:25
add a comment |
2 Answers
2
active
oldest
votes
You are missing the -d flag to set the database :
sqlcmd -S DESKTOP-TEDE7TPSQLEXPRESS -U zed -P zedfinancials -d zed -i ../tables/static_tables.sql
Read more about sqlcmd : https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017
answered Mar 22 at 8:24
FouratFourat
1,27212343
add a comment |
Try these 2 lines in the beginning of your script file (static_tables.sql):
USE [Zed]
GO
This will force the script to use the database specified.
answered Mar 22 at 8:26
MortenMorten
3381414
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55295497%2fsql-server-tables-in-wrong-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You are missing the -d flag to set the database :
sqlcmd -S DESKTOP-TEDE7TPSQLEXPRESS -U zed -P zedfinancials -d zed -i ../tables/static_tables.sql
Read more about sqlcmd : https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017
answered Mar 22 at 8:24
FouratFourat
1,27212343
add a comment |
You are missing the -d flag to set the database :
sqlcmd -S DESKTOP-TEDE7TPSQLEXPRESS -U zed -P zedfinancials -d zed -i ../tables/static_tables.sql
Read more about sqlcmd : https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017
answered Mar 22 at 8:24
FouratFourat
1,27212343
add a comment |
You are missing the -d flag to set the database :
sqlcmd -S DESKTOP-TEDE7TPSQLEXPRESS -U zed -P zedfinancials -d zed -i ../tables/static_tables.sql
Read more about sqlcmd : https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017
answered Mar 22 at 8:24
FouratFourat
1,27212343
You are missing the -d flag to set the database :
sqlcmd -S DESKTOP-TEDE7TPSQLEXPRESS -U zed -P zedfinancials -d zed -i ../tables/static_tables.sql
Read more about sqlcmd : https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017
answered Mar 22 at 8:24
FouratFourat
1,27212343
answered Mar 22 at 8:24
FouratFourat
1,27212343
answered Mar 22 at 8:24
FouratFourat
1,27212343
answered Mar 22 at 8:24
FouratFourat
1,27212343
1,27212343
add a comment |
add a comment |
Try these 2 lines in the beginning of your script file (static_tables.sql):
USE [Zed]
GO
This will force the script to use the database specified.
answered Mar 22 at 8:26
MortenMorten
3381414
add a comment |
Try these 2 lines in the beginning of your script file (static_tables.sql):
USE [Zed]
GO
This will force the script to use the database specified.
answered Mar 22 at 8:26
MortenMorten
3381414
add a comment |
Try these 2 lines in the beginning of your script file (static_tables.sql):
USE [Zed]
GO
This will force the script to use the database specified.
answered Mar 22 at 8:26
MortenMorten
3381414
Try these 2 lines in the beginning of your script file (static_tables.sql):
USE [Zed]
GO
This will force the script to use the database specified.
answered Mar 22 at 8:26
MortenMorten
3381414
answered Mar 22 at 8:26
MortenMorten
3381414
answered Mar 22 at 8:26
MortenMorten
3381414
answered Mar 22 at 8:26
MortenMorten
3381414
3381414
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55295497%2fsql-server-tables-in-wrong-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You didn't specify the database in the command line or the script so the default database for that user is used
– Panagiotis Kanavos
Mar 22 at 8:25