Showing posts with label names. Show all posts
Showing posts with label names. Show all posts

Monday, March 19, 2012

How many databases can i have in sql server 2000?

Hi, my name's Carlos and i have a question...
I need to know if there is a limit in the number of databases that i an have
in sql server 2000 and if there is a difference in sql server 2005.
Thanks.
Carlos,
See:
2000
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
2005
Same I believe.
HTH
Jerry
"Carlos Lpez." <CarlosLpez@.discussions.microsoft.com> wrote in message
news:E789E737-642C-4E63-B65F-03BF02806662@.microsoft.com...
> Hi, my name's Carlos and i have a question...
> I need to know if there is a limit in the number of databases that i an
> have
> in sql server 2000 and if there is a difference in sql server 2005.
> Thanks.
|||32767 DB's per instance
http://sqlservercode.blogspot.com/
"Carlos López." wrote:

> Hi, my name's Carlos and i have a question...
> I need to know if there is a limit in the number of databases that i an have
> in sql server 2000 and if there is a difference in sql server 2005.
> Thanks.
|||Hi,
SQL 2000 :- 32767 Databases per SQL Server Instance.
SQL 2005:- 32767 databases per instance.
Thanks
Hari
SQL Server MVP
"Carlos Lpez." <CarlosLpez@.discussions.microsoft.com> wrote in message
news:E789E737-642C-4E63-B65F-03BF02806662@.microsoft.com...
> Hi, my name's Carlos and i have a question...
> I need to know if there is a limit in the number of databases that i an
> have
> in sql server 2000 and if there is a difference in sql server 2005.
> Thanks.
|||Thaks a lot.
Your help was very fast & exactly.
Thnks.
"Hari Prasad" wrote:

> Hi,
> SQL 2000 :- 32767 Databases per SQL Server Instance.
> SQL 2005:- 32767 databases per instance.
> Thanks
> Hari
> SQL Server MVP
> "Carlos López." <CarlosLpez@.discussions.microsoft.com> wrote in message
> news:E789E737-642C-4E63-B65F-03BF02806662@.microsoft.com...
>
>
|||Thaks a lot.
Your help was very fast & exactly.
:-)
"Jerry Spivey" wrote:

> Carlos,
> See:
> 2000
> http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
> 2005
> Same I believe.
> HTH
> Jerry
> "Carlos López." <CarlosLpez@.discussions.microsoft.com> wrote in message
> news:E789E737-642C-4E63-B65F-03BF02806662@.microsoft.com...
>
>
|||Thaks a lot.
Your help was very fast. :-)
"SQL" wrote:
[vbcol=seagreen]
> 32767 DB's per instance
> http://sqlservercode.blogspot.com/
>
> "Carlos López." wrote:

Sunday, February 19, 2012

how get data and log file names for each database

Using SS2000. I'm trying to list the data and log files for each database. I found the data filename in sysdatabases but where is the log filename?
Thanks,
Dan D.
how about this?
SELECT * FROM sysfiles
Keith
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:033064C1-068D-4124-8105-0621EDA42B5C@.microsoft.com...
> Using SS2000. I'm trying to list the data and log files for each database.
I found the data filename in sysdatabases but where is the log filename?
> Thanks,
> --
> Dan D.
|||I was hoping for something that I could use and not have to go to each database. But I can write a script to loop through all of the databases.
Thanks,
Dan D.
"Keith Kratochvil" wrote:

> how about this?
> SELECT * FROM sysfiles
> --
> Keith
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:033064C1-068D-4124-8105-0621EDA42B5C@.microsoft.com...
> I found the data filename in sysdatabases but where is the log filename?
>
|||How about select * from sysaltfiles
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> I was hoping for something that I could use and not have to go to each
database. But I can write a script to loop through all of the databases.[vbcol=seagreen]
> Thanks,
> --
> Dan D.
>
> "Keith Kratochvil" wrote:
database.[vbcol=seagreen]
|||Easy enough:
EXEC sp_Msforeachdb
'USE ?;
SELECT * FROM sysfiles;'
Keith
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> I was hoping for something that I could use and not have to go to each
database. But I can write a script to loop through all of the databases.[vbcol=seagreen]
> Thanks,
> --
> Dan D.
>
> "Keith Kratochvil" wrote:
database.[vbcol=seagreen]
|||That works. Didn't know about that table. Thanks.
Dan D.
"Jasper Smith" wrote:

> How about select * from sysaltfiles
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> database. But I can write a script to loop through all of the databases.
> database.
>
>
|||That's good. I've never used that sp before. Thanks.
Dan D.
"Keith Kratochvil" wrote:

