Hi,
I've got Win Server 2003 Standard 64bit edition trying to work with SQL 2005
standard 64bit edition however there is a problem.
I need to locate the ODBC driver in Win Ser.
I know where they are in the 32bit edition but not in the 64bit version.
can anyone help?
Thanks
Olgun.Ucurel@.ccsmedia.com
Is there a 64 bit ODBC Driver? I didnt think that there was. You might have
to compile your application in x86 or if you are using SSIS or DTS exec you
can use this post...
http://forums.microsoft.com/MSDN/Sho...03814&SiteID=1
Can you use the OLE DB Driver?
C:\WINDOWS\SysWOW64\odbcad32.exe
uses...
odbc32.dll
and
C:\WINDOWS\System32\odbcad32.exe
uses
odbc32.dll
I am sure others will have some thoughts as well.
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Olgun" <Olgun@.discussions.microsoft.com> wrote in message
news:9BA59FAC-D013-4BF4-9700-A97D71D65545@.microsoft.com...
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL
> 2005
> standard 64bit edition however there is a problem.
> I need to locate the ODBC driver in Win Ser.
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@.ccsmedia.com
|||Olgun wrote:
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL 2005
> standard 64bit edition however there is a problem.
> I need to locate the ODBC driver in Win Ser.
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@.ccsmedia.com
As far as I know the ODBC driver is not working on 64 bits Windows. You
could use OLEDB instead, which is working fine.
Regards,
lucm
Showing posts with label locate. Show all posts
Showing posts with label locate. Show all posts
Wednesday, March 21, 2012
Location of .MDF and .LDF files
Does anyone know where a good article pertaining to where you should locate your Data and Log files (in SQL Server 2005)?
I read an article several years ago stating that Log files should be on a seperate RAID 1 and Data on a seperate RAID 5.
Anyway, any help is appreciated.
Look at http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=62Monday, March 19, 2012
Located databases no longer used.
I’m looking to locate databases that have not been written to or accessed for
a specified period of time; we are looking to locate databases that are not
used anymore and clean house. Is there a system table or stored procedure to
access this information? Thank you in advance for you assistance.
Pauly C
No there is not. Your best bet is to run a continuous trace filtered on the
particular db(s) and see if anything accesses them.
Andrew J. Kelly SQL MVP
"Pauly C" <paulysc@.optonline.net> wrote in message
news:04BD4AED-F586-4686-ADBB-0AD86A4EEF90@.microsoft.com...
> I'm looking to locate databases that have not been written to or accessed
> for
> a specified period of time; we are looking to locate databases that are
> not
> used anymore and clean house. Is there a system table or stored procedure
> to
> access this information? Thank you in advance for you assistance.
> Pauly C
>
|||Bummer, Thanks Andy. Tony B say's hello.
Pauly C
"Andrew J. Kelly" wrote:
> No there is not. Your best bet is to run a continuous trace filtered on the
> particular db(s) and see if anything accesses them.
> --
> Andrew J. Kelly SQL MVP
>
> "Pauly C" <paulysc@.optonline.net> wrote in message
> news:04BD4AED-F586-4686-ADBB-0AD86A4EEF90@.microsoft.com...
>
>
|||Didn't even realize that was you<g>. Unfortunately the answer is still
no<g>... Everyone wants that feature though.
Andrew J. Kelly SQL MVP
"Pauly C" <paulysc@.optonline.net> wrote in message
news:A5BDC793-6A72-4F0B-9891-025DC99D927C@.microsoft.com...[vbcol=seagreen]
> Bummer, Thanks Andy. Tony B say's hello.
> Pauly C
> "Andrew J. Kelly" wrote:
a specified period of time; we are looking to locate databases that are not
used anymore and clean house. Is there a system table or stored procedure to
access this information? Thank you in advance for you assistance.
Pauly C
No there is not. Your best bet is to run a continuous trace filtered on the
particular db(s) and see if anything accesses them.
Andrew J. Kelly SQL MVP
"Pauly C" <paulysc@.optonline.net> wrote in message
news:04BD4AED-F586-4686-ADBB-0AD86A4EEF90@.microsoft.com...
> I'm looking to locate databases that have not been written to or accessed
> for
> a specified period of time; we are looking to locate databases that are
> not
> used anymore and clean house. Is there a system table or stored procedure
> to
> access this information? Thank you in advance for you assistance.
> Pauly C
>
|||Bummer, Thanks Andy. Tony B say's hello.
Pauly C
"Andrew J. Kelly" wrote:
> No there is not. Your best bet is to run a continuous trace filtered on the
> particular db(s) and see if anything accesses them.
> --
> Andrew J. Kelly SQL MVP
>
> "Pauly C" <paulysc@.optonline.net> wrote in message
> news:04BD4AED-F586-4686-ADBB-0AD86A4EEF90@.microsoft.com...
>
>
|||Didn't even realize that was you<g>. Unfortunately the answer is still
no<g>... Everyone wants that feature though.
Andrew J. Kelly SQL MVP
"Pauly C" <paulysc@.optonline.net> wrote in message
news:A5BDC793-6A72-4F0B-9891-025DC99D927C@.microsoft.com...[vbcol=seagreen]
> Bummer, Thanks Andy. Tony B say's hello.
> Pauly C
> "Andrew J. Kelly" wrote:
locate static data in xml file vs db table
How do people see the security of locating static data (such as config
settings) in an XML file (a copy is located on each web-server, or a single
copy is located on a specific server) , versus locating this data inside the
db ?
An XML file that contains all app config settings is much easier to maintain
and track from the standpoint of source-code-control , and it is much easier
to apply changes to settings in production environments (just swap the XML
file and restart the web-servers).
The replication and other redudancy advantages accorded data inside SS are
not really necessary for static, load-on-app-start, config settings.
If not possible for data in an XML file to achieve the security of a data in
a db , one option would be to locate the XML file in a SS05 col of XML
datatype.
Anyone have real-world experience making this sort of trade-off decision ,
or any insights ?
Thanks.When did go through a similar exercise for our application. One of the
things that we considered was to look at configuration as something that is
"configurable". This means that the location of the configuration file
should be abstracted from your code so that you are free to move it around.
This is where the Configuration Application Block from Microsoft comes into
play:
http://msdn.microsoft.com/library/d...i
g.asp.
This block abstracts the ability to read and write from the configuration
file and from a deployment perspective, the configuration can be in XML or
in SQL Server. Maybe future editions of this block might put it in an SQL2K5
XML column, but the block would abstract it from you and you would always
have a consistent way of programming.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:OnfTXLs0FHA.3812@.TK2MSFTNGP09.phx.gbl...
> How do people see the security of locating static data (such as config
> settings) in an XML file (a copy is located on each web-server, or a
> single copy is located on a specific server) , versus locating this data
> inside the db ?
> An XML file that contains all app config settings is much easier to
> maintain and track from the standpoint of source-code-control , and it is
> much easier to apply changes to settings in production environments (just
> swap the XML file and restart the web-servers).
> The replication and other redudancy advantages accorded data inside SS are
> not really necessary for static, load-on-app-start, config settings.
> If not possible for data in an XML file to achieve the security of a data
> in a db , one option would be to locate the XML file in a SS05 col of XML
> datatype.
> Anyone have real-world experience making this sort of trade-off decision ,
> or any insights ?
> Thanks.
>|||Problem I see with Configuration Application Block is that it assumes only
the simplest data structure is needed for config settings: discrete named
values.
To get around this, you can write your own transformers. But to leverage the
advantages that CAB offers, you should write them to work against multiple
data-providers/data-stores). This is quite a bit of work -- might be better
to spend that time writing an app-specific solution from scratch.
Also, I think it's not a good idea to avoid upfront analysis of the
app-specific trade-offs between different data-store solutions. CAB seems to
be saying "avoid the tough design decision" ... and, in the process,
sacrifice the advantages offered by a custom design.
But maybe I'm mistaken ...
"SriSamp" <ssampath@.sct.co.in> wrote in message
news:O4Ervev0FHA.460@.TK2MSFTNGP15.phx.gbl...
> When did go through a similar exercise for our application. One of the
> things that we considered was to look at configuration as something that
> is "configurable". This means that the location of the configuration file
> should be abstracted from your code so that you are free to move it
> around. This is where the Configuration Application Block from Microsoft
> comes into play:
> http://msdn.microsoft.com/library/d...br />
fig.asp.
> This block abstracts the ability to read and write from the configuration
> file and from a deployment perspective, the configuration can be in XML or
> in SQL Server. Maybe future editions of this block might put it in an
> SQL2K5 XML column, but the block would abstract it from you and you would
> always have a consistent way of programming.
> --
> HTH,
> SriSamp
> Email: srisamp@.gmail.com
> Blog: http://blogs.sqlxml.org/srinivassampath
> URL: http://www32.brinkster.com/srisamp
> "John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
> news:OnfTXLs0FHA.3812@.TK2MSFTNGP09.phx.gbl...
>|||You're right in saying that CAB out of the box is for simple named values.
We have not tried writing our own formatters, thus, I cannot comment on the
complexity of the same. We did do an anslysis of an application specific
version, but found that the time it takes to provide a UI for the
configuration (like what CAB has) and the simple model of exposing the
configuration as properties of a class for our application looked like a
re-invention of the wheel.
Did you try posting your question to the GOTDOTNET site for Enterprise
Library? It is usually manned by the architects of the library and you may
get more specific answers.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"John Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:O71N%23oz0FHA.2132@.TK2MSFTNGP15.phx.gbl...
> Problem I see with Configuration Application Block is that it assumes only
> the simplest data structure is needed for config settings: discrete named
> values.
> To get around this, you can write your own transformers. But to leverage
> the advantages that CAB offers, you should write them to work against
> multiple data-providers/data-stores). This is quite a bit of work --
> might be better to spend that time writing an app-specific solution from
> scratch.
> Also, I think it's not a good idea to avoid upfront analysis of the
> app-specific trade-offs between different data-store solutions. CAB seems
> to be saying "avoid the tough design decision" ... and, in the process,
> sacrifice the advantages offered by a custom design.
> But maybe I'm mistaken ...
> "SriSamp" <ssampath@.sct.co.in> wrote in message
> news:O4Ervev0FHA.460@.TK2MSFTNGP15.phx.gbl...
>
settings) in an XML file (a copy is located on each web-server, or a single
copy is located on a specific server) , versus locating this data inside the
db ?
An XML file that contains all app config settings is much easier to maintain
and track from the standpoint of source-code-control , and it is much easier
to apply changes to settings in production environments (just swap the XML
file and restart the web-servers).
The replication and other redudancy advantages accorded data inside SS are
not really necessary for static, load-on-app-start, config settings.
If not possible for data in an XML file to achieve the security of a data in
a db , one option would be to locate the XML file in a SS05 col of XML
datatype.
Anyone have real-world experience making this sort of trade-off decision ,
or any insights ?
Thanks.When did go through a similar exercise for our application. One of the
things that we considered was to look at configuration as something that is
"configurable". This means that the location of the configuration file
should be abstracted from your code so that you are free to move it around.
This is where the Configuration Application Block from Microsoft comes into
play:
http://msdn.microsoft.com/library/d...i
g.asp.
This block abstracts the ability to read and write from the configuration
file and from a deployment perspective, the configuration can be in XML or
in SQL Server. Maybe future editions of this block might put it in an SQL2K5
XML column, but the block would abstract it from you and you would always
have a consistent way of programming.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:OnfTXLs0FHA.3812@.TK2MSFTNGP09.phx.gbl...
> How do people see the security of locating static data (such as config
> settings) in an XML file (a copy is located on each web-server, or a
> single copy is located on a specific server) , versus locating this data
> inside the db ?
> An XML file that contains all app config settings is much easier to
> maintain and track from the standpoint of source-code-control , and it is
> much easier to apply changes to settings in production environments (just
> swap the XML file and restart the web-servers).
> The replication and other redudancy advantages accorded data inside SS are
> not really necessary for static, load-on-app-start, config settings.
> If not possible for data in an XML file to achieve the security of a data
> in a db , one option would be to locate the XML file in a SS05 col of XML
> datatype.
> Anyone have real-world experience making this sort of trade-off decision ,
> or any insights ?
> Thanks.
>|||Problem I see with Configuration Application Block is that it assumes only
the simplest data structure is needed for config settings: discrete named
values.
To get around this, you can write your own transformers. But to leverage the
advantages that CAB offers, you should write them to work against multiple
data-providers/data-stores). This is quite a bit of work -- might be better
to spend that time writing an app-specific solution from scratch.
Also, I think it's not a good idea to avoid upfront analysis of the
app-specific trade-offs between different data-store solutions. CAB seems to
be saying "avoid the tough design decision" ... and, in the process,
sacrifice the advantages offered by a custom design.
But maybe I'm mistaken ...
"SriSamp" <ssampath@.sct.co.in> wrote in message
news:O4Ervev0FHA.460@.TK2MSFTNGP15.phx.gbl...
> When did go through a similar exercise for our application. One of the
> things that we considered was to look at configuration as something that
> is "configurable". This means that the location of the configuration file
> should be abstracted from your code so that you are free to move it
> around. This is where the Configuration Application Block from Microsoft
> comes into play:
> http://msdn.microsoft.com/library/d...br />
fig.asp.
> This block abstracts the ability to read and write from the configuration
> file and from a deployment perspective, the configuration can be in XML or
> in SQL Server. Maybe future editions of this block might put it in an
> SQL2K5 XML column, but the block would abstract it from you and you would
> always have a consistent way of programming.
> --
> HTH,
> SriSamp
> Email: srisamp@.gmail.com
> Blog: http://blogs.sqlxml.org/srinivassampath
> URL: http://www32.brinkster.com/srisamp
> "John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
> news:OnfTXLs0FHA.3812@.TK2MSFTNGP09.phx.gbl...
>|||You're right in saying that CAB out of the box is for simple named values.
We have not tried writing our own formatters, thus, I cannot comment on the
complexity of the same. We did do an anslysis of an application specific
version, but found that the time it takes to provide a UI for the
configuration (like what CAB has) and the simple model of exposing the
configuration as properties of a class for our application looked like a
re-invention of the wheel.
Did you try posting your question to the GOTDOTNET site for Enterprise
Library? It is usually manned by the architects of the library and you may
get more specific answers.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"John Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:O71N%23oz0FHA.2132@.TK2MSFTNGP15.phx.gbl...
> Problem I see with Configuration Application Block is that it assumes only
> the simplest data structure is needed for config settings: discrete named
> values.
> To get around this, you can write your own transformers. But to leverage
> the advantages that CAB offers, you should write them to work against
> multiple data-providers/data-stores). This is quite a bit of work --
> might be better to spend that time writing an app-specific solution from
> scratch.
> Also, I think it's not a good idea to avoid upfront analysis of the
> app-specific trade-offs between different data-store solutions. CAB seems
> to be saying "avoid the tough design decision" ... and, in the process,
> sacrifice the advantages offered by a custom design.
> But maybe I'm mistaken ...
> "SriSamp" <ssampath@.sct.co.in> wrote in message
> news:O4Ervev0FHA.460@.TK2MSFTNGP15.phx.gbl...
>
Locate SQL Server on your LAN
What is the best/easiest way to locate all the SQL server
installed on your LAN?
SQL Scan
http://microsoft.com/downloads/detai...displaylang=en
http://www.aspfaq.com/
(Reverse address to reply.)
"MWH" <anonymous@.discussions.microsoft.com> wrote in message
news:255e01c4a7e8$ada3c920$a401280a@.phx.gbl...
> What is the best/easiest way to locate all the SQL server
> installed on your LAN?
|||The Quest freeware tools have this capability. They put any servers they
discover directly into the Nav Tree. Check
www.quest.com/quest_central/sql_server/freeware.
-Kevin
SQL Server MVP
"MWH" <anonymous@.discussions.microsoft.com> wrote in message
news:255e01c4a7e8$ada3c920$a401280a@.phx.gbl...
> What is the best/easiest way to locate all the SQL server
> installed on your LAN?
installed on your LAN?
SQL Scan
http://microsoft.com/downloads/detai...displaylang=en
http://www.aspfaq.com/
(Reverse address to reply.)
"MWH" <anonymous@.discussions.microsoft.com> wrote in message
news:255e01c4a7e8$ada3c920$a401280a@.phx.gbl...
> What is the best/easiest way to locate all the SQL server
> installed on your LAN?
|||The Quest freeware tools have this capability. They put any servers they
discover directly into the Nav Tree. Check
www.quest.com/quest_central/sql_server/freeware.
-Kevin
SQL Server MVP
"MWH" <anonymous@.discussions.microsoft.com> wrote in message
news:255e01c4a7e8$ada3c920$a401280a@.phx.gbl...
> What is the best/easiest way to locate all the SQL server
> installed on your LAN?
Locate SQL Server on your LAN
What is the best/easiest way to locate all the SQL server
installed on your LAN?SQL Scan
http://microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en
--
http://www.aspfaq.com/
(Reverse address to reply.)
"MWH" <anonymous@.discussions.microsoft.com> wrote in message
news:255e01c4a7e8$ada3c920$a401280a@.phx.gbl...
> What is the best/easiest way to locate all the SQL server
> installed on your LAN?|||The Quest freeware tools have this capability. They put any servers they
discover directly into the Nav Tree. Check
www.quest.com/quest_central/sql_server/freeware.
-Kevin
SQL Server MVP
"MWH" <anonymous@.discussions.microsoft.com> wrote in message
news:255e01c4a7e8$ada3c920$a401280a@.phx.gbl...
> What is the best/easiest way to locate all the SQL server
> installed on your LAN?
installed on your LAN?SQL Scan
http://microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en
--
http://www.aspfaq.com/
(Reverse address to reply.)
"MWH" <anonymous@.discussions.microsoft.com> wrote in message
news:255e01c4a7e8$ada3c920$a401280a@.phx.gbl...
> What is the best/easiest way to locate all the SQL server
> installed on your LAN?|||The Quest freeware tools have this capability. They put any servers they
discover directly into the Nav Tree. Check
www.quest.com/quest_central/sql_server/freeware.
-Kevin
SQL Server MVP
"MWH" <anonymous@.discussions.microsoft.com> wrote in message
news:255e01c4a7e8$ada3c920$a401280a@.phx.gbl...
> What is the best/easiest way to locate all the SQL server
> installed on your LAN?
Locate SQL Server info
Hello, I'm looking for info on how/where to find the following info about
our SQL Server:
- SQL Server version type (enterprise, standard, etc.)
- SQL Server character set
- SQL Server sort order
- SQL Server files location
- SQL Server master database location
- SQL Server tempdb data location
- SQL Server tempdb log location
The reason I am looking for this is that I have adopted an SQL server for
SMS, and I am needing to collect all pertinent info and settings for
disaster recovery. TIA.
--
Hermes> - SQL Server version type (enterprise, standard, etc.)
select @.@.version
> - SQL Server character set
> - SQL Server sort order
sp_helpsort
> - SQL Server files location
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
> - SQL Server master database location
> - SQL Server tempdb data location
> - SQL Server tempdb log location
sp_helpdb your_database
"hermes" <hermes@.messenger.com> wrote in message
news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
> Hello, I'm looking for info on how/where to find the following info about
> our SQL Server:
> - SQL Server version type (enterprise, standard, etc.)
> - SQL Server character set
> - SQL Server sort order
> - SQL Server files location
> - SQL Server master database location
> - SQL Server tempdb data location
> - SQL Server tempdb log location
> The reason I am looking for this is that I have adopted an SQL server for
> SMS, and I am needing to collect all pertinent info and settings for
> disaster recovery. TIA.
> --
> Hermes
>|||In SQL 2000, you can also SELECT * from
master..sysaltfiles to get the locations of all your
data/log files.
Linchi
>--Original Message--
>> - SQL Server version type (enterprise, standard, etc.)
>select @.@.version
>> - SQL Server character set
>> - SQL Server sort order
>sp_helpsort
>> - SQL Server files location
>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
>> - SQL Server master database location
>> - SQL Server tempdb data location
>> - SQL Server tempdb log location
>sp_helpdb your_database
>
>"hermes" <hermes@.messenger.com> wrote in message
>news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
>> Hello, I'm looking for info on how/where to find the
following info about
>> our SQL Server:
>> - SQL Server version type (enterprise, standard, etc.)
>> - SQL Server character set
>> - SQL Server sort order
>> - SQL Server files location
>> - SQL Server master database location
>> - SQL Server tempdb data location
>> - SQL Server tempdb log location
>> The reason I am looking for this is that I have adopted
an SQL server for
>> SMS, and I am needing to collect all pertinent info and
settings for
>> disaster recovery. TIA.
>> --
>> Hermes
>>
>
>.
>|||While listening to the voices in their head blather on endlessly about
inspecific gibberish, Linchi Shea typed:
:: In SQL 2000, you can also SELECT * from
:: master..sysaltfiles to get the locations of all your
:: data/log files.
::
:: Linchi
::
::: --Original Message--
:::: - SQL Server version type (enterprise, standard, etc.) select
:::: @.@.version
:::: - SQL Server character set
:::: - SQL Server sort order
::: sp_helpsort
:::: - SQL Server files location
::: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
:::: - SQL Server master database location
:::: - SQL Server tempdb data location
:::: - SQL Server tempdb log location
::: sp_helpdb your_database
:::
:::
::: "hermes" <hermes@.messenger.com> wrote in message
::: news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
:::: Hello, I'm looking for info on how/where to find the following
:::: info about our SQL Server:
:::: - SQL Server version type (enterprise, standard, etc.)
:::: - SQL Server character set
:::: - SQL Server sort order
:::: - SQL Server files location
:::: - SQL Server master database location
:::: - SQL Server tempdb data location
:::: - SQL Server tempdb log location
::::
:::: The reason I am looking for this is that I have adopted an SQL
:::: server for SMS, and I am needing to collect all pertinent info and
:::: settings for disaster recovery. TIA.
::::
:::: --
:::: Hermes
::::
::::
:::
:::
::: .
Thank you so much for the quick replies! Unfortunately I am pretty much
clueless when it comes to SQL server, and I have no knowledge of running
commands like this ( I am the pc tech and new sms admin). From all of the
info you have posted, I only know how to get the info from the registry.
Could you possibly give me more info on how to run these commands such as
which application would I go into, the SQL Enterprise Manager? Also, in the
registry location, is it the SQLPath entry? Thanks again.
--
Hermes|||Hi Hermes
When someone just suggests a command to run, the tool is usually the Query
Analyzer. This is the tool you use to have your SQL Server directly execute
SQL statements.
So you could enter
SELECT * FROM master..sysaltfiles
<now press the green arrow button on the toolbar to execute this query>
or sp_helpdb 'your database name'
<press green arrow>
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"hermes" <hermes@.messenger.com> wrote in message
news:erhxTzrsDHA.2248@.TK2MSFTNGP09.phx.gbl...
> While listening to the voices in their head blather on endlessly about
> inspecific gibberish, Linchi Shea typed:
> :: In SQL 2000, you can also SELECT * from
> :: master..sysaltfiles to get the locations of all your
> :: data/log files.
> ::
> :: Linchi
> ::
> ::: --Original Message--
> :::: - SQL Server version type (enterprise, standard, etc.) select
> :::: @.@.version
> :::: - SQL Server character set
> :::: - SQL Server sort order
> ::: sp_helpsort
> :::: - SQL Server files location
> ::: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
> :::: - SQL Server master database location
> :::: - SQL Server tempdb data location
> :::: - SQL Server tempdb log location
> ::: sp_helpdb your_database
> :::
> :::
> ::: "hermes" <hermes@.messenger.com> wrote in message
> ::: news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
> :::: Hello, I'm looking for info on how/where to find the following
> :::: info about our SQL Server:
> :::: - SQL Server version type (enterprise, standard, etc.)
> :::: - SQL Server character set
> :::: - SQL Server sort order
> :::: - SQL Server files location
> :::: - SQL Server master database location
> :::: - SQL Server tempdb data location
> :::: - SQL Server tempdb log location
> ::::
> :::: The reason I am looking for this is that I have adopted an SQL
> :::: server for SMS, and I am needing to collect all pertinent info and
> :::: settings for disaster recovery. TIA.
> ::::
> :::: --
> :::: Hermes
> ::::
> ::::
> :::
> :::
> ::: .
>
> Thank you so much for the quick replies! Unfortunately I am pretty much
> clueless when it comes to SQL server, and I have no knowledge of running
> commands like this ( I am the pc tech and new sms admin). From all of the
> info you have posted, I only know how to get the info from the registry.
> Could you possibly give me more info on how to run these commands such as
> which application would I go into, the SQL Enterprise Manager? Also, in
the
> registry location, is it the SQLPath entry? Thanks again.
> --
> Hermes
>|||While listening to the voices in their head blather on endlessly about
inspecific gibberish, Kalen Delaney typed:
:: Hi Hermes
::
:: When someone just suggests a command to run, the tool is usually the
:: Query Analyzer. This is the tool you use to have your SQL Server
:: directly execute SQL statements.
::
:: So you could enter
::
:: SELECT * FROM master..sysaltfiles
:: <now press the green arrow button on the toolbar to execute this
:: query>
::
:: or sp_helpdb 'your database name'
:: <press green arrow>
::
:: --
:: HTH
:: --
:: Kalen Delaney
:: SQL Server MVP
:: www.SolidQualityLearning.com
::
::
:: "hermes" <hermes@.messenger.com> wrote in message
:: news:erhxTzrsDHA.2248@.TK2MSFTNGP09.phx.gbl...
::: While listening to the voices in their head blather on endlessly
::: about inspecific gibberish, Linchi Shea typed:
::::: In SQL 2000, you can also SELECT * from
::::: master..sysaltfiles to get the locations of all your
::::: data/log files.
:::::
::::: Linchi
:::::
:::::: --Original Message--
::::::: - SQL Server version type (enterprise, standard, etc.) select
::::::: @.@.version
::::::: - SQL Server character set
::::::: - SQL Server sort order
:::::: sp_helpsort
::::::: - SQL Server files location
:::::: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
::::::: - SQL Server master database location
::::::: - SQL Server tempdb data location
::::::: - SQL Server tempdb log location
:::::: sp_helpdb your_database
::::::
::::::
:::::: "hermes" <hermes@.messenger.com> wrote in message
:::::: news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
::::::: Hello, I'm looking for info on how/where to find the following
::::::: info about our SQL Server:
::::::: - SQL Server version type (enterprise, standard, etc.)
::::::: - SQL Server character set
::::::: - SQL Server sort order
::::::: - SQL Server files location
::::::: - SQL Server master database location
::::::: - SQL Server tempdb data location
::::::: - SQL Server tempdb log location
:::::::
::::::: The reason I am looking for this is that I have adopted an SQL
::::::: server for SMS, and I am needing to collect all pertinent info
::::::: and settings for disaster recovery. TIA.
:::::::
::::::: --
::::::: Hermes
:::::::
:::::::
::::::
::::::
:::::: .
:::
:::
::: Thank you so much for the quick replies! Unfortunately I am pretty
::: much clueless when it comes to SQL server, and I have no knowledge
::: of running commands like this ( I am the pc tech and new sms
::: admin). From all of the info you have posted, I only know how to
::: get the info from the registry. Could you possibly give me more
::: info on how to run these commands such as which application would I
::: go into, the SQL Enterprise Manager? Also, in the registry
::: location, is it the SQLPath entry? Thanks again.
:::
::: --
::: Hermes
Kalen and everyone, you have been incredibly helpful, thanks! :) I have all
of the info I need now except the character set. Anyone out there who knows
how to find out which character set my SQL Server is using? Thanks again.
--
Hermes|||SELECT SERVERPROPERTY('collation')
will give you the default for the SQL Server, but databases can have a
different collation than the server default.
For a particular database:
SELECT DatabasePropertyEx('database_name','Collation')
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"hermes" <hermes@.messenger.com> wrote in message
news:OABB0$ssDHA.1884@.TK2MSFTNGP10.phx.gbl...
> While listening to the voices in their head blather on endlessly about
> inspecific gibberish, Kalen Delaney typed:
> :: Hi Hermes
> ::
> :: When someone just suggests a command to run, the tool is usually the
> :: Query Analyzer. This is the tool you use to have your SQL Server
> :: directly execute SQL statements.
> ::
> :: So you could enter
> ::
> :: SELECT * FROM master..sysaltfiles
> :: <now press the green arrow button on the toolbar to execute this
> :: query>
> ::
> :: or sp_helpdb 'your database name'
> :: <press green arrow>
> ::
> :: --
> :: HTH
> :: --
> :: Kalen Delaney
> :: SQL Server MVP
> :: www.SolidQualityLearning.com
> ::
> ::
> :: "hermes" <hermes@.messenger.com> wrote in message
> :: news:erhxTzrsDHA.2248@.TK2MSFTNGP09.phx.gbl...
> ::: While listening to the voices in their head blather on endlessly
> ::: about inspecific gibberish, Linchi Shea typed:
> ::::: In SQL 2000, you can also SELECT * from
> ::::: master..sysaltfiles to get the locations of all your
> ::::: data/log files.
> :::::
> ::::: Linchi
> :::::
> :::::: --Original Message--
> ::::::: - SQL Server version type (enterprise, standard, etc.) select
> ::::::: @.@.version
> ::::::: - SQL Server character set
> ::::::: - SQL Server sort order
> :::::: sp_helpsort
> ::::::: - SQL Server files location
> :::::: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
> ::::::: - SQL Server master database location
> ::::::: - SQL Server tempdb data location
> ::::::: - SQL Server tempdb log location
> :::::: sp_helpdb your_database
> ::::::
> ::::::
> :::::: "hermes" <hermes@.messenger.com> wrote in message
> :::::: news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
> ::::::: Hello, I'm looking for info on how/where to find the following
> ::::::: info about our SQL Server:
> ::::::: - SQL Server version type (enterprise, standard, etc.)
> ::::::: - SQL Server character set
> ::::::: - SQL Server sort order
> ::::::: - SQL Server files location
> ::::::: - SQL Server master database location
> ::::::: - SQL Server tempdb data location
> ::::::: - SQL Server tempdb log location
> :::::::
> ::::::: The reason I am looking for this is that I have adopted an SQL
> ::::::: server for SMS, and I am needing to collect all pertinent info
> ::::::: and settings for disaster recovery. TIA.
> :::::::
> ::::::: --
> ::::::: Hermes
> :::::::
> :::::::
> ::::::
> ::::::
> :::::: .
> :::
> :::
> ::: Thank you so much for the quick replies! Unfortunately I am pretty
> ::: much clueless when it comes to SQL server, and I have no knowledge
> ::: of running commands like this ( I am the pc tech and new sms
> ::: admin). From all of the info you have posted, I only know how to
> ::: get the info from the registry. Could you possibly give me more
> ::: info on how to run these commands such as which application would I
> ::: go into, the SQL Enterprise Manager? Also, in the registry
> ::: location, is it the SQLPath entry? Thanks again.
> :::
> ::: --
> ::: Hermes
>
> Kalen and everyone, you have been incredibly helpful, thanks! :) I have
all
> of the info I need now except the character set. Anyone out there who
knows
> how to find out which character set my SQL Server is using? Thanks again.
> --
> Hermes
>
our SQL Server:
- SQL Server version type (enterprise, standard, etc.)
- SQL Server character set
- SQL Server sort order
- SQL Server files location
- SQL Server master database location
- SQL Server tempdb data location
- SQL Server tempdb log location
The reason I am looking for this is that I have adopted an SQL server for
SMS, and I am needing to collect all pertinent info and settings for
disaster recovery. TIA.
--
Hermes> - SQL Server version type (enterprise, standard, etc.)
select @.@.version
> - SQL Server character set
> - SQL Server sort order
sp_helpsort
> - SQL Server files location
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
> - SQL Server master database location
> - SQL Server tempdb data location
> - SQL Server tempdb log location
sp_helpdb your_database
"hermes" <hermes@.messenger.com> wrote in message
news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
> Hello, I'm looking for info on how/where to find the following info about
> our SQL Server:
> - SQL Server version type (enterprise, standard, etc.)
> - SQL Server character set
> - SQL Server sort order
> - SQL Server files location
> - SQL Server master database location
> - SQL Server tempdb data location
> - SQL Server tempdb log location
> The reason I am looking for this is that I have adopted an SQL server for
> SMS, and I am needing to collect all pertinent info and settings for
> disaster recovery. TIA.
> --
> Hermes
>|||In SQL 2000, you can also SELECT * from
master..sysaltfiles to get the locations of all your
data/log files.
Linchi
>--Original Message--
>> - SQL Server version type (enterprise, standard, etc.)
>select @.@.version
>> - SQL Server character set
>> - SQL Server sort order
>sp_helpsort
>> - SQL Server files location
>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
>> - SQL Server master database location
>> - SQL Server tempdb data location
>> - SQL Server tempdb log location
>sp_helpdb your_database
>
>"hermes" <hermes@.messenger.com> wrote in message
>news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
>> Hello, I'm looking for info on how/where to find the
following info about
>> our SQL Server:
>> - SQL Server version type (enterprise, standard, etc.)
>> - SQL Server character set
>> - SQL Server sort order
>> - SQL Server files location
>> - SQL Server master database location
>> - SQL Server tempdb data location
>> - SQL Server tempdb log location
>> The reason I am looking for this is that I have adopted
an SQL server for
>> SMS, and I am needing to collect all pertinent info and
settings for
>> disaster recovery. TIA.
>> --
>> Hermes
>>
>
>.
>|||While listening to the voices in their head blather on endlessly about
inspecific gibberish, Linchi Shea typed:
:: In SQL 2000, you can also SELECT * from
:: master..sysaltfiles to get the locations of all your
:: data/log files.
::
:: Linchi
::
::: --Original Message--
:::: - SQL Server version type (enterprise, standard, etc.) select
:::: @.@.version
:::: - SQL Server character set
:::: - SQL Server sort order
::: sp_helpsort
:::: - SQL Server files location
::: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
:::: - SQL Server master database location
:::: - SQL Server tempdb data location
:::: - SQL Server tempdb log location
::: sp_helpdb your_database
:::
:::
::: "hermes" <hermes@.messenger.com> wrote in message
::: news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
:::: Hello, I'm looking for info on how/where to find the following
:::: info about our SQL Server:
:::: - SQL Server version type (enterprise, standard, etc.)
:::: - SQL Server character set
:::: - SQL Server sort order
:::: - SQL Server files location
:::: - SQL Server master database location
:::: - SQL Server tempdb data location
:::: - SQL Server tempdb log location
::::
:::: The reason I am looking for this is that I have adopted an SQL
:::: server for SMS, and I am needing to collect all pertinent info and
:::: settings for disaster recovery. TIA.
::::
:::: --
:::: Hermes
::::
::::
:::
:::
::: .
Thank you so much for the quick replies! Unfortunately I am pretty much
clueless when it comes to SQL server, and I have no knowledge of running
commands like this ( I am the pc tech and new sms admin). From all of the
info you have posted, I only know how to get the info from the registry.
Could you possibly give me more info on how to run these commands such as
which application would I go into, the SQL Enterprise Manager? Also, in the
registry location, is it the SQLPath entry? Thanks again.
--
Hermes|||Hi Hermes
When someone just suggests a command to run, the tool is usually the Query
Analyzer. This is the tool you use to have your SQL Server directly execute
SQL statements.
So you could enter
SELECT * FROM master..sysaltfiles
<now press the green arrow button on the toolbar to execute this query>
or sp_helpdb 'your database name'
<press green arrow>
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"hermes" <hermes@.messenger.com> wrote in message
news:erhxTzrsDHA.2248@.TK2MSFTNGP09.phx.gbl...
> While listening to the voices in their head blather on endlessly about
> inspecific gibberish, Linchi Shea typed:
> :: In SQL 2000, you can also SELECT * from
> :: master..sysaltfiles to get the locations of all your
> :: data/log files.
> ::
> :: Linchi
> ::
> ::: --Original Message--
> :::: - SQL Server version type (enterprise, standard, etc.) select
> :::: @.@.version
> :::: - SQL Server character set
> :::: - SQL Server sort order
> ::: sp_helpsort
> :::: - SQL Server files location
> ::: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
> :::: - SQL Server master database location
> :::: - SQL Server tempdb data location
> :::: - SQL Server tempdb log location
> ::: sp_helpdb your_database
> :::
> :::
> ::: "hermes" <hermes@.messenger.com> wrote in message
> ::: news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
> :::: Hello, I'm looking for info on how/where to find the following
> :::: info about our SQL Server:
> :::: - SQL Server version type (enterprise, standard, etc.)
> :::: - SQL Server character set
> :::: - SQL Server sort order
> :::: - SQL Server files location
> :::: - SQL Server master database location
> :::: - SQL Server tempdb data location
> :::: - SQL Server tempdb log location
> ::::
> :::: The reason I am looking for this is that I have adopted an SQL
> :::: server for SMS, and I am needing to collect all pertinent info and
> :::: settings for disaster recovery. TIA.
> ::::
> :::: --
> :::: Hermes
> ::::
> ::::
> :::
> :::
> ::: .
>
> Thank you so much for the quick replies! Unfortunately I am pretty much
> clueless when it comes to SQL server, and I have no knowledge of running
> commands like this ( I am the pc tech and new sms admin). From all of the
> info you have posted, I only know how to get the info from the registry.
> Could you possibly give me more info on how to run these commands such as
> which application would I go into, the SQL Enterprise Manager? Also, in
the
> registry location, is it the SQLPath entry? Thanks again.
> --
> Hermes
>|||While listening to the voices in their head blather on endlessly about
inspecific gibberish, Kalen Delaney typed:
:: Hi Hermes
::
:: When someone just suggests a command to run, the tool is usually the
:: Query Analyzer. This is the tool you use to have your SQL Server
:: directly execute SQL statements.
::
:: So you could enter
::
:: SELECT * FROM master..sysaltfiles
:: <now press the green arrow button on the toolbar to execute this
:: query>
::
:: or sp_helpdb 'your database name'
:: <press green arrow>
::
:: --
:: HTH
:: --
:: Kalen Delaney
:: SQL Server MVP
:: www.SolidQualityLearning.com
::
::
:: "hermes" <hermes@.messenger.com> wrote in message
:: news:erhxTzrsDHA.2248@.TK2MSFTNGP09.phx.gbl...
::: While listening to the voices in their head blather on endlessly
::: about inspecific gibberish, Linchi Shea typed:
::::: In SQL 2000, you can also SELECT * from
::::: master..sysaltfiles to get the locations of all your
::::: data/log files.
:::::
::::: Linchi
:::::
:::::: --Original Message--
::::::: - SQL Server version type (enterprise, standard, etc.) select
::::::: @.@.version
::::::: - SQL Server character set
::::::: - SQL Server sort order
:::::: sp_helpsort
::::::: - SQL Server files location
:::::: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
::::::: - SQL Server master database location
::::::: - SQL Server tempdb data location
::::::: - SQL Server tempdb log location
:::::: sp_helpdb your_database
::::::
::::::
:::::: "hermes" <hermes@.messenger.com> wrote in message
:::::: news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
::::::: Hello, I'm looking for info on how/where to find the following
::::::: info about our SQL Server:
::::::: - SQL Server version type (enterprise, standard, etc.)
::::::: - SQL Server character set
::::::: - SQL Server sort order
::::::: - SQL Server files location
::::::: - SQL Server master database location
::::::: - SQL Server tempdb data location
::::::: - SQL Server tempdb log location
:::::::
::::::: The reason I am looking for this is that I have adopted an SQL
::::::: server for SMS, and I am needing to collect all pertinent info
::::::: and settings for disaster recovery. TIA.
:::::::
::::::: --
::::::: Hermes
:::::::
:::::::
::::::
::::::
:::::: .
:::
:::
::: Thank you so much for the quick replies! Unfortunately I am pretty
::: much clueless when it comes to SQL server, and I have no knowledge
::: of running commands like this ( I am the pc tech and new sms
::: admin). From all of the info you have posted, I only know how to
::: get the info from the registry. Could you possibly give me more
::: info on how to run these commands such as which application would I
::: go into, the SQL Enterprise Manager? Also, in the registry
::: location, is it the SQLPath entry? Thanks again.
:::
::: --
::: Hermes
Kalen and everyone, you have been incredibly helpful, thanks! :) I have all
of the info I need now except the character set. Anyone out there who knows
how to find out which character set my SQL Server is using? Thanks again.
--
Hermes|||SELECT SERVERPROPERTY('collation')
will give you the default for the SQL Server, but databases can have a
different collation than the server default.
For a particular database:
SELECT DatabasePropertyEx('database_name','Collation')
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"hermes" <hermes@.messenger.com> wrote in message
news:OABB0$ssDHA.1884@.TK2MSFTNGP10.phx.gbl...
> While listening to the voices in their head blather on endlessly about
> inspecific gibberish, Kalen Delaney typed:
> :: Hi Hermes
> ::
> :: When someone just suggests a command to run, the tool is usually the
> :: Query Analyzer. This is the tool you use to have your SQL Server
> :: directly execute SQL statements.
> ::
> :: So you could enter
> ::
> :: SELECT * FROM master..sysaltfiles
> :: <now press the green arrow button on the toolbar to execute this
> :: query>
> ::
> :: or sp_helpdb 'your database name'
> :: <press green arrow>
> ::
> :: --
> :: HTH
> :: --
> :: Kalen Delaney
> :: SQL Server MVP
> :: www.SolidQualityLearning.com
> ::
> ::
> :: "hermes" <hermes@.messenger.com> wrote in message
> :: news:erhxTzrsDHA.2248@.TK2MSFTNGP09.phx.gbl...
> ::: While listening to the voices in their head blather on endlessly
> ::: about inspecific gibberish, Linchi Shea typed:
> ::::: In SQL 2000, you can also SELECT * from
> ::::: master..sysaltfiles to get the locations of all your
> ::::: data/log files.
> :::::
> ::::: Linchi
> :::::
> :::::: --Original Message--
> ::::::: - SQL Server version type (enterprise, standard, etc.) select
> ::::::: @.@.version
> ::::::: - SQL Server character set
> ::::::: - SQL Server sort order
> :::::: sp_helpsort
> ::::::: - SQL Server files location
> :::::: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
> ::::::: - SQL Server master database location
> ::::::: - SQL Server tempdb data location
> ::::::: - SQL Server tempdb log location
> :::::: sp_helpdb your_database
> ::::::
> ::::::
> :::::: "hermes" <hermes@.messenger.com> wrote in message
> :::::: news:epFYIwqsDHA.2360@.TK2MSFTNGP10.phx.gbl...
> ::::::: Hello, I'm looking for info on how/where to find the following
> ::::::: info about our SQL Server:
> ::::::: - SQL Server version type (enterprise, standard, etc.)
> ::::::: - SQL Server character set
> ::::::: - SQL Server sort order
> ::::::: - SQL Server files location
> ::::::: - SQL Server master database location
> ::::::: - SQL Server tempdb data location
> ::::::: - SQL Server tempdb log location
> :::::::
> ::::::: The reason I am looking for this is that I have adopted an SQL
> ::::::: server for SMS, and I am needing to collect all pertinent info
> ::::::: and settings for disaster recovery. TIA.
> :::::::
> ::::::: --
> ::::::: Hermes
> :::::::
> :::::::
> ::::::
> ::::::
> :::::: .
> :::
> :::
> ::: Thank you so much for the quick replies! Unfortunately I am pretty
> ::: much clueless when it comes to SQL server, and I have no knowledge
> ::: of running commands like this ( I am the pc tech and new sms
> ::: admin). From all of the info you have posted, I only know how to
> ::: get the info from the registry. Could you possibly give me more
> ::: info on how to run these commands such as which application would I
> ::: go into, the SQL Enterprise Manager? Also, in the registry
> ::: location, is it the SQLPath entry? Thanks again.
> :::
> ::: --
> ::: Hermes
>
> Kalen and everyone, you have been incredibly helpful, thanks! :) I have
all
> of the info I need now except the character set. Anyone out there who
knows
> how to find out which character set my SQL Server is using? Thanks again.
> --
> Hermes
>
Locate records that meet ALL the requirements using IN or EXIST? Help?
Using SQL Server 2000...
I have a front end that provides the user with a 'search engine' to
pass search parameters. The stored procedure it calls joins multiple
tables/views to return the proper result.
I am running into a problem that I solved in the interface using code
(that takes WAY too long), but I know there must be a way to have SQL
Server do the work using T-SQL... as this seems a very simple issue.
The following is just a snippet of the pertinent information:
Assume I have a main Customer table with a unique CustID field.
I have another table of descriptive Flags with a unique FlagID field.
A third table Customer_Flag_Link has a unique ID field and contains 2
columns, the CustID and the FlagID.
Obvioulsy, the role of this 3rd table is to be able to assign multiple
Flags to each Customer.
Now assume I have the following data in the Customer_Flag_Link table:
UniqueID CustID FlagID
===============================
1 123 333
2 123 444
3 123 222
4 987 444
5 987 222
6 567 111
7 567 222
My issue is that I want to be able to locate Customers who have ALL of
the passed Flags associated with them, I do not know how many Flags
will be passed (and there are other search parameters passed as well -
but this is the piece that is giving me trouble, though I am sure it
is simple!)
For example, I want to return CustID where exists FlagID 222 AND 444.
Based on the above data it should return CustID 123 and 987, but not
567.
Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
this does not give me the results I want.
Any ideas would be appreciated!
Thanks,
AK
This might help.
SELECT COUNT(distinct FlagID)
FROM Customer_Flag_Link
WHERE FlagID IN (222,444)
AND Customer = 'Ralph'
HAVING COUNT(distinct FlagID) = 2
The number of items in the IN clause is what is used in the HAVING
test. Of course this could be written as an EXISTS subquery,
correlated on Customer.
Roy Harvey
Beacon Falls, CT
On Thu, 21 Jun 2007 10:50:45 -0700, aklein <abklein@.optonline.net>
wrote:
>Using SQL Server 2000...
>I have a front end that provides the user with a 'search engine' to
>pass search parameters. The stored procedure it calls joins multiple
>tables/views to return the proper result.
>I am running into a problem that I solved in the interface using code
>(that takes WAY too long), but I know there must be a way to have SQL
>Server do the work using T-SQL... as this seems a very simple issue.
>The following is just a snippet of the pertinent information:
>Assume I have a main Customer table with a unique CustID field.
>I have another table of descriptive Flags with a unique FlagID field.
>A third table Customer_Flag_Link has a unique ID field and contains 2
>columns, the CustID and the FlagID.
>Obvioulsy, the role of this 3rd table is to be able to assign multiple
>Flags to each Customer.
>Now assume I have the following data in the Customer_Flag_Link table:
>
>UniqueID CustID FlagID
>===============================
>1 123 333
>2 123 444
>3 123 222
>4 987 444
>5 987 222
>6 567 111
>7 567 222
>My issue is that I want to be able to locate Customers who have ALL of
>the passed Flags associated with them, I do not know how many Flags
>will be passed (and there are other search parameters passed as well -
>but this is the piece that is giving me trouble, though I am sure it
>is simple!)
>For example, I want to return CustID where exists FlagID 222 AND 444.
>Based on the above data it should return CustID 123 and 987, but not
>567.
>Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
>this does not give me the results I want.
>Any ideas would be appreciated!
>Thanks,
>AK
|||Hmmmm...
I have to see how to stick that idea into the larger procedure... but
it gives me a starting point.
Thanks for the idea!
AK
I have a front end that provides the user with a 'search engine' to
pass search parameters. The stored procedure it calls joins multiple
tables/views to return the proper result.
I am running into a problem that I solved in the interface using code
(that takes WAY too long), but I know there must be a way to have SQL
Server do the work using T-SQL... as this seems a very simple issue.
The following is just a snippet of the pertinent information:
Assume I have a main Customer table with a unique CustID field.
I have another table of descriptive Flags with a unique FlagID field.
A third table Customer_Flag_Link has a unique ID field and contains 2
columns, the CustID and the FlagID.
Obvioulsy, the role of this 3rd table is to be able to assign multiple
Flags to each Customer.
Now assume I have the following data in the Customer_Flag_Link table:
UniqueID CustID FlagID
===============================
1 123 333
2 123 444
3 123 222
4 987 444
5 987 222
6 567 111
7 567 222
My issue is that I want to be able to locate Customers who have ALL of
the passed Flags associated with them, I do not know how many Flags
will be passed (and there are other search parameters passed as well -
but this is the piece that is giving me trouble, though I am sure it
is simple!)
For example, I want to return CustID where exists FlagID 222 AND 444.
Based on the above data it should return CustID 123 and 987, but not
567.
Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
this does not give me the results I want.
Any ideas would be appreciated!
Thanks,
AK
This might help.
SELECT COUNT(distinct FlagID)
FROM Customer_Flag_Link
WHERE FlagID IN (222,444)
AND Customer = 'Ralph'
HAVING COUNT(distinct FlagID) = 2
The number of items in the IN clause is what is used in the HAVING
test. Of course this could be written as an EXISTS subquery,
correlated on Customer.
Roy Harvey
Beacon Falls, CT
On Thu, 21 Jun 2007 10:50:45 -0700, aklein <abklein@.optonline.net>
wrote:
>Using SQL Server 2000...
>I have a front end that provides the user with a 'search engine' to
>pass search parameters. The stored procedure it calls joins multiple
>tables/views to return the proper result.
>I am running into a problem that I solved in the interface using code
>(that takes WAY too long), but I know there must be a way to have SQL
>Server do the work using T-SQL... as this seems a very simple issue.
>The following is just a snippet of the pertinent information:
>Assume I have a main Customer table with a unique CustID field.
>I have another table of descriptive Flags with a unique FlagID field.
>A third table Customer_Flag_Link has a unique ID field and contains 2
>columns, the CustID and the FlagID.
>Obvioulsy, the role of this 3rd table is to be able to assign multiple
>Flags to each Customer.
>Now assume I have the following data in the Customer_Flag_Link table:
>
>UniqueID CustID FlagID
>===============================
>1 123 333
>2 123 444
>3 123 222
>4 987 444
>5 987 222
>6 567 111
>7 567 222
>My issue is that I want to be able to locate Customers who have ALL of
>the passed Flags associated with them, I do not know how many Flags
>will be passed (and there are other search parameters passed as well -
>but this is the piece that is giving me trouble, though I am sure it
>is simple!)
>For example, I want to return CustID where exists FlagID 222 AND 444.
>Based on the above data it should return CustID 123 and 987, but not
>567.
>Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
>this does not give me the results I want.
>Any ideas would be appreciated!
>Thanks,
>AK
|||Hmmmm...
I have to see how to stick that idea into the larger procedure... but
it gives me a starting point.
Thanks for the idea!
AK
Locate records that meet ALL the requirements using IN or EXIST? Help?
Using SQL Server 2000...
I have a front end that provides the user with a 'search engine' to
pass search parameters. The stored procedure it calls joins multiple
tables/views to return the proper result.
I am running into a problem that I solved in the interface using code
(that takes WAY too long), but I know there must be a way to have SQL
Server do the work using T-SQL... as this seems a very simple issue.
The following is just a snippet of the pertinent information:
Assume I have a main Customer table with a unique CustID field.
I have another table of descriptive Flags with a unique FlagID field.
A third table Customer_Flag_Link has a unique ID field and contains 2
columns, the CustID and the FlagID.
Obvioulsy, the role of this 3rd table is to be able to assign multiple
Flags to each Customer.
Now assume I have the following data in the Customer_Flag_Link table:
UniqueID CustID FlagID
=============================== 1 123 333
2 123 444
3 123 222
4 987 444
5 987 222
6 567 111
7 567 222
My issue is that I want to be able to locate Customers who have ALL of
the passed Flags associated with them, I do not know how many Flags
will be passed (and there are other search parameters passed as well -
but this is the piece that is giving me trouble, though I am sure it
is simple!)
For example, I want to return CustID where exists FlagID 222 AND 444.
Based on the above data it should return CustID 123 and 987, but not
567.
Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
this does not give me the results I want.
Any ideas would be appreciated!
Thanks,
AKThis might help.
SELECT COUNT(distinct FlagID)
FROM Customer_Flag_Link
WHERE FlagID IN (222,444)
AND Customer = 'Ralph'
HAVING COUNT(distinct FlagID) = 2
The number of items in the IN clause is what is used in the HAVING
test. Of course this could be written as an EXISTS subquery,
correlated on Customer.
Roy Harvey
Beacon Falls, CT
On Thu, 21 Jun 2007 10:50:45 -0700, aklein <abklein@.optonline.net>
wrote:
>Using SQL Server 2000...
>I have a front end that provides the user with a 'search engine' to
>pass search parameters. The stored procedure it calls joins multiple
>tables/views to return the proper result.
>I am running into a problem that I solved in the interface using code
>(that takes WAY too long), but I know there must be a way to have SQL
>Server do the work using T-SQL... as this seems a very simple issue.
>The following is just a snippet of the pertinent information:
>Assume I have a main Customer table with a unique CustID field.
>I have another table of descriptive Flags with a unique FlagID field.
>A third table Customer_Flag_Link has a unique ID field and contains 2
>columns, the CustID and the FlagID.
>Obvioulsy, the role of this 3rd table is to be able to assign multiple
>Flags to each Customer.
>Now assume I have the following data in the Customer_Flag_Link table:
>
>UniqueID CustID FlagID
>===============================>1 123 333
>2 123 444
>3 123 222
>4 987 444
>5 987 222
>6 567 111
>7 567 222
>My issue is that I want to be able to locate Customers who have ALL of
>the passed Flags associated with them, I do not know how many Flags
>will be passed (and there are other search parameters passed as well -
>but this is the piece that is giving me trouble, though I am sure it
>is simple!)
>For example, I want to return CustID where exists FlagID 222 AND 444.
>Based on the above data it should return CustID 123 and 987, but not
>567.
>Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
>this does not give me the results I want.
>Any ideas would be appreciated!
>Thanks,
>AK|||Hmmmm...
I have to see how to stick that idea into the larger procedure... but
it gives me a starting point.
Thanks for the idea!
AK
I have a front end that provides the user with a 'search engine' to
pass search parameters. The stored procedure it calls joins multiple
tables/views to return the proper result.
I am running into a problem that I solved in the interface using code
(that takes WAY too long), but I know there must be a way to have SQL
Server do the work using T-SQL... as this seems a very simple issue.
The following is just a snippet of the pertinent information:
Assume I have a main Customer table with a unique CustID field.
I have another table of descriptive Flags with a unique FlagID field.
A third table Customer_Flag_Link has a unique ID field and contains 2
columns, the CustID and the FlagID.
Obvioulsy, the role of this 3rd table is to be able to assign multiple
Flags to each Customer.
Now assume I have the following data in the Customer_Flag_Link table:
UniqueID CustID FlagID
=============================== 1 123 333
2 123 444
3 123 222
4 987 444
5 987 222
6 567 111
7 567 222
My issue is that I want to be able to locate Customers who have ALL of
the passed Flags associated with them, I do not know how many Flags
will be passed (and there are other search parameters passed as well -
but this is the piece that is giving me trouble, though I am sure it
is simple!)
For example, I want to return CustID where exists FlagID 222 AND 444.
Based on the above data it should return CustID 123 and 987, but not
567.
Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
this does not give me the results I want.
Any ideas would be appreciated!
Thanks,
AKThis might help.
SELECT COUNT(distinct FlagID)
FROM Customer_Flag_Link
WHERE FlagID IN (222,444)
AND Customer = 'Ralph'
HAVING COUNT(distinct FlagID) = 2
The number of items in the IN clause is what is used in the HAVING
test. Of course this could be written as an EXISTS subquery,
correlated on Customer.
Roy Harvey
Beacon Falls, CT
On Thu, 21 Jun 2007 10:50:45 -0700, aklein <abklein@.optonline.net>
wrote:
>Using SQL Server 2000...
>I have a front end that provides the user with a 'search engine' to
>pass search parameters. The stored procedure it calls joins multiple
>tables/views to return the proper result.
>I am running into a problem that I solved in the interface using code
>(that takes WAY too long), but I know there must be a way to have SQL
>Server do the work using T-SQL... as this seems a very simple issue.
>The following is just a snippet of the pertinent information:
>Assume I have a main Customer table with a unique CustID field.
>I have another table of descriptive Flags with a unique FlagID field.
>A third table Customer_Flag_Link has a unique ID field and contains 2
>columns, the CustID and the FlagID.
>Obvioulsy, the role of this 3rd table is to be able to assign multiple
>Flags to each Customer.
>Now assume I have the following data in the Customer_Flag_Link table:
>
>UniqueID CustID FlagID
>===============================>1 123 333
>2 123 444
>3 123 222
>4 987 444
>5 987 222
>6 567 111
>7 567 222
>My issue is that I want to be able to locate Customers who have ALL of
>the passed Flags associated with them, I do not know how many Flags
>will be passed (and there are other search parameters passed as well -
>but this is the piece that is giving me trouble, though I am sure it
>is simple!)
>For example, I want to return CustID where exists FlagID 222 AND 444.
>Based on the above data it should return CustID 123 and 987, but not
>567.
>Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
>this does not give me the results I want.
>Any ideas would be appreciated!
>Thanks,
>AK|||Hmmmm...
I have to see how to stick that idea into the larger procedure... but
it gives me a starting point.
Thanks for the idea!
AK
Locate records that meet ALL the requirements using IN or EXIST? Help?
Using SQL Server 2000...
I have a front end that provides the user with a 'search engine' to
pass search parameters. The stored procedure it calls joins multiple
tables/views to return the proper result.
I am running into a problem that I solved in the interface using code
(that takes WAY too long), but I know there must be a way to have SQL
Server do the work using T-SQL... as this seems a very simple issue.
The following is just a snippet of the pertinent information:
Assume I have a main Customer table with a unique CustID field.
I have another table of descriptive Flags with a unique FlagID field.
A third table Customer_Flag_Link has a unique ID field and contains 2
columns, the CustID and the FlagID.
Obvioulsy, the role of this 3rd table is to be able to assign multiple
Flags to each Customer.
Now assume I have the following data in the Customer_Flag_Link table:
UniqueID CustID FlagID
===============================
1 123 333
2 123 444
3 123 222
4 987 444
5 987 222
6 567 111
7 567 222
My issue is that I want to be able to locate Customers who have ALL of
the passed Flags associated with them, I do not know how many Flags
will be passed (and there are other search parameters passed as well -
but this is the piece that is giving me trouble, though I am sure it
is simple!)
For example, I want to return CustID where exists FlagID 222 AND 444.
Based on the above data it should return CustID 123 and 987, but not
567.
Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
this does not give me the results I want.
Any ideas would be appreciated!
Thanks,
AKThis might help.
SELECT COUNT(distinct FlagID)
FROM Customer_Flag_Link
WHERE FlagID IN (222,444)
AND Customer = 'Ralph'
HAVING COUNT(distinct FlagID) = 2
The number of items in the IN clause is what is used in the HAVING
test. Of course this could be written as an EXISTS subquery,
correlated on Customer.
Roy Harvey
Beacon Falls, CT
On Thu, 21 Jun 2007 10:50:45 -0700, aklein <abklein@.optonline.net>
wrote:
>Using SQL Server 2000...
>I have a front end that provides the user with a 'search engine' to
>pass search parameters. The stored procedure it calls joins multiple
>tables/views to return the proper result.
>I am running into a problem that I solved in the interface using code
>(that takes WAY too long), but I know there must be a way to have SQL
>Server do the work using T-SQL... as this seems a very simple issue.
>The following is just a snippet of the pertinent information:
>Assume I have a main Customer table with a unique CustID field.
>I have another table of descriptive Flags with a unique FlagID field.
>A third table Customer_Flag_Link has a unique ID field and contains 2
>columns, the CustID and the FlagID.
>Obvioulsy, the role of this 3rd table is to be able to assign multiple
>Flags to each Customer.
>Now assume I have the following data in the Customer_Flag_Link table:
>
>UniqueID CustID FlagID
>===============================
>1 123 333
>2 123 444
>3 123 222
>4 987 444
>5 987 222
>6 567 111
>7 567 222
>My issue is that I want to be able to locate Customers who have ALL of
>the passed Flags associated with them, I do not know how many Flags
>will be passed (and there are other search parameters passed as well -
>but this is the piece that is giving me trouble, though I am sure it
>is simple!)
>For example, I want to return CustID where exists FlagID 222 AND 444.
>Based on the above data it should return CustID 123 and 987, but not
>567.
>Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
>this does not give me the results I want.
>Any ideas would be appreciated!
>Thanks,
>AK|||Hmmmm...
I have to see how to stick that idea into the larger procedure... but
it gives me a starting point.
Thanks for the idea!
AK
I have a front end that provides the user with a 'search engine' to
pass search parameters. The stored procedure it calls joins multiple
tables/views to return the proper result.
I am running into a problem that I solved in the interface using code
(that takes WAY too long), but I know there must be a way to have SQL
Server do the work using T-SQL... as this seems a very simple issue.
The following is just a snippet of the pertinent information:
Assume I have a main Customer table with a unique CustID field.
I have another table of descriptive Flags with a unique FlagID field.
A third table Customer_Flag_Link has a unique ID field and contains 2
columns, the CustID and the FlagID.
Obvioulsy, the role of this 3rd table is to be able to assign multiple
Flags to each Customer.
Now assume I have the following data in the Customer_Flag_Link table:
UniqueID CustID FlagID
===============================
1 123 333
2 123 444
3 123 222
4 987 444
5 987 222
6 567 111
7 567 222
My issue is that I want to be able to locate Customers who have ALL of
the passed Flags associated with them, I do not know how many Flags
will be passed (and there are other search parameters passed as well -
but this is the piece that is giving me trouble, though I am sure it
is simple!)
For example, I want to return CustID where exists FlagID 222 AND 444.
Based on the above data it should return CustID 123 and 987, but not
567.
Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
this does not give me the results I want.
Any ideas would be appreciated!
Thanks,
AKThis might help.
SELECT COUNT(distinct FlagID)
FROM Customer_Flag_Link
WHERE FlagID IN (222,444)
AND Customer = 'Ralph'
HAVING COUNT(distinct FlagID) = 2
The number of items in the IN clause is what is used in the HAVING
test. Of course this could be written as an EXISTS subquery,
correlated on Customer.
Roy Harvey
Beacon Falls, CT
On Thu, 21 Jun 2007 10:50:45 -0700, aklein <abklein@.optonline.net>
wrote:
>Using SQL Server 2000...
>I have a front end that provides the user with a 'search engine' to
>pass search parameters. The stored procedure it calls joins multiple
>tables/views to return the proper result.
>I am running into a problem that I solved in the interface using code
>(that takes WAY too long), but I know there must be a way to have SQL
>Server do the work using T-SQL... as this seems a very simple issue.
>The following is just a snippet of the pertinent information:
>Assume I have a main Customer table with a unique CustID field.
>I have another table of descriptive Flags with a unique FlagID field.
>A third table Customer_Flag_Link has a unique ID field and contains 2
>columns, the CustID and the FlagID.
>Obvioulsy, the role of this 3rd table is to be able to assign multiple
>Flags to each Customer.
>Now assume I have the following data in the Customer_Flag_Link table:
>
>UniqueID CustID FlagID
>===============================
>1 123 333
>2 123 444
>3 123 222
>4 987 444
>5 987 222
>6 567 111
>7 567 222
>My issue is that I want to be able to locate Customers who have ALL of
>the passed Flags associated with them, I do not know how many Flags
>will be passed (and there are other search parameters passed as well -
>but this is the piece that is giving me trouble, though I am sure it
>is simple!)
>For example, I want to return CustID where exists FlagID 222 AND 444.
>Based on the above data it should return CustID 123 and 987, but not
>567.
>Currently, I use the IN operator (ie: FlagID IN (222,444)) but clearly
>this does not give me the results I want.
>Any ideas would be appreciated!
>Thanks,
>AK|||Hmmmm...
I have to see how to stick that idea into the larger procedure... but
it gives me a starting point.
Thanks for the idea!
AK
Locate information
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S
See if this helps:
http://vyaskn.tripod.com/search_all_...all_tables.htm
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Leandro Loureiro dos Santos" <nao@.falo.com.vc> wrote in message
news:%234kyqLnPEHA.3660@.TK2MSFTNGP11.phx.gbl...
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S
See if this helps:
http://vyaskn.tripod.com/search_all_...all_tables.htm
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Leandro Loureiro dos Santos" <nao@.falo.com.vc> wrote in message
news:%234kyqLnPEHA.3660@.TK2MSFTNGP11.phx.gbl...
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S
Locate information
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L SSee if this helps:
http://vyaskn.tripod.com/search_all..._all_tables.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Leandro Loureiro dos Santos" <nao@.falo.com.vc> wrote in message
news:%234kyqLnPEHA.3660@.TK2MSFTNGP11.phx.gbl...
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L SSee if this helps:
http://vyaskn.tripod.com/search_all..._all_tables.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Leandro Loureiro dos Santos" <nao@.falo.com.vc> wrote in message
news:%234kyqLnPEHA.3660@.TK2MSFTNGP11.phx.gbl...
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S
Locate information
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L SSee if this helps:
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Leandro Loureiro dos Santos" <nao@.falo.com.vc> wrote in message
news:%234kyqLnPEHA.3660@.TK2MSFTNGP11.phx.gbl...
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L SSee if this helps:
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Leandro Loureiro dos Santos" <nao@.falo.com.vc> wrote in message
news:%234kyqLnPEHA.3660@.TK2MSFTNGP11.phx.gbl...
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S
Locate Database Object Given The Page
Hi Folks,
Getting the following error after a DBCC CHECKDB
Server: Msg 8906, Level 16, State 1, Line 1
Page (3:15010) in database ID 9 is allocated in the SGAM (3:3) and PFS (3:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Trying to located the object that the allocation has gone to pot over.
Any quick way to resolve a datbase object using a page ID?
Thank In Advancewhoops. not enough coffee.|||"database ID 9" relates to the the entry in master.dbo.sysdatabases
I need to know what object within this database the page is allocated to.
Thanks
Getting the following error after a DBCC CHECKDB
Server: Msg 8906, Level 16, State 1, Line 1
Page (3:15010) in database ID 9 is allocated in the SGAM (3:3) and PFS (3:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Trying to located the object that the allocation has gone to pot over.
Any quick way to resolve a datbase object using a page ID?
Thank In Advancewhoops. not enough coffee.|||"database ID 9" relates to the the entry in master.dbo.sysdatabases
I need to know what object within this database the page is allocated to.
Thanks
Locate Covered Indexes on Tables
I am looking for the stored procedure that have the covered indexes for
several indexes in my database.
Is there a script or way to determine the which stored procedures correspond
to the covered indexes?
Thank You,
Joe
Let me understand you. COVERING indexes are created on columns not on stored
procedures.
Can you elaborate a little bit what you are trying to accomplish?
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:D3FE0DDD-C12B-49EF-A02A-FFC8AA751E53@.microsoft.com...
> I am looking for the stored procedure that have the covered indexes for
> several indexes in my database.
> Is there a script or way to determine the which stored procedures
> correspond
> to the covered indexes?
> Thank You,
several indexes in my database.
Is there a script or way to determine the which stored procedures correspond
to the covered indexes?
Thank You,
Joe
Let me understand you. COVERING indexes are created on columns not on stored
procedures.
Can you elaborate a little bit what you are trying to accomplish?
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:D3FE0DDD-C12B-49EF-A02A-FFC8AA751E53@.microsoft.com...
> I am looking for the stored procedure that have the covered indexes for
> several indexes in my database.
> Is there a script or way to determine the which stored procedures
> correspond
> to the covered indexes?
> Thank You,
Locate Covered Indexes on Tables
I am looking for the stored procedure that have the covered indexes for
several indexes in my database.
Is there a script or way to determine the which stored procedures correspond
to the covered indexes?
Thank You,Joe
Let me understand you. COVERING indexes are created on columns not on stored
procedures.
Can you elaborate a little bit what you are trying to accomplish?
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:D3FE0DDD-C12B-49EF-A02A-FFC8AA751E53@.microsoft.com...
> I am looking for the stored procedure that have the covered indexes for
> several indexes in my database.
> Is there a script or way to determine the which stored procedures
> correspond
> to the covered indexes?
> Thank You,
several indexes in my database.
Is there a script or way to determine the which stored procedures correspond
to the covered indexes?
Thank You,Joe
Let me understand you. COVERING indexes are created on columns not on stored
procedures.
Can you elaborate a little bit what you are trying to accomplish?
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:D3FE0DDD-C12B-49EF-A02A-FFC8AA751E53@.microsoft.com...
> I am looking for the stored procedure that have the covered indexes for
> several indexes in my database.
> Is there a script or way to determine the which stored procedures
> correspond
> to the covered indexes?
> Thank You,
Locate Covered Indexes on Tables
I am looking for the stored procedure that have the covered indexes for
several indexes in my database.
Is there a script or way to determine the which stored procedures correspond
to the covered indexes?
Thank You,Joe
Let me understand you. COVERING indexes are created on columns not on stored
procedures.
Can you elaborate a little bit what you are trying to accomplish?
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:D3FE0DDD-C12B-49EF-A02A-FFC8AA751E53@.microsoft.com...
> I am looking for the stored procedure that have the covered indexes for
> several indexes in my database.
> Is there a script or way to determine the which stored procedures
> correspond
> to the covered indexes?
> Thank You,
several indexes in my database.
Is there a script or way to determine the which stored procedures correspond
to the covered indexes?
Thank You,Joe
Let me understand you. COVERING indexes are created on columns not on stored
procedures.
Can you elaborate a little bit what you are trying to accomplish?
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:D3FE0DDD-C12B-49EF-A02A-FFC8AA751E53@.microsoft.com...
> I am looking for the stored procedure that have the covered indexes for
> several indexes in my database.
> Is there a script or way to determine the which stored procedures
> correspond
> to the covered indexes?
> Thank You,
Locate backup file - can't see other drives
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!
It could be that your SQL Server is clustered and you're seeing only the
disks on which SQL Server has a dependency.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183726609.006262.23360@.q75g2000hsh.googlegro ups.com...
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!
|||Hi
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
Normally the dialog would default to a location and you could browse from
there depending on your permissions to see the directories. You could try
typing the path in yourself. With a cluster you would only see the drives
that have been tagged as cluster resources.
John
|||Are the other drives in question local? I
Anthony E. Castro - MCDBA
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
|||Wow, bullseye!
It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegro ups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegr oups.com...
Wow, bullseye! It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegro ups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!
It could be that your SQL Server is clustered and you're seeing only the
disks on which SQL Server has a dependency.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183726609.006262.23360@.q75g2000hsh.googlegro ups.com...
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!
|||Hi
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
Normally the dialog would default to a location and you could browse from
there depending on your permissions to see the directories. You could try
typing the path in yourself. With a cluster you would only see the drives
that have been tagged as cluster resources.
John
|||Are the other drives in question local? I
Anthony E. Castro - MCDBA
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
|||Wow, bullseye!
It's a two node cluster where only the E drive is inthe resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegro ups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegr oups.com...
Wow, bullseye!
It's a two node cluster where only the E drive is inthe resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegro ups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
Locate backup file - can't see other drives
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!It could be that your SQL Server is clustered and you're seeing only the
disks on which SQL Server has a dependency.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!|||Hi
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
Normally the dialog would default to a location and you could browse from
there depending on your permissions to see the directories. You could try
typing the path in yourself. With a cluster you would only see the drives
that have been tagged as cluster resources.
John|||Are the other drives in question local? I
--
Anthony E. Castro - MCDBA
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>|||Wow, bullseye! It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegroups.com...
Wow, bullseye! It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!It could be that your SQL Server is clustered and you're seeing only the
disks on which SQL Server has a dependency.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!|||Hi
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
Normally the dialog would default to a location and you could browse from
there depending on your permissions to see the directories. You could try
typing the path in yourself. With a cluster you would only see the drives
that have been tagged as cluster resources.
John|||Are the other drives in question local? I
--
Anthony E. Castro - MCDBA
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>|||Wow, bullseye!
It's a two node cluster where only the E drive is inthe resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegroups.com...
Wow, bullseye!
It's a two node cluster where only the E drive is inthe resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
Locate backup file - can't see other drives
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!It could be that your SQL Server is clustered and you're seeing only the
disks on which SQL Server has a dependency.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!|||Hi
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
Normally the dialog would default to a location and you could browse from
there depending on your permissions to see the directories. You could try
typing the path in yourself. With a cluster you would only see the drives
that have been tagged as cluster resources.
John|||Are the other drives in question local? I
--
Anthony E. Castro - MCDBA
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>|||Wow, bullseye! :) It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegroups.com...
Wow, bullseye! :) It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!It could be that your SQL Server is clustered and you're seeing only the
disks on which SQL Server has a dependency.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!|||Hi
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
Normally the dialog would default to a location and you could browse from
there depending on your permissions to see the directories. You could try
typing the path in yourself. With a cluster you would only see the drives
that have been tagged as cluster resources.
John|||Are the other drives in question local? I
--
Anthony E. Castro - MCDBA
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>|||Wow, bullseye! :) It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegroups.com...
Wow, bullseye! :) It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
Subscribe to:
Posts (Atom)