Hi,
After a power outage (and UPS failure), my boss's SQL Server 2000 won't
start (or crashes quickly or something). We don't have any backups, as it's
a test server. Is there a way to import the database files into a new SQL
installation? By "installation," I mean either a re-installed SS, a second
installation on the same PC, or maybe even on another PC. In another words,
given only the files sitting on the harddrive, is there a way to "import"
the DBs in those files into SS?
Sp_attach_db would probably be the answer, except it seems to require
running sp_detach_db...which I cannot do, as SS is not working.
Thanks in advance,
JayYou could try sp_attach_single_file_db, though I believe that may require a
successful detach as well.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jay" <twentycavities@.hotmail.com> wrote in message
news:g2MCb.17882$Vg3.15076@.fe3.columbus.rr.com...
> Hi,
> After a power outage (and UPS failure), my boss's SQL Server 2000 won't
> start (or crashes quickly or something). We don't have any backups, as
it's
> a test server. Is there a way to import the database files into a new SQL
> installation? By "installation," I mean either a re-installed SS, a second
> installation on the same PC, or maybe even on another PC. In another
words,
> given only the files sitting on the harddrive, is there a way to "import"
> the DBs in those files into SS?
> Sp_attach_db would probably be the answer, except it seems to require
> running sp_detach_db...which I cannot do, as SS is not working.
>
> Thanks in advance,
> Jay
>
>|||Jay,
I dont see why you could not simply copy the MDF and LDF
files to another machine (or put in a safe place). Then
fix the issue with SQL2K not starting.
You should then be able to attache the database and log
file again via Enterprise Manager (right-click on
Databases/All tasks/Attach Database...).
Ron
>--Original Message--
>Hi,
>After a power outage (and UPS failure), my boss's SQL
Server 2000 won't
>start (or crashes quickly or something). We don't have
any backups, as it's
>a test server. Is there a way to import the database
files into a new SQL
>installation? By "installation," I mean either a re-
installed SS, a second
>installation on the same PC, or maybe even on another
PC. In another words,
>given only the files sitting on the harddrive, is there
a way to "import"
>the DBs in those files into SS?
>Sp_attach_db would probably be the answer, except it
seems to require
>running sp_detach_db...which I cannot do, as SS is not
working.
>
>Thanks in advance,
>Jay
>
>
>.
>|||I believe all he has to do is attach the databases. Find the old =databases and attach them. I have done this before and in fact will be =doing it again shortly. Attach through the GUI in your other SQL =Manager.
-- George Hester
__________________________________
"Jay" <twentycavities@.hotmail.com> wrote in message =news:g2MCb.17882$Vg3.15076@.fe3.columbus.rr.com...
> Hi,
> After a power outage (and UPS failure), my boss's SQL Server 2000 =won't
> start (or crashes quickly or something). We don't have any backups, as =it's
> a test server. Is there a way to import the database files into a new =SQL
> installation? By "installation," I mean either a re-installed SS, a =second
> installation on the same PC, or maybe even on another PC. In another =words,
> given only the files sitting on the harddrive, is there a way to ="import"
> the DBs in those files into SS?
> > Sp_attach_db would probably be the answer, except it seems to require
> running sp_detach_db...which I cannot do, as SS is not working.
> > > Thanks in advance,
> > Jay
> > > >|||>> I believe all he has to do is attach the databases.
This works fine when the databases have been detached successfully.
However, it's not always so easy when the "detach" wasn't clean (as in Jay's
case).
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Well I have done it with no detaching. In fact I have to do it again =shortly. The Windows Server crashed and there is no reliable way I know =of to get SQL Server out of there functional and I need the databases. =So as I do it I'll probably remember the corners I had to cut to get it =to work. If he is interested I'll describe the steps here.
-- George Hester
__________________________________
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message =news:uGW9ANwwDHA.3428@.TK2MSFTNGP11.phx.gbl...
> >> I believe all he has to do is attach the databases.
> > This works fine when the databases have been detached successfully.
> However, it's not always so easy when the "detach" wasn't clean (as in =Jay's
> case).
> > -- > Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
> >|||> Well I have done it with no detaching.
I think you have been lucky, and this is certainly not guaranteed to work.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
Showing posts with label newb. Show all posts
Showing posts with label newb. Show all posts
Monday, February 20, 2012
NEWB: Moving DBs to new install of SQL Serv. w/o sp_detach_db
Hi,
After a power outage (and UPS failure), my boss's SQL Server 2000 won't
start (or crashes quickly or something). We don't have any backups, as it's
a test server. Is there a way to import the database files into a new SQL
installation? By "installation," I mean either a re-installed SS, a second
installation on the same PC, or maybe even on another PC. In another words,
given only the files sitting on the harddrive, is there a way to "import"
the DBs in those files into SS?
After a power outage (and UPS failure), my boss's SQL Server 2000 won't
start (or crashes quickly or something). We don't have any backups, as it's
a test server. Is there a way to import the database files into a new SQL
installation? By "installation," I mean either a re-installed SS, a second
installation on the same PC, or maybe even on another PC. In another words,
given only the files sitting on the harddrive, is there a way to "import"
the DBs in those files into SS?
Sp_attach_db would probably be the answer, except it seems to require
running sp_detach_db...which I cannot do, as SS is not working.
Thanks in advance,
Jay[posted and mailed, please reply in news]
Jay (twentycavities@.hotmail.com) writes:
> After a power outage (and UPS failure), my boss's SQL Server 2000 won't
> start (or crashes quickly or something). We don't have any backups, as
> it's a test server. Is there a way to import the database files into a
> new SQL installation? By "installation," I mean either a re-installed
> SS, a second installation on the same PC, or maybe even on another PC.
> In another words, given only the files sitting on the harddrive, is
> there a way to "import" the DBs in those files into SS?
> Sp_attach_db would probably be the answer, except it seems to require
> running sp_detach_db...which I cannot do, as SS is not working.
sp_attach_db would indeed be the first thing to try. Since you did
not detach the database cleanly, it may not work. But it's worth to
give it a try. You most likely need both the data files and the log
files.
The other option to try is sp_attach_single_file_db. but if
sp_attach_db does not work, I would not place my bets on this one.
If that files, there is yet a way, but I wiill not post this method
here as it is too dangerous. Suffice to say that while you will be
able to access the database file this, you will get it exactly in
the state it was in at the time of the crash. So if this was a state
of inconsistency in the midst of a transaction, you have a mess of a
database.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||In article <mHLCb.17818$Vg3.10491@.fe3.columbus.rr.com>,
twentycavities@.hotmail.com says...
> Sp_attach_db would probably be the answer, except it seems to require
> running sp_detach_db...which I cannot do, as SS is not working.
I got hung up on the same thing, but as Erland points out, it will
probably work. It did for me.
-- Rick
Newb: Managing multiple queries
I am currently using enterprise manager to run multiple queries on a
single table in a DB. I refresh these queries every few minutes. Due
to the huge number of them I was looking for a better way (or should I
just say "a way") to manage/save these queries so I can recall them
easier/faster for monitoring purposes. Suggestions?
Are there examples of "script files"? I have a few files that are used
for creating databases and tables, but somehow I think there is more
potential in using scripts.
single table in a DB. I refresh these queries every few minutes. Due
to the huge number of them I was looking for a better way (or should I
just say "a way") to manage/save these queries so I can recall them
easier/faster for monitoring purposes. Suggestions?
TIA.Hi,
Maybe creating a stored procedure (or more, if the queries are logically
grouped) will help you. Then you would need just to execute the stored
procedures in Query Analyzer (which is the tool intended to run queries
anyway). Alternatively you can save the queries to a script file, and then
open and run in Query Analyzer.
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||On Thu, 6 Dec 2007 10:38:06 -0800 (PST), Akhenaten
<jonkokko@.gmail.comwrote:
If I understand you correctly you need an application (Access ADP, or
..NET) to call your queries based on a timer or a button click. SQL
Server tools alone are probably not going to do the trick.
-Tom.
Quote:
Originally Posted by
>I am currently using enterprise manager to run multiple queries on a
>single table in a DB. I refresh these queries every few minutes. Due
>to the huge number of them I was looking for a better way (or should I
>just say "a way") to manage/save these queries so I can recall them
>easier/faster for monitoring purposes. Suggestions?
>
>TIA.
Quote:
Originally Posted by
Hi,
>
Maybe creating a stored procedure (or more, if the queries are logically
grouped) will help you. Then you would need just to execute the stored
procedures in Query Analyzer (which is the tool intended to run queries
anyway). Alternatively you can save the queries to a script file, and then
open and run in Query Analyzer.
>
HTH,
>
Plamen Ratchevhttp://www.SQLStudio.com
Are there examples of "script files"? I have a few files that are used
for creating databases and tables, but somehow I think there is more
potential in using scripts.
Thanks|||Under "script files" I meant to save your frequently used SQL code to a
file, preferably with extension ".sql". Since you indicate you already save
your code to files, then you have your script files.
In SQL Server 2005, the SQL Server Management Studio adds a new capability
to organize scripts in projects (very similar to Visual Studio projects). It
is accessible via the File menu in SSMS (File -New - Project -SQL
Server Scripts template).
Script files are good because they can be easily added to a source control
system.
HTH,
Plamen Ratchev
http://www.SQLStudio.com
Newb with a serious Trigger question.
Ok I am stumped. I am a newbie in terms of triggers and procedures and am
used to writing inline sql statements , so here is my situation.
I have an audit table for all the updates , inserts and deletes throughout
one of my application database(SQL2005).
Whenever something happens a record gets inserted into this table(this was
all accomplished by an external dll coded somewhere else that i found on the
internet - and all this works fantastically.)
The problem i have is that after the insert into the audit table occurs, i
want to be able to do this...
have a second trigger for the insert on the audit table
this will go out using the Primary key of the edited table (eg. tasks) and
the table name (eg tasks_) and operation type (eg UPDATE< INSERT whatever)
and get these values that are now in the new audit table record.
then i want to use these values to dynamically select a created_By field
from say the tasks table and update the audit record with this new
created_By field.
the theory is that the dll works but puts dbo in for the user all the time,
so i want to go into the application side and grab the user who entered the
info and update the audit trail records.
Is this clear and concise or am i mumbling?
Any help would be vastly appreciated.
Thanks in advance,
COlinColin Smart (csmart@.nf.sympatico.ca) writes:
> I have an audit table for all the updates , inserts and deletes throughout
> one of my application database(SQL2005).
> Whenever something happens a record gets inserted into this table(this was
> all accomplished by an external dll coded somewhere else that i found on
> the internet - and all this works fantastically.)
> The problem i have is that after the insert into the audit table occurs, i
> want to be able to do this...
> have a second trigger for the insert on the audit table this will go out
> using the Primary key of the edited table (eg. tasks) and the table name
> (eg tasks_) and operation type (eg UPDATE< INSERT whatever) and get
> these values that are now in the new audit table record.
> then i want to use these values to dynamically select a created_By field
> from say the tasks table and update the audit record with this new
> created_By field.
> the theory is that the dll works but puts dbo in for the user all the
> time, so i want to go into the application side and grab the user who
> entered the info and update the audit trail records.
From exactly where is this DLL invoked?
This sounds like a solution for SQL 2000 or earlier. That trigger
would be messy to code. It sounds as if the DLL runs as dbo, in
which case you could use dynamic SQL. But if any of the tables does
not have a Created_by column, it will bloe up at run-time. A better
solution would be to pass the DLL the value of original_login() somehow.
(On SQL 2005 you should use original_login(), rather than SYSTEM_USER.)
On SQL 2005, the xml column can be very good for auditing. It depends
exactly what you will use the audit data for, but if you are not going
to run any searches on other data than the table name and key values,
you can use an xml column. The nice thing is that you can do a
SELECT ... FROM inserted FOR XML, and the triggers can be quite generic.
Even nicer is that you can make an entire generic program that reads
the log table, and presents the differences between two log records.
If you insert directly into the auditlog, there is not any problem of
retrieving the current user.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
used to writing inline sql statements , so here is my situation.
I have an audit table for all the updates , inserts and deletes throughout
one of my application database(SQL2005).
Whenever something happens a record gets inserted into this table(this was
all accomplished by an external dll coded somewhere else that i found on the
internet - and all this works fantastically.)
The problem i have is that after the insert into the audit table occurs, i
want to be able to do this...
have a second trigger for the insert on the audit table
this will go out using the Primary key of the edited table (eg. tasks) and
the table name (eg tasks_) and operation type (eg UPDATE< INSERT whatever)
and get these values that are now in the new audit table record.
then i want to use these values to dynamically select a created_By field
from say the tasks table and update the audit record with this new
created_By field.
the theory is that the dll works but puts dbo in for the user all the time,
so i want to go into the application side and grab the user who entered the
info and update the audit trail records.
Is this clear and concise or am i mumbling?
Any help would be vastly appreciated.
Thanks in advance,
COlinColin Smart (csmart@.nf.sympatico.ca) writes:
> I have an audit table for all the updates , inserts and deletes throughout
> one of my application database(SQL2005).
> Whenever something happens a record gets inserted into this table(this was
> all accomplished by an external dll coded somewhere else that i found on
> the internet - and all this works fantastically.)
> The problem i have is that after the insert into the audit table occurs, i
> want to be able to do this...
> have a second trigger for the insert on the audit table this will go out
> using the Primary key of the edited table (eg. tasks) and the table name
> (eg tasks_) and operation type (eg UPDATE< INSERT whatever) and get
> these values that are now in the new audit table record.
> then i want to use these values to dynamically select a created_By field
> from say the tasks table and update the audit record with this new
> created_By field.
> the theory is that the dll works but puts dbo in for the user all the
> time, so i want to go into the application side and grab the user who
> entered the info and update the audit trail records.
From exactly where is this DLL invoked?
This sounds like a solution for SQL 2000 or earlier. That trigger
would be messy to code. It sounds as if the DLL runs as dbo, in
which case you could use dynamic SQL. But if any of the tables does
not have a Created_by column, it will bloe up at run-time. A better
solution would be to pass the DLL the value of original_login() somehow.
(On SQL 2005 you should use original_login(), rather than SYSTEM_USER.)
On SQL 2005, the xml column can be very good for auditing. It depends
exactly what you will use the audit data for, but if you are not going
to run any searches on other data than the table name and key values,
you can use an xml column. The nice thing is that you can do a
SELECT ... FROM inserted FOR XML, and the triggers can be quite generic.
Even nicer is that you can make an entire generic program that reads
the log table, and presents the differences between two log records.
If you insert directly into the auditlog, there is not any problem of
retrieving the current user.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Newb question regarding cluster load balancing
Hello to all,
I am currently working on creating a Windows 2003 server cluster (3 nodes)
with the intent that it serve our web app which requires multiple SQL
databases. The question I have is this: How can I configure load balancing
for this? It seems that clustering services only allows 1 of the nodes to
access the DB at any given time (which is logical). If this is true, how
will I be able to leverage the processing power of the other two nodes if
they are idle while the node that is hosting the DB does all the work?
Any help would be appreciated.
Michael
You can install multiple instances of SQL Server on a failover cluster. You
cannot natively load-balance the workload between these multiple instances.
They act as independent SQL servers. SQL Clustering is a failover
technology and does not natively load balance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Michael Weyant" <mweyant@.themarlincompany.com> wrote in message
news:OshvlPrGGHA.312@.TK2MSFTNGP09.phx.gbl...
> Hello to all,
> I am currently working on creating a Windows 2003 server cluster (3 nodes)
> with the intent that it serve our web app which requires multiple SQL
> databases. The question I have is this: How can I configure load balancing
> for this? It seems that clustering services only allows 1 of the nodes to
> access the DB at any given time (which is logical). If this is true, how
> will I be able to leverage the processing power of the other two nodes if
> they are idle while the node that is hosting the DB does all the work?
> Any help would be appreciated.
> Michael
>
|||Thanks Geoff for the information. I thought as much but hoped otherwise.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:e9dbmVrGGHA.3856@.TK2MSFTNGP12.phx.gbl...
> You can install multiple instances of SQL Server on a failover cluster.
> You cannot natively load-balance the workload between these multiple
> instances. They act as independent SQL servers. SQL Clustering is a
> failover technology and does not natively load balance.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Michael Weyant" <mweyant@.themarlincompany.com> wrote in message
> news:OshvlPrGGHA.312@.TK2MSFTNGP09.phx.gbl...
>
I am currently working on creating a Windows 2003 server cluster (3 nodes)
with the intent that it serve our web app which requires multiple SQL
databases. The question I have is this: How can I configure load balancing
for this? It seems that clustering services only allows 1 of the nodes to
access the DB at any given time (which is logical). If this is true, how
will I be able to leverage the processing power of the other two nodes if
they are idle while the node that is hosting the DB does all the work?
Any help would be appreciated.
Michael
You can install multiple instances of SQL Server on a failover cluster. You
cannot natively load-balance the workload between these multiple instances.
They act as independent SQL servers. SQL Clustering is a failover
technology and does not natively load balance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Michael Weyant" <mweyant@.themarlincompany.com> wrote in message
news:OshvlPrGGHA.312@.TK2MSFTNGP09.phx.gbl...
> Hello to all,
> I am currently working on creating a Windows 2003 server cluster (3 nodes)
> with the intent that it serve our web app which requires multiple SQL
> databases. The question I have is this: How can I configure load balancing
> for this? It seems that clustering services only allows 1 of the nodes to
> access the DB at any given time (which is logical). If this is true, how
> will I be able to leverage the processing power of the other two nodes if
> they are idle while the node that is hosting the DB does all the work?
> Any help would be appreciated.
> Michael
>
|||Thanks Geoff for the information. I thought as much but hoped otherwise.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:e9dbmVrGGHA.3856@.TK2MSFTNGP12.phx.gbl...
> You can install multiple instances of SQL Server on a failover cluster.
> You cannot natively load-balance the workload between these multiple
> instances. They act as independent SQL servers. SQL Clustering is a
> failover technology and does not natively load balance.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Michael Weyant" <mweyant@.themarlincompany.com> wrote in message
> news:OshvlPrGGHA.312@.TK2MSFTNGP09.phx.gbl...
>
NEWB Question - Runs as a Service?
I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
installation. I have just installed MS SQL Server 2005 and SQL 2005 Server,
SP2. When I open the Management Studio, there are no servers to choose. I
can't make a server show up there! If the software is installed on my machine
(Windows Vista), is there a SQL server running in the background somewhere?
As a service? I don't see a service in the Services control panel. Do I need
to start the server somehow? I have looked everywhere for this information!
Help!SQL Server is comprised of several services. You may have installed the
client tools only. Go to Control Panel | Programs | Uninstall a Program
(used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
Select it and hit Change. You should be able to add the services you
missed.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> installation. I have just installed MS SQL Server 2005 and SQL 2005
> Server,
> SP2. When I open the Management Studio, there are no servers to choose. I
> can't make a server show up there! If the software is installed on my
> machine
> (Windows Vista), is there a SQL server running in the background
> somewhere?
> As a service? I don't see a service in the Services control panel. Do I
> need
> to start the server somehow? I have looked everywhere for this
> information!
> Help!|||Thank you! I figured something like that.
Well, I did as you suggested, but it looks like everything is already
installed. After I opened thecontrol panel, I selected SQL Server 2005 and
clicked on Change. Then I could choose SQL Server 2005 Instances (none have
been installed) or SQL Server 2005 common components (has a sub-button of
Workstation Components). I chose the latter, common components. Was that
right?
In the connectivity components, it looks like everything is already there:
management tools, business intellegence development studio, software
development kit, sqlxml client features, legacy components, and all the
"Documentattion, Samples, and Sample Databases".
Am I still missing something?! I am VERY GRATEFUL for your help!
azanna.
"Geoff N. Hiten" wrote:
> SQL Server is comprised of several services. You may have installed the
> client tools only. Go to Control Panel | Programs | Uninstall a Program
> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
> Select it and hit Change. You should be able to add the services you
> missed.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> > installation. I have just installed MS SQL Server 2005 and SQL 2005
> > Server,
> > SP2. When I open the Management Studio, there are no servers to choose. I
> > can't make a server show up there! If the software is installed on my
> > machine
> > (Windows Vista), is there a SQL server running in the background
> > somewhere?
> > As a service? I don't see a service in the Services control panel. Do I
> > need
> > to start the server somehow? I have looked everywhere for this
> > information!
> > Help!
>|||Instances are the SQL services. Common components is common across the
various SQL subsystems. Go back and install an instance. Default instance
should be what you need.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> Thank you! I figured something like that.
> Well, I did as you suggested, but it looks like everything is already
> installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> clicked on Change. Then I could choose SQL Server 2005 Instances (none
> have
> been installed) or SQL Server 2005 common components (has a sub-button of
> Workstation Components). I chose the latter, common components. Was that
> right?
> In the connectivity components, it looks like everything is already there:
> management tools, business intellegence development studio, software
> development kit, sqlxml client features, legacy components, and all the
> "Documentattion, Samples, and Sample Databases".
> Am I still missing something?! I am VERY GRATEFUL for your help!
> azanna.
> "Geoff N. Hiten" wrote:
>> SQL Server is comprised of several services. You may have installed the
>> client tools only. Go to Control Panel | Programs | Uninstall a Program
>> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
>> Select it and hit Change. You should be able to add the services you
>> missed.
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> > Server,
>> > SP2. When I open the Management Studio, there are no servers to choose.
>> > I
>> > can't make a server show up there! If the software is installed on my
>> > machine
>> > (Windows Vista), is there a SQL server running in the background
>> > somewhere?
>> > As a service? I don't see a service in the Services control panel. Do I
>> > need
>> > to start the server somehow? I have looked everywhere for this
>> > information!
>> > Help!
>>|||Here's what I get: "There are no items to show in this view." Wah!
"Ekrem Ã?nsoy" wrote:
> Will you open up SQL Server Configuration Manager from Configuration Tools
> and look for SQL Server services from SQL Server 2005 Services node?
> It would be good if you send us a list of those services listed in the SQL
> Server 2005 Services window.
> Also, tell us about their statuses (Running\Stopped)
> --
> Ekrem Ã?nsoy
> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
> MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
>
> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> > Thank you! I figured something like that.
> >
> > Well, I did as you suggested, but it looks like everything is already
> > installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
> > have
> > been installed) or SQL Server 2005 common components (has a sub-button of
> > Workstation Components). I chose the latter, common components. Was that
> > right?
> >
> > In the connectivity components, it looks like everything is already there:
> > management tools, business intellegence development studio, software
> > development kit, sqlxml client features, legacy components, and all the
> > "Documentattion, Samples, and Sample Databases".
> >
> > Am I still missing something?! I am VERY GRATEFUL for your help!
> >
> > azanna.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> SQL Server is comprised of several services. You may have installed the
> >> client tools only. Go to Control Panel | Programs | Uninstall a Program
> >> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
> >> Select it and hit Change. You should be able to add the services you
> >> missed.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior SQL Infrastructure Consultant
> >> Microsoft SQL Server MVP
> >>
> >>
> >>
> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
> >> > Server,
> >> > SP2. When I open the Management Studio, there are no servers to choose.
> >> > I
> >> > can't make a server show up there! If the software is installed on my
> >> > machine
> >> > (Windows Vista), is there a SQL server running in the background
> >> > somewhere?
> >> > As a service? I don't see a service in the Services control panel. Do I
> >> > need
> >> > to start the server somehow? I have looked everywhere for this
> >> > information!
> >> > Help!
> >>
> >>
>|||Hi, Geoff. Actually, I did try that too, but I apparently can't point to a
valid installation file. I downloaded and installed the SQL Server 2005
full-version trial. I did it two ways; I saved the image file (which doesn't
work for adding a component in the instance dialog) and I also just installed
the .exe that was the Download link. Neither one will let me install an
instance. When I use the Report button, it says that I do have a common
instance installed:
Workstation Components
[Version: 9.2.3042.00 Edition: Enterprise Evaluation Edition Patch
level: 9.2.3042 Language: English (United States)]
Thank you!
azanna.
"Geoff N. Hiten" wrote:
> Instances are the SQL services. Common components is common across the
> various SQL subsystems. Go back and install an instance. Default instance
> should be what you need.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> > Thank you! I figured something like that.
> >
> > Well, I did as you suggested, but it looks like everything is already
> > installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
> > have
> > been installed) or SQL Server 2005 common components (has a sub-button of
> > Workstation Components). I chose the latter, common components. Was that
> > right?
> >
> > In the connectivity components, it looks like everything is already there:
> > management tools, business intellegence development studio, software
> > development kit, sqlxml client features, legacy components, and all the
> > "Documentattion, Samples, and Sample Databases".
> >
> > Am I still missing something?! I am VERY GRATEFUL for your help!
> >
> > azanna.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> SQL Server is comprised of several services. You may have installed the
> >> client tools only. Go to Control Panel | Programs | Uninstall a Program
> >> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
> >> Select it and hit Change. You should be able to add the services you
> >> missed.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior SQL Infrastructure Consultant
> >> Microsoft SQL Server MVP
> >>
> >>
> >>
> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
> >> > Server,
> >> > SP2. When I open the Management Studio, there are no servers to choose.
> >> > I
> >> > can't make a server show up there! If the software is installed on my
> >> > machine
> >> > (Windows Vista), is there a SQL server running in the background
> >> > somewhere?
> >> > As a service? I don't see a service in the Services control panel. Do I
> >> > need
> >> > to start the server somehow? I have looked everywhere for this
> >> > information!
> >> > Help!
> >>
> >>
>|||Instance means SQL Service Instance. No other component of SQL is an
Instance.
Workstation components are not part of an instance, They are management
tools, documentation, examples, and config tools.
Unpack the image to a folder and point there when the installer wants the
install folder. You must select SQL Server Database Services (first item on
the Components to Install dialog box) if you want to install the SQL Server
engine.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:17D32179-E8F6-44E0-A67D-AE6F92921610@.microsoft.com...
> Hi, Geoff. Actually, I did try that too, but I apparently can't point to a
> valid installation file. I downloaded and installed the SQL Server 2005
> full-version trial. I did it two ways; I saved the image file (which
> doesn't
> work for adding a component in the instance dialog) and I also just
> installed
> the .exe that was the Download link. Neither one will let me install an
> instance. When I use the Report button, it says that I do have a common
> instance installed:
> Workstation Components
> [Version: 9.2.3042.00 Edition: Enterprise Evaluation Edition Patch
> level: 9.2.3042 Language: English (United States)]
> Thank you!
> azanna.
> "Geoff N. Hiten" wrote:
>> Instances are the SQL services. Common components is common across the
>> various SQL subsystems. Go back and install an instance. Default
>> instance
>> should be what you need.
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
>> > Thank you! I figured something like that.
>> >
>> > Well, I did as you suggested, but it looks like everything is already
>> > installed. After I opened thecontrol panel, I selected SQL Server 2005
>> > and
>> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
>> > have
>> > been installed) or SQL Server 2005 common components (has a sub-button
>> > of
>> > Workstation Components). I chose the latter, common components. Was
>> > that
>> > right?
>> >
>> > In the connectivity components, it looks like everything is already
>> > there:
>> > management tools, business intellegence development studio, software
>> > development kit, sqlxml client features, legacy components, and all the
>> > "Documentattion, Samples, and Sample Databases".
>> >
>> > Am I still missing something?! I am VERY GRATEFUL for your help!
>> >
>> > azanna.
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> SQL Server is comprised of several services. You may have installed
>> >> the
>> >> client tools only. Go to Control Panel | Programs | Uninstall a
>> >> Program
>> >> (used to be Add/Remove programs) and look for Microsoft SQL Server
>> >> 2005.
>> >> Select it and hit Change. You should be able to add the services you
>> >> missed.
>> >>
>> >> --
>> >> Geoff N. Hiten
>> >> Senior SQL Infrastructure Consultant
>> >> Microsoft SQL Server MVP
>> >>
>> >>
>> >>
>> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> >> > Server,
>> >> > SP2. When I open the Management Studio, there are no servers to
>> >> > choose.
>> >> > I
>> >> > can't make a server show up there! If the software is installed on
>> >> > my
>> >> > machine
>> >> > (Windows Vista), is there a SQL server running in the background
>> >> > somewhere?
>> >> > As a service? I don't see a service in the Services control panel.
>> >> > Do I
>> >> > need
>> >> > to start the server somehow? I have looked everywhere for this
>> >> > information!
>> >> > Help!
>> >>
>> >>
>>|||Will you open up SQL Server Configuration Manager from Configuration Tools
and look for SQL Server services from SQL Server 2005 Services node?
It would be good if you send us a list of those services listed in the SQL
Server 2005 Services window.
Also, tell us about their statuses (Running\Stopped)
--
Ekrem Ã?nsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> Thank you! I figured something like that.
> Well, I did as you suggested, but it looks like everything is already
> installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> clicked on Change. Then I could choose SQL Server 2005 Instances (none
> have
> been installed) or SQL Server 2005 common components (has a sub-button of
> Workstation Components). I chose the latter, common components. Was that
> right?
> In the connectivity components, it looks like everything is already there:
> management tools, business intellegence development studio, software
> development kit, sqlxml client features, legacy components, and all the
> "Documentattion, Samples, and Sample Databases".
> Am I still missing something?! I am VERY GRATEFUL for your help!
> azanna.
> "Geoff N. Hiten" wrote:
>> SQL Server is comprised of several services. You may have installed the
>> client tools only. Go to Control Panel | Programs | Uninstall a Program
>> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
>> Select it and hit Change. You should be able to add the services you
>> missed.
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> > Server,
>> > SP2. When I open the Management Studio, there are no servers to choose.
>> > I
>> > can't make a server show up there! If the software is installed on my
>> > machine
>> > (Windows Vista), is there a SQL server running in the background
>> > somewhere?
>> > As a service? I don't see a service in the Services control panel. Do I
>> > need
>> > to start the server somehow? I have looked everywhere for this
>> > information!
>> > Help!
>>|||It's obviously clear that you have no any installed SQL Server instance.
Will you try to start the SQL Server setup and try to install an instance?
Do not skip checking Database Engine from the Components to Install window
that will appear in setup process.
After the setup, go to Configuration Manager and look for SQL Server
services and tell us what happens.
--
Ekrem Ã?nsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:217AB314-58A5-4BA2-B9D8-48082526E886@.microsoft.com...
> Here's what I get: "There are no items to show in this view." Wah!
> "Ekrem Ã?nsoy" wrote:
>> Will you open up SQL Server Configuration Manager from Configuration
>> Tools
>> and look for SQL Server services from SQL Server 2005 Services node?
>> It would be good if you send us a list of those services listed in the
>> SQL
>> Server 2005 Services window.
>> Also, tell us about their statuses (Running\Stopped)
>> --
>> Ekrem Ã?nsoy
>> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
>> MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
>> > Thank you! I figured something like that.
>> >
>> > Well, I did as you suggested, but it looks like everything is already
>> > installed. After I opened thecontrol panel, I selected SQL Server 2005
>> > and
>> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
>> > have
>> > been installed) or SQL Server 2005 common components (has a sub-button
>> > of
>> > Workstation Components). I chose the latter, common components. Was
>> > that
>> > right?
>> >
>> > In the connectivity components, it looks like everything is already
>> > there:
>> > management tools, business intellegence development studio, software
>> > development kit, sqlxml client features, legacy components, and all the
>> > "Documentattion, Samples, and Sample Databases".
>> >
>> > Am I still missing something?! I am VERY GRATEFUL for your help!
>> >
>> > azanna.
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> SQL Server is comprised of several services. You may have installed
>> >> the
>> >> client tools only. Go to Control Panel | Programs | Uninstall a
>> >> Program
>> >> (used to be Add/Remove programs) and look for Microsoft SQL Server
>> >> 2005.
>> >> Select it and hit Change. You should be able to add the services you
>> >> missed.
>> >>
>> >> --
>> >> Geoff N. Hiten
>> >> Senior SQL Infrastructure Consultant
>> >> Microsoft SQL Server MVP
>> >>
>> >>
>> >>
>> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> >> > Server,
>> >> > SP2. When I open the Management Studio, there are no servers to
>> >> > choose.
>> >> > I
>> >> > can't make a server show up there! If the software is installed on
>> >> > my
>> >> > machine
>> >> > (Windows Vista), is there a SQL server running in the background
>> >> > somewhere?
>> >> > As a service? I don't see a service in the Services control panel.
>> >> > Do I
>> >> > need
>> >> > to start the server somehow? I have looked everywhere for this
>> >> > information!
>> >> > Help!
>> >>
>> >>
installation. I have just installed MS SQL Server 2005 and SQL 2005 Server,
SP2. When I open the Management Studio, there are no servers to choose. I
can't make a server show up there! If the software is installed on my machine
(Windows Vista), is there a SQL server running in the background somewhere?
As a service? I don't see a service in the Services control panel. Do I need
to start the server somehow? I have looked everywhere for this information!
Help!SQL Server is comprised of several services. You may have installed the
client tools only. Go to Control Panel | Programs | Uninstall a Program
(used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
Select it and hit Change. You should be able to add the services you
missed.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> installation. I have just installed MS SQL Server 2005 and SQL 2005
> Server,
> SP2. When I open the Management Studio, there are no servers to choose. I
> can't make a server show up there! If the software is installed on my
> machine
> (Windows Vista), is there a SQL server running in the background
> somewhere?
> As a service? I don't see a service in the Services control panel. Do I
> need
> to start the server somehow? I have looked everywhere for this
> information!
> Help!|||Thank you! I figured something like that.
Well, I did as you suggested, but it looks like everything is already
installed. After I opened thecontrol panel, I selected SQL Server 2005 and
clicked on Change. Then I could choose SQL Server 2005 Instances (none have
been installed) or SQL Server 2005 common components (has a sub-button of
Workstation Components). I chose the latter, common components. Was that
right?
In the connectivity components, it looks like everything is already there:
management tools, business intellegence development studio, software
development kit, sqlxml client features, legacy components, and all the
"Documentattion, Samples, and Sample Databases".
Am I still missing something?! I am VERY GRATEFUL for your help!
azanna.
"Geoff N. Hiten" wrote:
> SQL Server is comprised of several services. You may have installed the
> client tools only. Go to Control Panel | Programs | Uninstall a Program
> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
> Select it and hit Change. You should be able to add the services you
> missed.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> > installation. I have just installed MS SQL Server 2005 and SQL 2005
> > Server,
> > SP2. When I open the Management Studio, there are no servers to choose. I
> > can't make a server show up there! If the software is installed on my
> > machine
> > (Windows Vista), is there a SQL server running in the background
> > somewhere?
> > As a service? I don't see a service in the Services control panel. Do I
> > need
> > to start the server somehow? I have looked everywhere for this
> > information!
> > Help!
>|||Instances are the SQL services. Common components is common across the
various SQL subsystems. Go back and install an instance. Default instance
should be what you need.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> Thank you! I figured something like that.
> Well, I did as you suggested, but it looks like everything is already
> installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> clicked on Change. Then I could choose SQL Server 2005 Instances (none
> have
> been installed) or SQL Server 2005 common components (has a sub-button of
> Workstation Components). I chose the latter, common components. Was that
> right?
> In the connectivity components, it looks like everything is already there:
> management tools, business intellegence development studio, software
> development kit, sqlxml client features, legacy components, and all the
> "Documentattion, Samples, and Sample Databases".
> Am I still missing something?! I am VERY GRATEFUL for your help!
> azanna.
> "Geoff N. Hiten" wrote:
>> SQL Server is comprised of several services. You may have installed the
>> client tools only. Go to Control Panel | Programs | Uninstall a Program
>> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
>> Select it and hit Change. You should be able to add the services you
>> missed.
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> > Server,
>> > SP2. When I open the Management Studio, there are no servers to choose.
>> > I
>> > can't make a server show up there! If the software is installed on my
>> > machine
>> > (Windows Vista), is there a SQL server running in the background
>> > somewhere?
>> > As a service? I don't see a service in the Services control panel. Do I
>> > need
>> > to start the server somehow? I have looked everywhere for this
>> > information!
>> > Help!
>>|||Here's what I get: "There are no items to show in this view." Wah!
"Ekrem Ã?nsoy" wrote:
> Will you open up SQL Server Configuration Manager from Configuration Tools
> and look for SQL Server services from SQL Server 2005 Services node?
> It would be good if you send us a list of those services listed in the SQL
> Server 2005 Services window.
> Also, tell us about their statuses (Running\Stopped)
> --
> Ekrem Ã?nsoy
> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
> MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
>
> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> > Thank you! I figured something like that.
> >
> > Well, I did as you suggested, but it looks like everything is already
> > installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
> > have
> > been installed) or SQL Server 2005 common components (has a sub-button of
> > Workstation Components). I chose the latter, common components. Was that
> > right?
> >
> > In the connectivity components, it looks like everything is already there:
> > management tools, business intellegence development studio, software
> > development kit, sqlxml client features, legacy components, and all the
> > "Documentattion, Samples, and Sample Databases".
> >
> > Am I still missing something?! I am VERY GRATEFUL for your help!
> >
> > azanna.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> SQL Server is comprised of several services. You may have installed the
> >> client tools only. Go to Control Panel | Programs | Uninstall a Program
> >> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
> >> Select it and hit Change. You should be able to add the services you
> >> missed.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior SQL Infrastructure Consultant
> >> Microsoft SQL Server MVP
> >>
> >>
> >>
> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
> >> > Server,
> >> > SP2. When I open the Management Studio, there are no servers to choose.
> >> > I
> >> > can't make a server show up there! If the software is installed on my
> >> > machine
> >> > (Windows Vista), is there a SQL server running in the background
> >> > somewhere?
> >> > As a service? I don't see a service in the Services control panel. Do I
> >> > need
> >> > to start the server somehow? I have looked everywhere for this
> >> > information!
> >> > Help!
> >>
> >>
>|||Hi, Geoff. Actually, I did try that too, but I apparently can't point to a
valid installation file. I downloaded and installed the SQL Server 2005
full-version trial. I did it two ways; I saved the image file (which doesn't
work for adding a component in the instance dialog) and I also just installed
the .exe that was the Download link. Neither one will let me install an
instance. When I use the Report button, it says that I do have a common
instance installed:
Workstation Components
[Version: 9.2.3042.00 Edition: Enterprise Evaluation Edition Patch
level: 9.2.3042 Language: English (United States)]
Thank you!
azanna.
"Geoff N. Hiten" wrote:
> Instances are the SQL services. Common components is common across the
> various SQL subsystems. Go back and install an instance. Default instance
> should be what you need.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> > Thank you! I figured something like that.
> >
> > Well, I did as you suggested, but it looks like everything is already
> > installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
> > have
> > been installed) or SQL Server 2005 common components (has a sub-button of
> > Workstation Components). I chose the latter, common components. Was that
> > right?
> >
> > In the connectivity components, it looks like everything is already there:
> > management tools, business intellegence development studio, software
> > development kit, sqlxml client features, legacy components, and all the
> > "Documentattion, Samples, and Sample Databases".
> >
> > Am I still missing something?! I am VERY GRATEFUL for your help!
> >
> > azanna.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> SQL Server is comprised of several services. You may have installed the
> >> client tools only. Go to Control Panel | Programs | Uninstall a Program
> >> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
> >> Select it and hit Change. You should be able to add the services you
> >> missed.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior SQL Infrastructure Consultant
> >> Microsoft SQL Server MVP
> >>
> >>
> >>
> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
> >> > Server,
> >> > SP2. When I open the Management Studio, there are no servers to choose.
> >> > I
> >> > can't make a server show up there! If the software is installed on my
> >> > machine
> >> > (Windows Vista), is there a SQL server running in the background
> >> > somewhere?
> >> > As a service? I don't see a service in the Services control panel. Do I
> >> > need
> >> > to start the server somehow? I have looked everywhere for this
> >> > information!
> >> > Help!
> >>
> >>
>|||Instance means SQL Service Instance. No other component of SQL is an
Instance.
Workstation components are not part of an instance, They are management
tools, documentation, examples, and config tools.
Unpack the image to a folder and point there when the installer wants the
install folder. You must select SQL Server Database Services (first item on
the Components to Install dialog box) if you want to install the SQL Server
engine.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:17D32179-E8F6-44E0-A67D-AE6F92921610@.microsoft.com...
> Hi, Geoff. Actually, I did try that too, but I apparently can't point to a
> valid installation file. I downloaded and installed the SQL Server 2005
> full-version trial. I did it two ways; I saved the image file (which
> doesn't
> work for adding a component in the instance dialog) and I also just
> installed
> the .exe that was the Download link. Neither one will let me install an
> instance. When I use the Report button, it says that I do have a common
> instance installed:
> Workstation Components
> [Version: 9.2.3042.00 Edition: Enterprise Evaluation Edition Patch
> level: 9.2.3042 Language: English (United States)]
> Thank you!
> azanna.
> "Geoff N. Hiten" wrote:
>> Instances are the SQL services. Common components is common across the
>> various SQL subsystems. Go back and install an instance. Default
>> instance
>> should be what you need.
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
>> > Thank you! I figured something like that.
>> >
>> > Well, I did as you suggested, but it looks like everything is already
>> > installed. After I opened thecontrol panel, I selected SQL Server 2005
>> > and
>> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
>> > have
>> > been installed) or SQL Server 2005 common components (has a sub-button
>> > of
>> > Workstation Components). I chose the latter, common components. Was
>> > that
>> > right?
>> >
>> > In the connectivity components, it looks like everything is already
>> > there:
>> > management tools, business intellegence development studio, software
>> > development kit, sqlxml client features, legacy components, and all the
>> > "Documentattion, Samples, and Sample Databases".
>> >
>> > Am I still missing something?! I am VERY GRATEFUL for your help!
>> >
>> > azanna.
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> SQL Server is comprised of several services. You may have installed
>> >> the
>> >> client tools only. Go to Control Panel | Programs | Uninstall a
>> >> Program
>> >> (used to be Add/Remove programs) and look for Microsoft SQL Server
>> >> 2005.
>> >> Select it and hit Change. You should be able to add the services you
>> >> missed.
>> >>
>> >> --
>> >> Geoff N. Hiten
>> >> Senior SQL Infrastructure Consultant
>> >> Microsoft SQL Server MVP
>> >>
>> >>
>> >>
>> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> >> > Server,
>> >> > SP2. When I open the Management Studio, there are no servers to
>> >> > choose.
>> >> > I
>> >> > can't make a server show up there! If the software is installed on
>> >> > my
>> >> > machine
>> >> > (Windows Vista), is there a SQL server running in the background
>> >> > somewhere?
>> >> > As a service? I don't see a service in the Services control panel.
>> >> > Do I
>> >> > need
>> >> > to start the server somehow? I have looked everywhere for this
>> >> > information!
>> >> > Help!
>> >>
>> >>
>>|||Will you open up SQL Server Configuration Manager from Configuration Tools
and look for SQL Server services from SQL Server 2005 Services node?
It would be good if you send us a list of those services listed in the SQL
Server 2005 Services window.
Also, tell us about their statuses (Running\Stopped)
--
Ekrem Ã?nsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> Thank you! I figured something like that.
> Well, I did as you suggested, but it looks like everything is already
> installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> clicked on Change. Then I could choose SQL Server 2005 Instances (none
> have
> been installed) or SQL Server 2005 common components (has a sub-button of
> Workstation Components). I chose the latter, common components. Was that
> right?
> In the connectivity components, it looks like everything is already there:
> management tools, business intellegence development studio, software
> development kit, sqlxml client features, legacy components, and all the
> "Documentattion, Samples, and Sample Databases".
> Am I still missing something?! I am VERY GRATEFUL for your help!
> azanna.
> "Geoff N. Hiten" wrote:
>> SQL Server is comprised of several services. You may have installed the
>> client tools only. Go to Control Panel | Programs | Uninstall a Program
>> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
>> Select it and hit Change. You should be able to add the services you
>> missed.
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> > Server,
>> > SP2. When I open the Management Studio, there are no servers to choose.
>> > I
>> > can't make a server show up there! If the software is installed on my
>> > machine
>> > (Windows Vista), is there a SQL server running in the background
>> > somewhere?
>> > As a service? I don't see a service in the Services control panel. Do I
>> > need
>> > to start the server somehow? I have looked everywhere for this
>> > information!
>> > Help!
>>|||It's obviously clear that you have no any installed SQL Server instance.
Will you try to start the SQL Server setup and try to install an instance?
Do not skip checking Database Engine from the Components to Install window
that will appear in setup process.
After the setup, go to Configuration Manager and look for SQL Server
services and tell us what happens.
--
Ekrem Ã?nsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:217AB314-58A5-4BA2-B9D8-48082526E886@.microsoft.com...
> Here's what I get: "There are no items to show in this view." Wah!
> "Ekrem Ã?nsoy" wrote:
>> Will you open up SQL Server Configuration Manager from Configuration
>> Tools
>> and look for SQL Server services from SQL Server 2005 Services node?
>> It would be good if you send us a list of those services listed in the
>> SQL
>> Server 2005 Services window.
>> Also, tell us about their statuses (Running\Stopped)
>> --
>> Ekrem Ã?nsoy
>> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
>> MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
>> > Thank you! I figured something like that.
>> >
>> > Well, I did as you suggested, but it looks like everything is already
>> > installed. After I opened thecontrol panel, I selected SQL Server 2005
>> > and
>> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
>> > have
>> > been installed) or SQL Server 2005 common components (has a sub-button
>> > of
>> > Workstation Components). I chose the latter, common components. Was
>> > that
>> > right?
>> >
>> > In the connectivity components, it looks like everything is already
>> > there:
>> > management tools, business intellegence development studio, software
>> > development kit, sqlxml client features, legacy components, and all the
>> > "Documentattion, Samples, and Sample Databases".
>> >
>> > Am I still missing something?! I am VERY GRATEFUL for your help!
>> >
>> > azanna.
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> SQL Server is comprised of several services. You may have installed
>> >> the
>> >> client tools only. Go to Control Panel | Programs | Uninstall a
>> >> Program
>> >> (used to be Add/Remove programs) and look for Microsoft SQL Server
>> >> 2005.
>> >> Select it and hit Change. You should be able to add the services you
>> >> missed.
>> >>
>> >> --
>> >> Geoff N. Hiten
>> >> Senior SQL Infrastructure Consultant
>> >> Microsoft SQL Server MVP
>> >>
>> >>
>> >>
>> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> >> > Server,
>> >> > SP2. When I open the Management Studio, there are no servers to
>> >> > choose.
>> >> > I
>> >> > can't make a server show up there! If the software is installed on
>> >> > my
>> >> > machine
>> >> > (Windows Vista), is there a SQL server running in the background
>> >> > somewhere?
>> >> > As a service? I don't see a service in the Services control panel.
>> >> > Do I
>> >> > need
>> >> > to start the server somehow? I have looked everywhere for this
>> >> > information!
>> >> > Help!
>> >>
>> >>
Newb question
If I am using Ado.Net from a .Net Class library hosted outside SqlServer to do Sends and Receives do I have to use anything else other than queues? The reason I am asking is because I already have an abstraction layer for a couple of our queueing systems and I was hoping to put SSB in there as well but the abstraction layers' primitive is the Queue not Conversation/Dialog/Service, etc.
Thanks
CostasWhile you could build a layer that exposes just queues, you will soon discover that it will not be possible to expose all the richness of Service Broker (i.e. conversations, conversation group locking, etc) in that manner. But if you need to keep the existing interface in order to port your app over, you could certainly build a layer based on Queues like you describe.|||Rushi, thanks. The reason I asked is that almost all the examples I've seen use conversation where using the queues. Can you point me to an example where I can do send & receive solely with queues?
Thanks
Costas|||OK, I am getting the idea that I cannot just "send" a message to a queue. I think I have to create a queue and a service to go with it. Now, if my client needs to "send" on a queue, can I fake it with 1 stored procedure that takes the service name as a parameter?
Does this look reasonable?
create message type
[http://www.myblobcom/msg/BlobMsg]
validation = NONE;
create contract [http://www.myblobcom.com/contract/SaveBlob/v1.0]
(
[http://www.myblobcom.com/msg/BlobMsg] sent by initiator
);
create queue [Blob Queue];
create service [BlobSvc]
on queue [Blob Queue]
(
[http://www.myblobcom.com/contract/SaveBlob/v1.0]
);
CREATE PROCEDURE SaveBlob (
@.service varchar(36),
@.queue varchar(36),
@.payload VARBINARY(MAX))
AS BEGIN
declare @.dh uniqueidentifier;
-- HERE IS WHERE I HAVE MY CONCEPTUAL PROBLEM
-- HOW DO I BEGIN A DIALOG WITH A STORED PROCEDURE
-- CALLED BY AN EXTERNAL ADO.NET CLIENT?
-- begin dialog @.dh
-- from service [Inventory Client]
-- to service 'Inventory'
on contract [http://www.myblobcom.com/contract/SaveBlob/v1.0]
with encryption=off;
send on conversation @.dh message type [http://www.myblobcom/msg/BlobMsg] (@.payload );
end
Thanks
Costas|||Hi, can someone tell me if I am on the right track?
Thanks
Costas|||
Uncomment the begin dialog lines. Use the @.service parameter as the to service in that statement. That will allow you to begin a dialog and send a message in your stored proc. This proc can be called from ADO.Net.
|||Rushi, thanks, I am not sure what to do with the [from service]. What's the from service set to when you're called from an extarnal ADO.NET client?
Cheers
Costas
|||Dialog conversations are persistent sessions between two services -- the initiator and the target service. When beginning a dialog, you must specify the initiator service in the from argument and the target service in the to argument. Even if you use dialogs for one-way messaging, you still need a 'from' service where errors could be sent back as reponses. Each service has its own queue which serves as a backing store where messages are delivered until the service receives them.
Refer to Books Online to understand more about Service Broker architecture. You could also get a copy of Roger Wolter's book on Service Broker.
|||Rushi, thanks, I think that's where my ability to comprehend the service broker external call breaks down. All samples, articles, etc discuss it from the point of view of internal services talking to each other through dialogs which is not what I want to do or is it? Are you implying that my "from" service is really just a placeholder in my case just so that the dialog can take place? So, I'd call the stored proc from ado.net which will send a message in the queue from what I can call the "externalactivationservice" and the message will be sent to my handle blob service.I am going to give it a shot, thanks
Costas
Newb question
I am attempting to retrieve specific task related data from a Project server
environment for input to an Excel 2003 spreadsheet and have created the
following SQL view using:
SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
dbo.MSP_TASKS.TASK_IS_MILESTONE
FROM dbo.MSP_PROJECTS CROSS JOIN
dbo.MSP_TASKS
WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
(dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
My logic here is that this query will pull back all tasks that are
milestones from 'project 92' only. However, this query pulls back all
milestones from all projects... I have no idea why, could someone please
shed some light on this newb.
Many thanks,
Nock (SQL Newb, Australia)I think the CROSS JOIN might be a clue. I would just use a JOIN
"Nock" wrote:
> I am attempting to retrieve specific task related data from a Project serv
er
> environment for input to an Excel 2003 spreadsheet and have created the
> following SQL view using:
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS CROSS JOIN
> dbo.MSP_TASKS
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> My logic here is that this query will pull back all tasks that are
> milestones from 'project 92' only. However, this query pulls back all
> milestones from all projects... I have no idea why, could someone please
> shed some light on this newb.
> Many thanks,
> Nock (SQL Newb, Australia)|||it is because of the CROSS JOIN used to connect the MSP_PROJECTS and
MSP_TASKS tables. A cross join between two tables produces what is known as
a
Cartesian product, which is a table that contains all of the possible
combinations between the rows between the input tables. In other words, a
cross join between two tables X and Y with x and y rows respectively will
contain 1 row for each y rows for each row in X, for a total of x times y
rows.
What you probably want is something like this
SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
dbo.MSP_TASKS.TASK_IS_MILESTONE
FROM dbo.MSP_PROJECTS INNER JOIN
dbo.MSP_TASKS ON dbo.MSP_PROJECTS.PROJ_ID =
dbo.MSP_TASKS.PROJ_ID
WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
(dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
"Nock" wrote:
> I am attempting to retrieve specific task related data from a Project serv
er
> environment for input to an Excel 2003 spreadsheet and have created the
> following SQL view using:
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS CROSS JOIN
> dbo.MSP_TASKS
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> My logic here is that this query will pull back all tasks that are
> milestones from 'project 92' only. However, this query pulls back all
> milestones from all projects... I have no idea why, could someone please
> shed some light on this newb.
> Many thanks,
> Nock (SQL Newb, Australia)|||Nock,
What is the common column between the tables? n other words, does MSP_TASKS
have a foreign Key column to the Primary Key column on MSP_PROJECTS, or
vice-versa.
Whichever is the key column you should then use a standard JOIN statement.
If you want just the Tasks that are associated with Project 92, then you
should use the following...
SELECT proj.PROJ_NAME,
task.TASK_NAME,
task.TASK_IS_MILESTONE
FROM dbo.MSP_PROJECTS proj LEFT JOIN
dbo.MSP_TASKS task ON proj.{PK} = task.{FK}
WHERE (proj.PROJ_ID = 92)
AND (task.TASK_IS_MILESTONE = 1)
The LEFT Join will ensure you get all Project Data back together with any
Task data that is relevent, or NULL values if none present. If you use INNER
join then there will need to be at least one reacord in each table.
Enjoy,
"Nock" wrote:
> I am attempting to retrieve specific task related data from a Project serv
er
> environment for input to an Excel 2003 spreadsheet and have created the
> following SQL view using:
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS CROSS JOIN
> dbo.MSP_TASKS
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> My logic here is that this query will pull back all tasks that are
> milestones from 'project 92' only. However, this query pulls back all
> milestones from all projects... I have no idea why, could someone please
> shed some light on this newb.
> Many thanks,
> Nock (SQL Newb, Australia)|||Thanks Mark et al, much appreciated and great explanation.
I'm in one of those situations where I've been asked to become a 'SQL
person' in a day...
Loving life :)
Cheers,
Nock
"Mark Williams" wrote:
> it is because of the CROSS JOIN used to connect the MSP_PROJECTS and
> MSP_TASKS tables. A cross join between two tables produces what is known a
s a
> Cartesian product, which is a table that contains all of the possible
> combinations between the rows between the input tables. In other words, a
> cross join between two tables X and Y with x and y rows respectively will
> contain 1 row for each y rows for each row in X, for a total of x times y
> rows.
> What you probably want is something like this
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS INNER JOIN
> dbo.MSP_TASKS ON dbo.MSP_PROJECTS.PROJ_ID =
> dbo.MSP_TASKS.PROJ_ID
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> --
> "Nock" wrote:
>|||Try these sites for a general SQL overview...
http://www.w3schools.com/sql/sql_intro.asp
http://sqlzoo.net/
"Nock" <Nock@.discussions.microsoft.com> wrote in message
news:05979A9F-A3BC-401B-867F-CDC7114D2CE1@.microsoft.com...
> Thanks Mark et al, much appreciated and great explanation.
> I'm in one of those situations where I've been asked to become a 'SQL
> person' in a day...
> Loving life :)
> Cheers,
> Nock
> "Mark Williams" wrote:
>
as a
a
will
y
server
the
please
environment for input to an Excel 2003 spreadsheet and have created the
following SQL view using:
SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
dbo.MSP_TASKS.TASK_IS_MILESTONE
FROM dbo.MSP_PROJECTS CROSS JOIN
dbo.MSP_TASKS
WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
(dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
My logic here is that this query will pull back all tasks that are
milestones from 'project 92' only. However, this query pulls back all
milestones from all projects... I have no idea why, could someone please
shed some light on this newb.
Many thanks,
Nock (SQL Newb, Australia)I think the CROSS JOIN might be a clue. I would just use a JOIN
"Nock" wrote:
> I am attempting to retrieve specific task related data from a Project serv
er
> environment for input to an Excel 2003 spreadsheet and have created the
> following SQL view using:
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS CROSS JOIN
> dbo.MSP_TASKS
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> My logic here is that this query will pull back all tasks that are
> milestones from 'project 92' only. However, this query pulls back all
> milestones from all projects... I have no idea why, could someone please
> shed some light on this newb.
> Many thanks,
> Nock (SQL Newb, Australia)|||it is because of the CROSS JOIN used to connect the MSP_PROJECTS and
MSP_TASKS tables. A cross join between two tables produces what is known as
a
Cartesian product, which is a table that contains all of the possible
combinations between the rows between the input tables. In other words, a
cross join between two tables X and Y with x and y rows respectively will
contain 1 row for each y rows for each row in X, for a total of x times y
rows.
What you probably want is something like this
SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
dbo.MSP_TASKS.TASK_IS_MILESTONE
FROM dbo.MSP_PROJECTS INNER JOIN
dbo.MSP_TASKS ON dbo.MSP_PROJECTS.PROJ_ID =
dbo.MSP_TASKS.PROJ_ID
WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
(dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
"Nock" wrote:
> I am attempting to retrieve specific task related data from a Project serv
er
> environment for input to an Excel 2003 spreadsheet and have created the
> following SQL view using:
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS CROSS JOIN
> dbo.MSP_TASKS
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> My logic here is that this query will pull back all tasks that are
> milestones from 'project 92' only. However, this query pulls back all
> milestones from all projects... I have no idea why, could someone please
> shed some light on this newb.
> Many thanks,
> Nock (SQL Newb, Australia)|||Nock,
What is the common column between the tables? n other words, does MSP_TASKS
have a foreign Key column to the Primary Key column on MSP_PROJECTS, or
vice-versa.
Whichever is the key column you should then use a standard JOIN statement.
If you want just the Tasks that are associated with Project 92, then you
should use the following...
SELECT proj.PROJ_NAME,
task.TASK_NAME,
task.TASK_IS_MILESTONE
FROM dbo.MSP_PROJECTS proj LEFT JOIN
dbo.MSP_TASKS task ON proj.{PK} = task.{FK}
WHERE (proj.PROJ_ID = 92)
AND (task.TASK_IS_MILESTONE = 1)
The LEFT Join will ensure you get all Project Data back together with any
Task data that is relevent, or NULL values if none present. If you use INNER
join then there will need to be at least one reacord in each table.
Enjoy,
"Nock" wrote:
> I am attempting to retrieve specific task related data from a Project serv
er
> environment for input to an Excel 2003 spreadsheet and have created the
> following SQL view using:
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS CROSS JOIN
> dbo.MSP_TASKS
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> My logic here is that this query will pull back all tasks that are
> milestones from 'project 92' only. However, this query pulls back all
> milestones from all projects... I have no idea why, could someone please
> shed some light on this newb.
> Many thanks,
> Nock (SQL Newb, Australia)|||Thanks Mark et al, much appreciated and great explanation.
I'm in one of those situations where I've been asked to become a 'SQL
person' in a day...
Loving life :)
Cheers,
Nock
"Mark Williams" wrote:
> it is because of the CROSS JOIN used to connect the MSP_PROJECTS and
> MSP_TASKS tables. A cross join between two tables produces what is known a
s a
> Cartesian product, which is a table that contains all of the possible
> combinations between the rows between the input tables. In other words, a
> cross join between two tables X and Y with x and y rows respectively will
> contain 1 row for each y rows for each row in X, for a total of x times y
> rows.
> What you probably want is something like this
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS INNER JOIN
> dbo.MSP_TASKS ON dbo.MSP_PROJECTS.PROJ_ID =
> dbo.MSP_TASKS.PROJ_ID
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> --
> "Nock" wrote:
>|||Try these sites for a general SQL overview...
http://www.w3schools.com/sql/sql_intro.asp
http://sqlzoo.net/
"Nock" <Nock@.discussions.microsoft.com> wrote in message
news:05979A9F-A3BC-401B-867F-CDC7114D2CE1@.microsoft.com...
> Thanks Mark et al, much appreciated and great explanation.
> I'm in one of those situations where I've been asked to become a 'SQL
> person' in a day...
> Loving life :)
> Cheers,
> Nock
> "Mark Williams" wrote:
>
as a
a
will
y
server
the
please
Newb query on query :)
Hi,
Newb question here,
I have two tables (A & B) that I want to join and exclude the elements that
match, what would be the best aproach for this? thanks in advance. (BTW I'm
comparing 5 fields that have to match from each table: A1 = B1 And A2 = B2
... and so forth.)SELECT <columnList>
FROM TableA A
FULL OUTER JOIN TableB B
ON A.Col1 = b.Col1 And A.Col2 = B.Col2 AND ...
WHERE A.Col1 IS NULL OR B.Col1 IS NULL
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Manny" <Manny@.discussions.microsoft.com> wrote in message
news:DA005CA3-B3FA-44C8-9F86-00CA28ACEFF2@.microsoft.com...
> Hi,
> Newb question here,
> I have two tables (A & B) that I want to join and exclude the elements
> that
> match, what would be the best aproach for this? thanks in advance. (BTW
> I'm
> comparing 5 fields that have to match from each table: A1 = B1 And A2 = B2
> ... and so forth.)
>|||Manny
> I have two tables (A & B) that I want to join and exclude the elements
that
> match,
You meant that all data from A that does not exist in B?
Look up LEFT/RIGHT/FULL join combinations in the BOL and WHERE NOT EXISTS
command as well.
"Manny" <Manny@.discussions.microsoft.com> wrote in message
news:DA005CA3-B3FA-44C8-9F86-00CA28ACEFF2@.microsoft.com...
> Hi,
> Newb question here,
> I have two tables (A & B) that I want to join and exclude the elements
that
> match, what would be the best aproach for this? thanks in advance. (BTW
I'm
> comparing 5 fields that have to match from each table: A1 = B1 And A2 = B2
> ... and so forth.)
>|||"Uri Dimant" wrote:
> You meant that all data from A that does not exist in B?
> Look up LEFT/RIGHT/FULL join combinations in the BOL and WHERE NOT EXISTS
> command as well.
Thanks Uri & Roji for your responses,
Yes, well I actually need 3 results:
1) Information that matches A & B (which was the easiest for me :)
2) Information that exists in A different from B (excluding the match)
3) Information that exists in B different from A (excluding the match)
I'll look up the join conditions you guys are sugesting, thanks again.
Newb question here,
I have two tables (A & B) that I want to join and exclude the elements that
match, what would be the best aproach for this? thanks in advance. (BTW I'm
comparing 5 fields that have to match from each table: A1 = B1 And A2 = B2
... and so forth.)SELECT <columnList>
FROM TableA A
FULL OUTER JOIN TableB B
ON A.Col1 = b.Col1 And A.Col2 = B.Col2 AND ...
WHERE A.Col1 IS NULL OR B.Col1 IS NULL
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Manny" <Manny@.discussions.microsoft.com> wrote in message
news:DA005CA3-B3FA-44C8-9F86-00CA28ACEFF2@.microsoft.com...
> Hi,
> Newb question here,
> I have two tables (A & B) that I want to join and exclude the elements
> that
> match, what would be the best aproach for this? thanks in advance. (BTW
> I'm
> comparing 5 fields that have to match from each table: A1 = B1 And A2 = B2
> ... and so forth.)
>|||Manny
> I have two tables (A & B) that I want to join and exclude the elements
that
> match,
You meant that all data from A that does not exist in B?
Look up LEFT/RIGHT/FULL join combinations in the BOL and WHERE NOT EXISTS
command as well.
"Manny" <Manny@.discussions.microsoft.com> wrote in message
news:DA005CA3-B3FA-44C8-9F86-00CA28ACEFF2@.microsoft.com...
> Hi,
> Newb question here,
> I have two tables (A & B) that I want to join and exclude the elements
that
> match, what would be the best aproach for this? thanks in advance. (BTW
I'm
> comparing 5 fields that have to match from each table: A1 = B1 And A2 = B2
> ... and so forth.)
>|||"Uri Dimant" wrote:
> You meant that all data from A that does not exist in B?
> Look up LEFT/RIGHT/FULL join combinations in the BOL and WHERE NOT EXISTS
> command as well.
Thanks Uri & Roji for your responses,
Yes, well I actually need 3 results:
1) Information that matches A & B (which was the easiest for me :)
2) Information that exists in A different from B (excluding the match)
3) Information that exists in B different from A (excluding the match)
I'll look up the join conditions you guys are sugesting, thanks again.
Subscribe to:
Posts (Atom)