> Easy enough:
>
> EXEC sp_Msforeachdb
> 'USE ?;
> SELECT * FROM sysfiles;'
> --
> Keith
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> database. But I can write a script to loop through all of the databases.
> database.
>
|||Good suggestion! I forgot about that table. The beauty of this method: one
set of results.
Keith
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eQNg$VpaEHA.3664@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> How about select * from sysaltfiles
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> database. But I can write a script to loop through all of the databases.
> database.
filename?
>

how get data and log file names for each database

Using SS2000. I'm trying to list the data and log files for each database. I
found the data filename in sysdatabases but where is the log filename?
Thanks,
--
Dan D.Easy enough:
EXEC sp_Msforeachdb
'USE ?;
SELECT * FROM sysfiles;'
Keith
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> I was hoping for something that I could use and not have to go to each
database. But I can write a script to loop through all of the databases.[vbcol=seagreen]
> Thanks,
> --
> Dan D.
>
> "Keith Kratochvil" wrote:
>
database.[vbcol=seagreen]|||That works. Didn't know about that table. Thanks.
--
Dan D.
"Jasper Smith" wrote:

> How about select * from sysaltfiles
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> database. But I can write a script to loop through all of the databases.
> database.
>
>|||That's good. I've never used that sp before. Thanks.
--
Dan D.
"Keith Kratochvil" wrote:

> Easy enough:
>
> EXEC sp_Msforeachdb
> 'USE ?;
> SELECT * FROM sysfiles;'
> --
> Keith
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> database. But I can write a script to loop through all of the databases.
> database.
>|||Good suggestion! I forgot about that table. The beauty of this method: one
set of results.
Keith
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eQNg$VpaEHA.3664@.TK2MSFTNGP12.phx.gbl...
> How about select * from sysaltfiles
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> database. But I can write a script to loop through all of the databases.
> database.
filename?[vbcol=seagreen]
>|||how about this?
SELECT * FROM sysfiles
Keith
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:033064C1-068D-4124-8105-0621EDA42B5C@.microsoft.com...
> Using SS2000. I'm trying to list the data and log files for each database.
I found the data filename in sysdatabases but where is the log filename?
> Thanks,
> --
> Dan D.|||I was hoping for something that I could use and not have to go to each datab
ase. But I can write a script to loop through all of the databases.
Thanks,
--
Dan D.
"Keith Kratochvil" wrote:

> how about this?
> SELECT * FROM sysfiles
> --
> Keith
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:033064C1-068D-4124-8105-0621EDA42B5C@.microsoft.com...
> I found the data filename in sysdatabases but where is the log filename?
>|||How about select * from sysaltfiles
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> I was hoping for something that I could use and not have to go to each
database. But I can write a script to loop through all of the databases.[vbcol=seagreen]
> Thanks,
> --
> Dan D.
>
> "Keith Kratochvil" wrote:
>
database.[vbcol=seagreen]

How get column headers in QA CSV export

Using Query Analyzer and SS 2000, if I export a query result set of a
SELECT to a CSV file is there any way to get the column names included as
the first line of the file?
Bill Todd
Bill Todd wrote:
> Using Query Analyzer and SS 2000, if I export a query result set of a
> SELECT to a CSV file is there any way to get the column names
> included as the first line of the file?
You can use the DTS import/export wizard for that.
David Gugick
Imceda Software
www.imceda.com
|||The only thing I have been able to get the DTS wizard to do is display the
error message "the value for a required parameter is missing" which is
really helpful. Is there any documentation for the beginner for DTS?
Bill Todd
David Gugick wrote:

> Bill Todd wrote:
> You can use the DTS import/export wizard for that.
|||Bill Todd wrote:[vbcol=seagreen]
> The only thing I have been able to get the DTS wizard to do is
> display the error message "the value for a required parameter is
> missing" which is really helpful. Is there any documentation for the
> beginner for DTS?
I'm not sure what problem you are having. The wizard is pretty simple to
use:
1- Select a server and a database
2- Select Text File as the destination and enter a text file name for
the output (CSV entension)
3 - Click Use a query to specify data to transfer
4 - Enter query, such as: Select * from sysobjects (or use query
builder)
5 - Click Delimited, Column Delimiter = TAB, and First Row Has Column
Names
6- Click Run Immediately (and possibly save DTS package for future use)
The file should be created in CSV format. Let us know if you have any
problems.
David Gugick
Imceda Software
www.imceda.com