Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Create Database Expand / Collapse
Author
Message
Posted Saturday, May 9, 2009 11:31 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Comments posted to this topic are about the item Create Database



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #713585
Posted Monday, May 11, 2009 1:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 4:37 AM
Points: 1,275, Visits: 932
It does not create a database. The problem is not the .MP3 extension, but syntax.
I get Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'name'.

Post #713876
Posted Monday, May 11, 2009 1:14 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:08 AM
Points: 2,365, Visits: 1,846
.mp3 - music database

"Keep Trying"
Post #713883
Posted Monday, May 11, 2009 1:15 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:12 AM
Points: 2,587, Visits: 2,444
c:\ and C:\mssql\ should exists and sql account should have permissions to write.
Post #713885
Posted Monday, May 11, 2009 2:31 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 27, 2014 9:13 AM
Points: 1,614, Visits: 905
Server: Msg 5105, Level 16, State 2, Line 1
Device activation error. The physical file name 'C:\mssql\MYTEST.doc' may be incorrect.
Server: Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.

You never specified that C:\mssql should exist.
Post #713919
Posted Monday, May 11, 2009 2:36 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:26 AM
Points: 1,802, Visits: 6,571
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\mssql\MYTEST.doc" failed with the operating system error 2(error not found).
Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

So the answer for me is No.
Post #713923
Posted Monday, May 11, 2009 2:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 25, 2014 12:38 PM
Points: 1,385, Visits: 1,249
So, a few problems here:
- "C:\mssql" is not a default install folder, and most people would probably not have their SQL server instance or files installed there;
- If you can successfully create a database file in "C:\", then your permissions are probably not set up securely. (?)

The intent (to demonstrate that file extensions don't matter) is good, but the question deserves some rework.

---

Edited (again): The syntax issue had nothing to do with SQL Server versions, it was a copy->paste issue from the email


http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
Post #713927
Posted Monday, May 11, 2009 4:08 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Sunday, December 26, 2010 1:11 AM
Points: 661, Visits: 65
NO for me too
Post #713954
Posted Monday, May 11, 2009 4:49 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 4, 2012 4:26 AM
Points: 527, Visits: 86
Not for me:

CREATE DATABASE failed. Some file names listed could not be created. Check related errors

Post #713971
Posted Monday, May 11, 2009 5:13 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 4:29 AM
Points: 99, Visits: 34
It will only create the database if the mssql directory exists.

Directory lookup for the file "C:\mssql\MYTEST.doc" failed

Regards
Tjaart
Post #713981
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse