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 «««23456»»»

Create Database Expand / Collapse
Author
Message
Posted Monday, May 11, 2009 2:08 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
It would get created. Wouldn't we see most of the times, when database is created by an application had .dat as file extension? I still didn't figured why most applications create database with .dat extension.

Does anyone know about it?



SQL DBA.
Post #714474
Posted Monday, May 11, 2009 2:24 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:26 AM
Points: 31,078, Visits: 15,520
I think some products use .dat as an extension. Someone may just use that as a default, which is a bad idea.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #714493
Posted Tuesday, May 12, 2009 10:06 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 20,696, Visits: 32,330
I think all the complaints are out of line. I answered the question correctly, and I didn't even try to run the code.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #715256
Posted Tuesday, May 12, 2009 11:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 5:19 PM
Points: 1,519, Visits: 2,211
Lynn Pettis (5/12/2009)
I think all the complaints are out of line. I answered the question correctly, and I didn't even try to run the code.


There should be a new rule. From now on whenever someone whines about a question they should lose an additional point.


Jason Shadonix
MCTS, SQL 2005
Post #715323
Posted Tuesday, May 12, 2009 9:09 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 26, 2014 3:09 PM
Points: 2,391, Visits: 17,939
Jason Shadonix (5/12/2009)
Lynn Pettis (5/12/2009)
I think all the complaints are out of line. I answered the question correctly, and I didn't even try to run the code.


There should be a new rule. From now on whenever someone whines about a question they should lose an additional point.


Or write one of their own. I've missed my fair share for one reason or another, but I've also written a QOD - it was a lot of work, much more than it looks like on the surface.
Post #715606
Posted Wednesday, May 13, 2009 1:52 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:34 AM
Points: 1,614, Visits: 898
Mine wasn't a complaint - merely an observation.

Sometimes these can actually spark off a really interesting discussion.

I don't, however, have much patience once the same observation has been made over and over again!

Everybody should read the entire discussion before they decide to post to it.
Post #715712
Posted Wednesday, May 13, 2009 5:55 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, August 23, 2014 6:03 AM
Points: 351, Visits: 1,556
Hi,

This of course does not work, unless the folder structures are in place on the system in question. Otherwise errors of the form below are returned.



Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\mssql\MYTEST.doc" failed with the operating system error 2(The system cannot find the file specified.).
Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.



John Sansom (@sqlBrit) | www.johnsansom.com
Post #715842
Posted Wednesday, May 13, 2009 5:57 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:04 AM
Points: 1,760, Visits: 6,375
Rachel Byford (5/13/2009)
I don't, however, have much patience once the same observation has been made over and over again!

Everybody should read the entire discussion before they decide to post to it.


Post #715845
Posted Wednesday, May 13, 2009 8:24 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 20,696, Visits: 32,330
John Sansom (5/13/2009)
Hi,

This of course does not work, unless the folder structures are in place on the system in question. Otherwise errors of the form below are returned.



Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\mssql\MYTEST.doc" failed with the operating system error 2(The system cannot find the file specified.).
Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.


Yep, as several others have already mentioned. If you take a few minutes to read CREATE DATABASE in BOL you'd see that it is required that the directory structure already be in place, therefore for this question it must be assumed that requirement was already met. Based on that, the statement works.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #716037
Posted Wednesday, May 13, 2009 8:38 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:26 AM
Points: 31,078, Visits: 15,520
No points off for whining. I make plenty of mistakes.

However, if you complain, I would like to see you write a question, or even explain how you think this question should be worded.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #716059
« Prev Topic | Next Topic »

Add to briefcase «««23456»»»

Permissions Expand / Collapse