I am sql server newbie who is trying to migrating a DB2 system(MF) to
SQLserver.
I have a few questions, it would be great if someone can help me out :
1. When I am porting the app to sqlserver, is it advisable to make the
queries to SP or keep it as a regular SQL ? Does SP perform any better
than SQL ? I have heard that lot of places write only SP, so the
front-end programmers can just call the SP and get the data.
2. I got multiple databases in DB2 (in mainframe ,databases are just
logical), is it a good idea to create different databases in SQLserver
or have it in one big database . Pro and cons ?
Could anybody please help
TIA
Roger
Comments Inline
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegro ups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
Generally speaking, it is a good idea to write a stored procedure interface
to the database. Performance is usually better due to procedure plan
caching, plus it gives you a layer of abstraction so you can make changes
without haveing to make the code changes at the same time.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
I prefer to keep data together in a single database if it needs to be
transactionally synchronized for backup and restore, needs to have
database-level referential integrity constraints, and makes sense to do so.
There are other considerations such as whether there are data logs or work
queues involved that have specific performance and backup needs, but those
are the major reasons.
> Could anybody please help
> TIA
> Roger
>
|||When a query is processed by SQL Server, it requires miliseconds to compile
the execution plan. Whether this is a performance issue depends on the case
usage of the SP. If this SP is called 10,000 times per day, or several times
per second, then yes it can reduce the compile time and is probably more a
scalability issue. However, if this is a SP used for reporting purposes,
occasional data inserts (few times per hour), etc. calling as a SP will not
impact the runtime performance. In other words, a query that takes 2 minutes
to execute from the application will not be reduced to 2 seconds simply
because it has been re-written as a SP. Your time is better spent optimizing
the structure of the query itself.
However, from an architectural perspective, I believe that queries
(especially insert / update / delete queries) should be implemented as SPs.
This shifts business logic an data modification programming to the server
side where it can be better managed by the DBA. The application tier should
be as lightweight as possible and deal strictly with presentation, user
input, workflow, etc.; espcially if we are talking about a web application.
Whether your tables should be placed in one database or multiple databases
would require knowledge about the nature and relationship of the data. That
said, depending on the volume of data (say 10 GBs or larger), it can be
generally beneficial for performance reasons to archive rarely used
historical data to a seperate database.
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegro ups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
> Could anybody please help
> TIA
> Roger
>
|||Thanks a lot Geoff and Johnny . Appreciate ur reply
sql
Showing posts with label databases. Show all posts
Showing posts with label databases. Show all posts
Friday, March 30, 2012
newbie question on SP, Databases,instances
I am sql server newbie who is trying to migrating a DB2 system(MF) to
SQLserver.
I have a few questions, it would be great if someone can help me out :
1. When I am porting the app to sqlserver, is it advisable to make the
queries to SP or keep it as a regular SQL ? Does SP perform any better
than SQL ? I have heard that lot of places write only SP, so the
front-end programmers can just call the SP and get the data.
2. I got multiple databases in DB2 (in mainframe ,databases are just
logical), is it a good idea to create different databases in SQLserver
or have it in one big database . Pro and cons ?
Could anybody please help
TIA
RogerComments Inline
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
Generally speaking, it is a good idea to write a stored procedure interface
to the database. Performance is usually better due to procedure plan
caching, plus it gives you a layer of abstraction so you can make changes
without haveing to make the code changes at the same time.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
I prefer to keep data together in a single database if it needs to be
transactionally synchronized for backup and restore, needs to have
database-level referential integrity constraints, and makes sense to do so.
There are other considerations such as whether there are data logs or work
queues involved that have specific performance and backup needs, but those
are the major reasons.
> Could anybody please help
> TIA
> Roger
>|||When a query is processed by SQL Server, it requires miliseconds to compile
the execution plan. Whether this is a performance issue depends on the case
usage of the SP. If this SP is called 10,000 times per day, or several times
per second, then yes it can reduce the compile time and is probably more a
scalability issue. However, if this is a SP used for reporting purposes,
occasional data inserts (few times per hour), etc. calling as a SP will not
impact the runtime performance. In other words, a query that takes 2 minutes
to execute from the application will not be reduced to 2 seconds simply
because it has been re-written as a SP. Your time is better spent optimizing
the structure of the query itself.
However, from an architectural perspective, I believe that queries
(especially insert / update / delete queries) should be implemented as SPs.
This shifts business logic an data modification programming to the server
side where it can be better managed by the DBA. The application tier should
be as lightweight as possible and deal strictly with presentation, user
input, workflow, etc.; espcially if we are talking about a web application.
Whether your tables should be placed in one database or multiple databases
would require knowledge about the nature and relationship of the data. That
said, depending on the volume of data (say 10 GBs or larger), it can be
generally beneficial for performance reasons to archive rarely used
historical data to a seperate database.
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
> Could anybody please help
> TIA
> Roger
>|||Thanks a lot Geoff and Johnny . Appreciate ur reply
SQLserver.
I have a few questions, it would be great if someone can help me out :
1. When I am porting the app to sqlserver, is it advisable to make the
queries to SP or keep it as a regular SQL ? Does SP perform any better
than SQL ? I have heard that lot of places write only SP, so the
front-end programmers can just call the SP and get the data.
2. I got multiple databases in DB2 (in mainframe ,databases are just
logical), is it a good idea to create different databases in SQLserver
or have it in one big database . Pro and cons ?
Could anybody please help
TIA
RogerComments Inline
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
Generally speaking, it is a good idea to write a stored procedure interface
to the database. Performance is usually better due to procedure plan
caching, plus it gives you a layer of abstraction so you can make changes
without haveing to make the code changes at the same time.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
I prefer to keep data together in a single database if it needs to be
transactionally synchronized for backup and restore, needs to have
database-level referential integrity constraints, and makes sense to do so.
There are other considerations such as whether there are data logs or work
queues involved that have specific performance and backup needs, but those
are the major reasons.
> Could anybody please help
> TIA
> Roger
>|||When a query is processed by SQL Server, it requires miliseconds to compile
the execution plan. Whether this is a performance issue depends on the case
usage of the SP. If this SP is called 10,000 times per day, or several times
per second, then yes it can reduce the compile time and is probably more a
scalability issue. However, if this is a SP used for reporting purposes,
occasional data inserts (few times per hour), etc. calling as a SP will not
impact the runtime performance. In other words, a query that takes 2 minutes
to execute from the application will not be reduced to 2 seconds simply
because it has been re-written as a SP. Your time is better spent optimizing
the structure of the query itself.
However, from an architectural perspective, I believe that queries
(especially insert / update / delete queries) should be implemented as SPs.
This shifts business logic an data modification programming to the server
side where it can be better managed by the DBA. The application tier should
be as lightweight as possible and deal strictly with presentation, user
input, workflow, etc.; espcially if we are talking about a web application.
Whether your tables should be placed in one database or multiple databases
would require knowledge about the nature and relationship of the data. That
said, depending on the volume of data (say 10 GBs or larger), it can be
generally beneficial for performance reasons to archive rarely used
historical data to a seperate database.
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
> Could anybody please help
> TIA
> Roger
>|||Thanks a lot Geoff and Johnny . Appreciate ur reply
newbie question on SP, Databases,instances
I am sql server newbie who is trying to migrating a DB2 system(MF) to
SQLserver.
I have a few questions, it would be great if someone can help me out :
1. When I am porting the app to sqlserver, is it advisable to make the
queries to SP or keep it as a regular SQL ? Does SP perform any better
than SQL ? I have heard that lot of places write only SP, so the
front-end programmers can just call the SP and get the data.
2. I got multiple databases in DB2 (in mainframe ,databases are just
logical), is it a good idea to create different databases in SQLserver
or have it in one big database . Pro and cons ?
Could anybody please help
TIA
RogerComments Inline
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
Generally speaking, it is a good idea to write a stored procedure interface
to the database. Performance is usually better due to procedure plan
caching, plus it gives you a layer of abstraction so you can make changes
without haveing to make the code changes at the same time.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
I prefer to keep data together in a single database if it needs to be
transactionally synchronized for backup and restore, needs to have
database-level referential integrity constraints, and makes sense to do so.
There are other considerations such as whether there are data logs or work
queues involved that have specific performance and backup needs, but those
are the major reasons.
> Could anybody please help
> TIA
> Roger
>|||When a query is processed by SQL Server, it requires miliseconds to compile
the execution plan. Whether this is a performance issue depends on the case
usage of the SP. If this SP is called 10,000 times per day, or several times
per second, then yes it can reduce the compile time and is probably more a
scalability issue. However, if this is a SP used for reporting purposes,
occasional data inserts (few times per hour), etc. calling as a SP will not
impact the runtime performance. In other words, a query that takes 2 minutes
to execute from the application will not be reduced to 2 seconds simply
because it has been re-written as a SP. Your time is better spent optimizing
the structure of the query itself.
However, from an architectural perspective, I believe that queries
(especially insert / update / delete queries) should be implemented as SPs.
This shifts business logic an data modification programming to the server
side where it can be better managed by the DBA. The application tier should
be as lightweight as possible and deal strictly with presentation, user
input, workflow, etc.; espcially if we are talking about a web application.
Whether your tables should be placed in one database or multiple databases
would require knowledge about the nature and relationship of the data. That
said, depending on the volume of data (say 10 GBs or larger), it can be
generally beneficial for performance reasons to archive rarely used
historical data to a seperate database.
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
> Could anybody please help
> TIA
> Roger
>|||Thanks a lot Geoff and Johnny . Appreciate ur reply
SQLserver.
I have a few questions, it would be great if someone can help me out :
1. When I am porting the app to sqlserver, is it advisable to make the
queries to SP or keep it as a regular SQL ? Does SP perform any better
than SQL ? I have heard that lot of places write only SP, so the
front-end programmers can just call the SP and get the data.
2. I got multiple databases in DB2 (in mainframe ,databases are just
logical), is it a good idea to create different databases in SQLserver
or have it in one big database . Pro and cons ?
Could anybody please help
TIA
RogerComments Inline
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
Generally speaking, it is a good idea to write a stored procedure interface
to the database. Performance is usually better due to procedure plan
caching, plus it gives you a layer of abstraction so you can make changes
without haveing to make the code changes at the same time.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
I prefer to keep data together in a single database if it needs to be
transactionally synchronized for backup and restore, needs to have
database-level referential integrity constraints, and makes sense to do so.
There are other considerations such as whether there are data logs or work
queues involved that have specific performance and backup needs, but those
are the major reasons.
> Could anybody please help
> TIA
> Roger
>|||When a query is processed by SQL Server, it requires miliseconds to compile
the execution plan. Whether this is a performance issue depends on the case
usage of the SP. If this SP is called 10,000 times per day, or several times
per second, then yes it can reduce the compile time and is probably more a
scalability issue. However, if this is a SP used for reporting purposes,
occasional data inserts (few times per hour), etc. calling as a SP will not
impact the runtime performance. In other words, a query that takes 2 minutes
to execute from the application will not be reduced to 2 seconds simply
because it has been re-written as a SP. Your time is better spent optimizing
the structure of the query itself.
However, from an architectural perspective, I believe that queries
(especially insert / update / delete queries) should be implemented as SPs.
This shifts business logic an data modification programming to the server
side where it can be better managed by the DBA. The application tier should
be as lightweight as possible and deal strictly with presentation, user
input, workflow, etc.; espcially if we are talking about a web application.
Whether your tables should be placed in one database or multiple databases
would require knowledge about the nature and relationship of the data. That
said, depending on the volume of data (say 10 GBs or larger), it can be
generally beneficial for performance reasons to archive rarely used
historical data to a seperate database.
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
> Could anybody please help
> TIA
> Roger
>|||Thanks a lot Geoff and Johnny . Appreciate ur reply
newbie question on SP, Databases,instances
I am sql server newbie who is trying to migrating a DB2 system(MF) to
SQLserver.
I have a few questions, it would be great if someone can help me out :
1. When I am porting the app to sqlserver, is it advisable to make the
queries to SP or keep it as a regular SQL ? Does SP perform any better
than SQL ? I have heard that lot of places write only SP, so the
front-end programmers can just call the SP and get the data.
2. I got multiple databases in DB2 (in mainframe ,databases are just
logical), is it a good idea to create different databases in SQLserver
or have it in one big database . Pro and cons ?
Could anybody please help
TIA
RogerComments Inline
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
Generally speaking, it is a good idea to write a stored procedure interface
to the database. Performance is usually better due to procedure plan
caching, plus it gives you a layer of abstraction so you can make changes
without haveing to make the code changes at the same time.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
I prefer to keep data together in a single database if it needs to be
transactionally synchronized for backup and restore, needs to have
database-level referential integrity constraints, and makes sense to do so.
There are other considerations such as whether there are data logs or work
queues involved that have specific performance and backup needs, but those
are the major reasons.
> Could anybody please help
> TIA
> Roger
>|||When a query is processed by SQL Server, it requires miliseconds to compile
the execution plan. Whether this is a performance issue depends on the case
usage of the SP. If this SP is called 10,000 times per day, or several times
per second, then yes it can reduce the compile time and is probably more a
scalability issue. However, if this is a SP used for reporting purposes,
occasional data inserts (few times per hour), etc. calling as a SP will not
impact the runtime performance. In other words, a query that takes 2 minutes
to execute from the application will not be reduced to 2 seconds simply
because it has been re-written as a SP. Your time is better spent optimizing
the structure of the query itself.
However, from an architectural perspective, I believe that queries
(especially insert / update / delete queries) should be implemented as SPs.
This shifts business logic an data modification programming to the server
side where it can be better managed by the DBA. The application tier should
be as lightweight as possible and deal strictly with presentation, user
input, workflow, etc.; espcially if we are talking about a web application.
Whether your tables should be placed in one database or multiple databases
would require knowledge about the nature and relationship of the data. That
said, depending on the volume of data (say 10 GBs or larger), it can be
generally beneficial for performance reasons to archive rarely used
historical data to a seperate database.
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
> Could anybody please help
> TIA
> Roger
>|||Thanks a lot Geoff and Johnny . Appreciate ur reply
SQLserver.
I have a few questions, it would be great if someone can help me out :
1. When I am porting the app to sqlserver, is it advisable to make the
queries to SP or keep it as a regular SQL ? Does SP perform any better
than SQL ? I have heard that lot of places write only SP, so the
front-end programmers can just call the SP and get the data.
2. I got multiple databases in DB2 (in mainframe ,databases are just
logical), is it a good idea to create different databases in SQLserver
or have it in one big database . Pro and cons ?
Could anybody please help
TIA
RogerComments Inline
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
Generally speaking, it is a good idea to write a stored procedure interface
to the database. Performance is usually better due to procedure plan
caching, plus it gives you a layer of abstraction so you can make changes
without haveing to make the code changes at the same time.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
I prefer to keep data together in a single database if it needs to be
transactionally synchronized for backup and restore, needs to have
database-level referential integrity constraints, and makes sense to do so.
There are other considerations such as whether there are data logs or work
queues involved that have specific performance and backup needs, but those
are the major reasons.
> Could anybody please help
> TIA
> Roger
>|||When a query is processed by SQL Server, it requires miliseconds to compile
the execution plan. Whether this is a performance issue depends on the case
usage of the SP. If this SP is called 10,000 times per day, or several times
per second, then yes it can reduce the compile time and is probably more a
scalability issue. However, if this is a SP used for reporting purposes,
occasional data inserts (few times per hour), etc. calling as a SP will not
impact the runtime performance. In other words, a query that takes 2 minutes
to execute from the application will not be reduced to 2 seconds simply
because it has been re-written as a SP. Your time is better spent optimizing
the structure of the query itself.
However, from an architectural perspective, I believe that queries
(especially insert / update / delete queries) should be implemented as SPs.
This shifts business logic an data modification programming to the server
side where it can be better managed by the DBA. The application tier should
be as lightweight as possible and deal strictly with presentation, user
input, workflow, etc.; espcially if we are talking about a web application.
Whether your tables should be placed in one database or multiple databases
would require knowledge about the nature and relationship of the data. That
said, depending on the volume of data (say 10 GBs or larger), it can be
generally beneficial for performance reasons to archive rarely used
historical data to a seperate database.
"Perl rookie" <anytasks@.gmail.com> wrote in message
news:1107809732.055331.57880@.z14g2000cwz.googlegroups.com...
> I am sql server newbie who is trying to migrating a DB2 system(MF) to
> SQLserver.
> I have a few questions, it would be great if someone can help me out :
> 1. When I am porting the app to sqlserver, is it advisable to make the
> queries to SP or keep it as a regular SQL ? Does SP perform any better
> than SQL ? I have heard that lot of places write only SP, so the
> front-end programmers can just call the SP and get the data.
> 2. I got multiple databases in DB2 (in mainframe ,databases are just
> logical), is it a good idea to create different databases in SQLserver
> or have it in one big database . Pro and cons ?
>
> Could anybody please help
> TIA
> Roger
>|||Thanks a lot Geoff and Johnny . Appreciate ur reply
Wednesday, March 28, 2012
newbie question - multiple databases
Can a single SQL 2000 server run multiple databses
concurrently? Or is it just a one to one ratio? Thanks
Yes a single server can run multiple user database and system databases on a
single sql server
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Andy" <andrew@.eclise-micro.com> wrote in message
news:865801c43222$7ca65950$a301280a@.phx.gbl...
> Can a single SQL 2000 server run multiple databses
> concurrently? Or is it just a one to one ratio? Thanks
|||Thank you Greg
>--Original Message--
>Yes a single server can run multiple user database and
system databases on a
>single sql server
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"Andy" <andrew@.eclise-micro.com> wrote in message
>news:865801c43222$7ca65950$a301280a@.phx.gbl...
>
>.
>
concurrently? Or is it just a one to one ratio? Thanks
Yes a single server can run multiple user database and system databases on a
single sql server
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Andy" <andrew@.eclise-micro.com> wrote in message
news:865801c43222$7ca65950$a301280a@.phx.gbl...
> Can a single SQL 2000 server run multiple databses
> concurrently? Or is it just a one to one ratio? Thanks
|||Thank you Greg
>--Original Message--
>Yes a single server can run multiple user database and
system databases on a
>single sql server
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"Andy" <andrew@.eclise-micro.com> wrote in message
>news:865801c43222$7ca65950$a301280a@.phx.gbl...
>
>.
>
newbie question - multiple databases
Can a single SQL 2000 server run multiple databses
concurrently? Or is it just a one to one ratio? ThanksYes a single server can run multiple user database and system databases on a
single sql server
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Andy" <andrew@.eclise-micro.com> wrote in message
news:865801c43222$7ca65950$a301280a@.phx.gbl...
> Can a single SQL 2000 server run multiple databses
> concurrently? Or is it just a one to one ratio? Thanks|||Thank you Greg
>--Original Message--
>Yes a single server can run multiple user database and
system databases on a
>single sql server
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"Andy" <andrew@.eclise-micro.com> wrote in message
>news:865801c43222$7ca65950$a301280a@.phx.gbl...
>> Can a single SQL 2000 server run multiple databses
>> concurrently? Or is it just a one to one ratio? Thanks
>
>.
>
concurrently? Or is it just a one to one ratio? ThanksYes a single server can run multiple user database and system databases on a
single sql server
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Andy" <andrew@.eclise-micro.com> wrote in message
news:865801c43222$7ca65950$a301280a@.phx.gbl...
> Can a single SQL 2000 server run multiple databses
> concurrently? Or is it just a one to one ratio? Thanks|||Thank you Greg
>--Original Message--
>Yes a single server can run multiple user database and
system databases on a
>single sql server
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"Andy" <andrew@.eclise-micro.com> wrote in message
>news:865801c43222$7ca65950$a301280a@.phx.gbl...
>> Can a single SQL 2000 server run multiple databses
>> concurrently? Or is it just a one to one ratio? Thanks
>
>.
>
newbie question - multiple databases
Can a single SQL 2000 server run multiple databses
concurrently? Or is it just a one to one ratio? ThanksYes a single server can run multiple user database and system databases on a
single sql server
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Andy" <andrew@.eclise-micro.com> wrote in message
news:865801c43222$7ca65950$a301280a@.phx.gbl...
> Can a single SQL 2000 server run multiple databses
> concurrently? Or is it just a one to one ratio? Thanks|||Thank you Greg
>--Original Message--
>Yes a single server can run multiple user database and
system databases on a
>single sql server
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"Andy" <andrew@.eclise-micro.com> wrote in message
>news:865801c43222$7ca65950$a301280a@.phx.gbl...
>
>.
>
concurrently? Or is it just a one to one ratio? ThanksYes a single server can run multiple user database and system databases on a
single sql server
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Andy" <andrew@.eclise-micro.com> wrote in message
news:865801c43222$7ca65950$a301280a@.phx.gbl...
> Can a single SQL 2000 server run multiple databses
> concurrently? Or is it just a one to one ratio? Thanks|||Thank you Greg
>--Original Message--
>Yes a single server can run multiple user database and
system databases on a
>single sql server
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"Andy" <andrew@.eclise-micro.com> wrote in message
>news:865801c43222$7ca65950$a301280a@.phx.gbl...
>
>.
>
Monday, March 26, 2012
Newbie question - disk defrag
Hi all
Please ignore my lack of knowledge, im new to sql...
I would like to defrag my sql databases and have found several sources on
the net that recommend using the command DBCC INDEXDEFRAG.
When I try and run this from the command prompt i get DBCC is not a
recognised command? Do I need something additional installed or do i not
run this from a command prompt?
Many thanks
This is a SQL Server command, not an operating system command. So you run it from, for instance,
Query analyzer, SQL Server Management Studio, OSQL, SQLCMD etc.
Also, make sure you read this first:
http://msdn.microsoft.com/library/en...server2000.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Si" <Si@.discussions.microsoft.com> wrote in message
news:B964ED96-1F06-4801-BBF9-43A7867D4D6B@.microsoft.com...
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i not
> run this from a command prompt?
> Many thanks
|||Si wrote:
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i not
> run this from a command prompt?
> Many thanks
DBCC is a T-SQL command, which you execute within Query
Analyzer/Management Studio...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Please ignore my lack of knowledge, im new to sql...
I would like to defrag my sql databases and have found several sources on
the net that recommend using the command DBCC INDEXDEFRAG.
When I try and run this from the command prompt i get DBCC is not a
recognised command? Do I need something additional installed or do i not
run this from a command prompt?
Many thanks
This is a SQL Server command, not an operating system command. So you run it from, for instance,
Query analyzer, SQL Server Management Studio, OSQL, SQLCMD etc.
Also, make sure you read this first:
http://msdn.microsoft.com/library/en...server2000.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Si" <Si@.discussions.microsoft.com> wrote in message
news:B964ED96-1F06-4801-BBF9-43A7867D4D6B@.microsoft.com...
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i not
> run this from a command prompt?
> Many thanks
|||Si wrote:
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i not
> run this from a command prompt?
> Many thanks
DBCC is a T-SQL command, which you execute within Query
Analyzer/Management Studio...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Newbie question - disk defrag
Hi all
Please ignore my lack of knowledge, im new to sql...
I would like to defrag my sql databases and have found several sources on
the net that recommend using the command DBCC INDEXDEFRAG.
When I try and run this from the command prompt i get DBCC is not a
recognised command? Do I need something additional installed or do i not
run this from a command prompt?
Many thanksThis is a SQL Server command, not an operating system command. So you run it
from, for instance,
Query analyzer, SQL Server Management Studio, OSQL, SQLCMD etc.
Also, make sure you read this first:
http://msdn.microsoft.com/library/e...000.a
sp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Si" <Si@.discussions.microsoft.com> wrote in message
news:B964ED96-1F06-4801-BBF9-43A7867D4D6B@.microsoft.com...
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i no
t
> run this from a command prompt?
> Many thanks|||Si wrote:
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i no
t
> run this from a command prompt?
> Many thanks
DBCC is a T-SQL command, which you execute within Query
Analyzer/Management Studio...
Tracy McKibben
MCDBA
http://www.realsqlguy.comsql
Please ignore my lack of knowledge, im new to sql...
I would like to defrag my sql databases and have found several sources on
the net that recommend using the command DBCC INDEXDEFRAG.
When I try and run this from the command prompt i get DBCC is not a
recognised command? Do I need something additional installed or do i not
run this from a command prompt?
Many thanksThis is a SQL Server command, not an operating system command. So you run it
from, for instance,
Query analyzer, SQL Server Management Studio, OSQL, SQLCMD etc.
Also, make sure you read this first:
http://msdn.microsoft.com/library/e...000.a
sp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Si" <Si@.discussions.microsoft.com> wrote in message
news:B964ED96-1F06-4801-BBF9-43A7867D4D6B@.microsoft.com...
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i no
t
> run this from a command prompt?
> Many thanks|||Si wrote:
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i no
t
> run this from a command prompt?
> Many thanks
DBCC is a T-SQL command, which you execute within Query
Analyzer/Management Studio...
Tracy McKibben
MCDBA
http://www.realsqlguy.comsql
Newbie question - disk defrag
Hi all
Please ignore my lack of knowledge, im new to sql...
I would like to defrag my sql databases and have found several sources on
the net that recommend using the command DBCC INDEXDEFRAG.
When I try and run this from the command prompt i get DBCC is not a
recognised command? Do I need something additional installed or do i not
run this from a command prompt?
Many thanksThis is a SQL Server command, not an operating system command. So you run it from, for instance,
Query analyzer, SQL Server Management Studio, OSQL, SQLCMD etc.
Also, make sure you read this first:
http://msdn.microsoft.com/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Si" <Si@.discussions.microsoft.com> wrote in message
news:B964ED96-1F06-4801-BBF9-43A7867D4D6B@.microsoft.com...
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i not
> run this from a command prompt?
> Many thanks|||Si wrote:
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i not
> run this from a command prompt?
> Many thanks
DBCC is a T-SQL command, which you execute within Query
Analyzer/Management Studio...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Please ignore my lack of knowledge, im new to sql...
I would like to defrag my sql databases and have found several sources on
the net that recommend using the command DBCC INDEXDEFRAG.
When I try and run this from the command prompt i get DBCC is not a
recognised command? Do I need something additional installed or do i not
run this from a command prompt?
Many thanksThis is a SQL Server command, not an operating system command. So you run it from, for instance,
Query analyzer, SQL Server Management Studio, OSQL, SQLCMD etc.
Also, make sure you read this first:
http://msdn.microsoft.com/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Si" <Si@.discussions.microsoft.com> wrote in message
news:B964ED96-1F06-4801-BBF9-43A7867D4D6B@.microsoft.com...
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i not
> run this from a command prompt?
> Many thanks|||Si wrote:
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i not
> run this from a command prompt?
> Many thanks
DBCC is a T-SQL command, which you execute within Query
Analyzer/Management Studio...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Newbie Question
How can you create a relationship between two tables in two different databases? Or can you?
Thanks... Sorry if it is a simple question..You can't create cross database RI...
You'll need to use triggers...
Thanks... Sorry if it is a simple question..You can't create cross database RI...
You'll need to use triggers...
Newbie question
Apolgies if this seems obvious.
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age
_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?Seems that either the object doesn=B4t exist or you are connected to the
wrong database (ont the object surely doesn=B4t exists there). Try to
check this.
HTH, Jens Suessmeyer.|||Who is the owner of the table? If it is not dbo you need to specify who the
owner is. Actually it is always a good idea to specify the owner even if it
is dbo.
FROM [YourOwner].[ascis_acadyear_setup]
Andrew J. Kelly SQL MVP
"Allison" <,> wrote in message
news:44007a16$0$6995$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can connect to Northwind and Pubs (the samples) and do simple selections
> on them. At work we have a personnel database which I am tesing at home.
> I can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [a
ge_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>|||>>Very sorry for offending you - newbies need help not a slapped wrist
I can't speak for Jens but I believe his reply was quite polite with no
'slapping' intended. As you can see, he is trying to help you in your other
thread.
Multi-posting is a common mistake newbies make and it's appropriate to point
this out so that it can be avoided it in the future. With multiple
independent threads, there's a lot of duplicate effort going on to help you
out.
If you need to post the same question to different forums, you can
cross-post by specify multiple newsgroups in the list and replies will
appear in the all the forums posted.
Hope this helps.
Dan Guzman
SQL Server MVP
"Allison" <,> wrote in message
news:440086ed$0$6962$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1140883638.016887.92390@.e56g2000cwe.googlegroups.com...
>
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age
_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?Seems that either the object doesn=B4t exist or you are connected to the
wrong database (ont the object surely doesn=B4t exists there). Try to
check this.
HTH, Jens Suessmeyer.|||Who is the owner of the table? If it is not dbo you need to specify who the
owner is. Actually it is always a good idea to specify the owner even if it
is dbo.
FROM [YourOwner].[ascis_acadyear_setup]
Andrew J. Kelly SQL MVP
"Allison" <,> wrote in message
news:44007a16$0$6995$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can connect to Northwind and Pubs (the samples) and do simple selections
> on them. At work we have a personnel database which I am tesing at home.
> I can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [a
ge_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>|||>>Very sorry for offending you - newbies need help not a slapped wrist
I can't speak for Jens but I believe his reply was quite polite with no
'slapping' intended. As you can see, he is trying to help you in your other
thread.
Multi-posting is a common mistake newbies make and it's appropriate to point
this out so that it can be avoided it in the future. With multiple
independent threads, there's a lot of duplicate effort going on to help you
out.
If you need to post the same question to different forums, you can
cross-post by specify multiple newsgroups in the list and replies will
appear in the all the forums posted.
Hope this helps.
Dan Guzman
SQL Server MVP
"Allison" <,> wrote in message
news:440086ed$0$6962$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1140883638.016887.92390@.e56g2000cwe.googlegroups.com...
>
Newbie Question
Hi
1. Is it possible to chage the authentication mode of the sa for one
database only
2. How do you do that anyway (for all databases in one server)
thanks
Samnope, the login autentication is for server access, after that, there is the
database user to authorize or not ascess to a specific database.
what you can do, is to create a new instance of sql server with just the spe
cific database tha you wanna manage.
"S Shulman" wrote:
> Hi
> 1. Is it possible to chage the authentication mode of the sa for one
> database only
> 2. How do you do that anyway (for all databases in one server)
> thanks
> Sam
>
>
1. Is it possible to chage the authentication mode of the sa for one
database only
2. How do you do that anyway (for all databases in one server)
thanks
Samnope, the login autentication is for server access, after that, there is the
database user to authorize or not ascess to a specific database.
what you can do, is to create a new instance of sql server with just the spe
cific database tha you wanna manage.
"S Shulman" wrote:
> Hi
> 1. Is it possible to chage the authentication mode of the sa for one
> database only
> 2. How do you do that anyway (for all databases in one server)
> thanks
> Sam
>
>
Friday, March 23, 2012
Newbie question
Apolgies if this seems obvious.
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?
Seems that either the object doesn=B4t exist or you are connected to the
wrong database (ont the object surely doesn=B4t exists there). Try to
check this.
HTH, Jens Suessmeyer.
|||Who is the owner of the table? If it is not dbo you need to specify who the
owner is. Actually it is always a good idea to specify the owner even if it
is dbo.
FROM [YourOwner].[ascis_acadyear_setup]
Andrew J. Kelly SQL MVP
"Allison" <,> wrote in message
news:44007a16$0$6995$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can connect to Northwind and Pubs (the samples) and do simple selections
> on them. At work we have a personnel database which I am tesing at home.
> I can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>
|||>>Very sorry for offending you - newbies need help not a slapped wrist
I can't speak for Jens but I believe his reply was quite polite with no
'slapping' intended. As you can see, he is trying to help you in your other
thread.
Multi-posting is a common mistake newbies make and it's appropriate to point
this out so that it can be avoided it in the future. With multiple
independent threads, there's a lot of duplicate effort going on to help you
out.
If you need to post the same question to different forums, you can
cross-post by specify multiple newsgroups in the list and replies will
appear in the all the forums posted.
Hope this helps.
Dan Guzman
SQL Server MVP
"Allison" <,> wrote in message
news:440086ed$0$6962$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1140883638.016887.92390@.e56g2000cwe.googlegro ups.com...
>
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?
Seems that either the object doesn=B4t exist or you are connected to the
wrong database (ont the object surely doesn=B4t exists there). Try to
check this.
HTH, Jens Suessmeyer.
|||Who is the owner of the table? If it is not dbo you need to specify who the
owner is. Actually it is always a good idea to specify the owner even if it
is dbo.
FROM [YourOwner].[ascis_acadyear_setup]
Andrew J. Kelly SQL MVP
"Allison" <,> wrote in message
news:44007a16$0$6995$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can connect to Northwind and Pubs (the samples) and do simple selections
> on them. At work we have a personnel database which I am tesing at home.
> I can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>
|||>>Very sorry for offending you - newbies need help not a slapped wrist
I can't speak for Jens but I believe his reply was quite polite with no
'slapping' intended. As you can see, he is trying to help you in your other
thread.
Multi-posting is a common mistake newbies make and it's appropriate to point
this out so that it can be avoided it in the future. With multiple
independent threads, there's a lot of duplicate effort going on to help you
out.
If you need to post the same question to different forums, you can
cross-post by specify multiple newsgroups in the list and replies will
appear in the all the forums posted.
Hope this helps.
Dan Guzman
SQL Server MVP
"Allison" <,> wrote in message
news:440086ed$0$6962$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1140883638.016887.92390@.e56g2000cwe.googlegro ups.com...
>
Newbie Question
I have 3 busines applications that will be porting to SQL server. Can I size
a SQL server to house the 3 databases and the associated programs on the same
box? Or should I put up a SQL box and have the apps on a seperate server? We
are a small company so the IT budget is small so I'm looking for the most
cost effective solution. But I'm also concerned about the single point of
failure this will create. Any suggestions would be appreciated.
Thanks,
rwbeck
"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> I have 3 busines applications that will be porting to SQL server. Can I
size
> a SQL server to house the 3 databases and the associated programs on the
same
> box? Or should I put up a SQL box and have the apps on a seperate server?
We
> are a small company so the IT budget is small so I'm looking for the most
> cost effective solution. But I'm also concerned about the single point of
> failure this will create. Any suggestions would be appreciated.
> Thanks,
> rwbeck
How big are the databases? How much activity will be going on in those
systems? How much activity in the front-end applications?
Depending on what and how the front-end is developed, you may have many
different points of "single point of failure".
The best answer is to use Tier 1 hardware for your production environment.
If it is small and fairly low in activity, then you can put it all on the
same box. You should continually monitor your SQL Server's performance to
ensure that everything is operating and playing well together. If the SQL
Server is being starved for memory or CPU cycles etc., then you may want to
start looking at a multi-box solution. It is all about balancing.
Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
Perform a sample disaster recovery, and I'm not just talking about restoring
the database on the same server. Pretend you had a fire in the building and
have to rebuild a new server from scratch. Where is the s/w located for
the O/S, SQL Server etc. Where are the backups of your current software
packages that runs on this system. How will it connect to it's users
(remember we had a "fire" in the building and lost everying in the
building.). How long does it take to truly recover. Write it all down in
a disaster recovery plan.
HTH
Rick Sawtell
|||Thank you for the input. I'm providing answers to the questions you posted.
Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
are in one all day(Case management/contact management). The second is
accessed concurrently by no more than 10 users. The third is time and billing
which is accessed sporadically throughout the day. The hardware will
definitely be tier 1.
Do you think it is feasible to house 3 DBs of that size on one tier 1
server? As far as sizing, using the requirements of each application do we
double up or is there some basic formula we can reference to help with sizing
a server for this type of deployment.
Are there any other sources you think I should reference that would help?
Thanks again.
Rwbeck
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> size
> same
> We
>
> How big are the databases? How much activity will be going on in those
> systems? How much activity in the front-end applications?
> Depending on what and how the front-end is developed, you may have many
> different points of "single point of failure".
> The best answer is to use Tier 1 hardware for your production environment.
> If it is small and fairly low in activity, then you can put it all on the
> same box. You should continually monitor your SQL Server's performance to
> ensure that everything is operating and playing well together. If the SQL
> Server is being starved for memory or CPU cycles etc., then you may want to
> start looking at a multi-box solution. It is all about balancing.
> Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
> Perform a sample disaster recovery, and I'm not just talking about restoring
> the database on the same server. Pretend you had a fire in the building and
> have to rebuild a new server from scratch. Where is the s/w located for
> the O/S, SQL Server etc. Where are the backups of your current software
> packages that runs on this system. How will it connect to it's users
> (remember we had a "fire" in the building and lost everying in the
> building.). How long does it take to truly recover. Write it all down in
> a disaster recovery plan.
> HTH
> Rick Sawtell
>
>
|||"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> Thank you for the input. I'm providing answers to the questions you
posted.
> Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
> are in one all day(Case management/contact management). The second is
> accessed concurrently by no more than 10 users. The third is time and
billing
> which is accessed sporadically throughout the day. The hardware will
> definitely be tier 1.
> Do you think it is feasible to house 3 DBs of that size on one tier 1
> server? As far as sizing, using the requirements of each application do we
> double up or is there some basic formula we can reference to help with
sizing
> a server for this type of deployment.
> Are there any other sources you think I should reference that would help?
> Thanks again.
> Rwbeck
>
Those databases are relatively small and if you are simply doing contact
management and case management, then I would say that those systems are very
lightweight. The billing application may see some activity if it is
performing calculations, or doing heavy reporting, but with so few users on
the system, I would not worry about this impacting performance much.
As far as sizing your server etc. there are many different books of SQL
Server Administration. Pick one that you like and read through it. Once
you have a good understanding of what SQL Server does behind the scenes you
will be able to make better choices. This website is a gold-mine of great
information http://www.sql-server-performance.com/ Check it out.
HTH
Rick Sawtell
|||Really appreciate your help!
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> posted.
> billing
> sizing
> Those databases are relatively small and if you are simply doing contact
> management and case management, then I would say that those systems are very
> lightweight. The billing application may see some activity if it is
> performing calculations, or doing heavy reporting, but with so few users on
> the system, I would not worry about this impacting performance much.
> As far as sizing your server etc. there are many different books of SQL
> Server Administration. Pick one that you like and read through it. Once
> you have a good understanding of what SQL Server does behind the scenes you
> will be able to make better choices. This website is a gold-mine of great
> information http://www.sql-server-performance.com/ Check it out.
> HTH
> Rick Sawtell
>
>
sql
a SQL server to house the 3 databases and the associated programs on the same
box? Or should I put up a SQL box and have the apps on a seperate server? We
are a small company so the IT budget is small so I'm looking for the most
cost effective solution. But I'm also concerned about the single point of
failure this will create. Any suggestions would be appreciated.
Thanks,
rwbeck
"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> I have 3 busines applications that will be porting to SQL server. Can I
size
> a SQL server to house the 3 databases and the associated programs on the
same
> box? Or should I put up a SQL box and have the apps on a seperate server?
We
> are a small company so the IT budget is small so I'm looking for the most
> cost effective solution. But I'm also concerned about the single point of
> failure this will create. Any suggestions would be appreciated.
> Thanks,
> rwbeck
How big are the databases? How much activity will be going on in those
systems? How much activity in the front-end applications?
Depending on what and how the front-end is developed, you may have many
different points of "single point of failure".
The best answer is to use Tier 1 hardware for your production environment.
If it is small and fairly low in activity, then you can put it all on the
same box. You should continually monitor your SQL Server's performance to
ensure that everything is operating and playing well together. If the SQL
Server is being starved for memory or CPU cycles etc., then you may want to
start looking at a multi-box solution. It is all about balancing.
Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
Perform a sample disaster recovery, and I'm not just talking about restoring
the database on the same server. Pretend you had a fire in the building and
have to rebuild a new server from scratch. Where is the s/w located for
the O/S, SQL Server etc. Where are the backups of your current software
packages that runs on this system. How will it connect to it's users
(remember we had a "fire" in the building and lost everying in the
building.). How long does it take to truly recover. Write it all down in
a disaster recovery plan.
HTH
Rick Sawtell
|||Thank you for the input. I'm providing answers to the questions you posted.
Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
are in one all day(Case management/contact management). The second is
accessed concurrently by no more than 10 users. The third is time and billing
which is accessed sporadically throughout the day. The hardware will
definitely be tier 1.
Do you think it is feasible to house 3 DBs of that size on one tier 1
server? As far as sizing, using the requirements of each application do we
double up or is there some basic formula we can reference to help with sizing
a server for this type of deployment.
Are there any other sources you think I should reference that would help?
Thanks again.
Rwbeck
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> size
> same
> We
>
> How big are the databases? How much activity will be going on in those
> systems? How much activity in the front-end applications?
> Depending on what and how the front-end is developed, you may have many
> different points of "single point of failure".
> The best answer is to use Tier 1 hardware for your production environment.
> If it is small and fairly low in activity, then you can put it all on the
> same box. You should continually monitor your SQL Server's performance to
> ensure that everything is operating and playing well together. If the SQL
> Server is being starved for memory or CPU cycles etc., then you may want to
> start looking at a multi-box solution. It is all about balancing.
> Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
> Perform a sample disaster recovery, and I'm not just talking about restoring
> the database on the same server. Pretend you had a fire in the building and
> have to rebuild a new server from scratch. Where is the s/w located for
> the O/S, SQL Server etc. Where are the backups of your current software
> packages that runs on this system. How will it connect to it's users
> (remember we had a "fire" in the building and lost everying in the
> building.). How long does it take to truly recover. Write it all down in
> a disaster recovery plan.
> HTH
> Rick Sawtell
>
>
|||"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> Thank you for the input. I'm providing answers to the questions you
posted.
> Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
> are in one all day(Case management/contact management). The second is
> accessed concurrently by no more than 10 users. The third is time and
billing
> which is accessed sporadically throughout the day. The hardware will
> definitely be tier 1.
> Do you think it is feasible to house 3 DBs of that size on one tier 1
> server? As far as sizing, using the requirements of each application do we
> double up or is there some basic formula we can reference to help with
sizing
> a server for this type of deployment.
> Are there any other sources you think I should reference that would help?
> Thanks again.
> Rwbeck
>
Those databases are relatively small and if you are simply doing contact
management and case management, then I would say that those systems are very
lightweight. The billing application may see some activity if it is
performing calculations, or doing heavy reporting, but with so few users on
the system, I would not worry about this impacting performance much.
As far as sizing your server etc. there are many different books of SQL
Server Administration. Pick one that you like and read through it. Once
you have a good understanding of what SQL Server does behind the scenes you
will be able to make better choices. This website is a gold-mine of great
information http://www.sql-server-performance.com/ Check it out.
HTH
Rick Sawtell
|||Really appreciate your help!
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> posted.
> billing
> sizing
> Those databases are relatively small and if you are simply doing contact
> management and case management, then I would say that those systems are very
> lightweight. The billing application may see some activity if it is
> performing calculations, or doing heavy reporting, but with so few users on
> the system, I would not worry about this impacting performance much.
> As far as sizing your server etc. there are many different books of SQL
> Server Administration. Pick one that you like and read through it. Once
> you have a good understanding of what SQL Server does behind the scenes you
> will be able to make better choices. This website is a gold-mine of great
> information http://www.sql-server-performance.com/ Check it out.
> HTH
> Rick Sawtell
>
>
sql
Newbie question
Apolgies if this seems obvious.
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?
It's possible that the object owner is not yourself or dbo. Try the
following:
select
table_schema
from
information_schema.tables
where
table_name = 'ascis_acadyear_setup'
This will tell you who the owner is. Then use two-part naming:
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [TheOwner].[ascis_acadyear_setup]
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Allison" <,> wrote in message
news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
Apolgies if this seems obvious.
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?
|||Please do not multipost, answered in connect.
HTH, jens Suessmeyer.
|||"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140883638.016887.92390@.e56g2000cwe.googlegro ups.com...
> Please do not multipost, answered in connect.
> HTH, jens Suessmeyer.
>Very sorry for offending you - newbies need help not a slapped wrist
|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>
|||>>Very sorry for offending you - newbies need help not a slapped wrist
I can't speak for Jens but I believe his reply was quite polite with no
'slapping' intended. As you can see, he is trying to help you in your other
thread.
Multi-posting is a common mistake newbies make and it's appropriate to point
this out so that it can be avoided it in the future. With multiple
independent threads, there's a lot of duplicate effort going on to help you
out.
If you need to post the same question to different forums, you can
cross-post by specify multiple newsgroups in the list and replies will
appear in the all the forums posted.
Hope this helps.
Dan Guzman
SQL Server MVP
"Allison" <,> wrote in message
news:440086ed$0$6962$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1140883638.016887.92390@.e56g2000cwe.googlegro ups.com...
>
|||?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Allison" <,> wrote in message
news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>
|||I think she thanked you (just kind of hidden):
[vbcol=seagreen]
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>
>
|||Thanx, Adam. It was buried in there somewhere.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23QiIKVmOGHA.1088@.tk2msftngp13.phx.gbl...
I think she thanked you (just kind of hidden):
[vbcol=seagreen]
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>
>
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?
It's possible that the object owner is not yourself or dbo. Try the
following:
select
table_schema
from
information_schema.tables
where
table_name = 'ascis_acadyear_setup'
This will tell you who the owner is. Then use two-part naming:
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [TheOwner].[ascis_acadyear_setup]
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Allison" <,> wrote in message
news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
Apolgies if this seems obvious.
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?
|||Please do not multipost, answered in connect.
HTH, jens Suessmeyer.
|||"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140883638.016887.92390@.e56g2000cwe.googlegro ups.com...
> Please do not multipost, answered in connect.
> HTH, jens Suessmeyer.
>Very sorry for offending you - newbies need help not a slapped wrist
|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>
|||>>Very sorry for offending you - newbies need help not a slapped wrist
I can't speak for Jens but I believe his reply was quite polite with no
'slapping' intended. As you can see, he is trying to help you in your other
thread.
Multi-posting is a common mistake newbies make and it's appropriate to point
this out so that it can be avoided it in the future. With multiple
independent threads, there's a lot of duplicate effort going on to help you
out.
If you need to post the same question to different forums, you can
cross-post by specify multiple newsgroups in the list and replies will
appear in the all the forums posted.
Hope this helps.
Dan Guzman
SQL Server MVP
"Allison" <,> wrote in message
news:440086ed$0$6962$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1140883638.016887.92390@.e56g2000cwe.googlegro ups.com...
>
|||?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Allison" <,> wrote in message
news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>
|||I think she thanked you (just kind of hidden):
[vbcol=seagreen]
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>
>
|||Thanx, Adam. It was buried in there somewhere.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23QiIKVmOGHA.1088@.tk2msftngp13.phx.gbl...
I think she thanked you (just kind of hidden):
[vbcol=seagreen]
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>
>
Newbie Question
I have 3 busines applications that will be porting to SQL server. Can I size
a SQL server to house the 3 databases and the associated programs on the sam
e
box? Or should I put up a SQL box and have the apps on a seperate server? We
are a small company so the IT budget is small so I'm looking for the most
cost effective solution. But I'm also concerned about the single point of
failure this will create. Any suggestions would be appreciated.
Thanks,
rwbeck"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> I have 3 busines applications that will be porting to SQL server. Can I
size
> a SQL server to house the 3 databases and the associated programs on the
same
> box? Or should I put up a SQL box and have the apps on a seperate server?
We
> are a small company so the IT budget is small so I'm looking for the most
> cost effective solution. But I'm also concerned about the single point of
> failure this will create. Any suggestions would be appreciated.
> Thanks,
> rwbeck
How big are the databases? How much activity will be going on in those
systems? How much activity in the front-end applications?
Depending on what and how the front-end is developed, you may have many
different points of "single point of failure".
The best answer is to use Tier 1 hardware for your production environment.
If it is small and fairly low in activity, then you can put it all on the
same box. You should continually monitor your SQL Server's performance to
ensure that everything is operating and playing well together. If the SQL
Server is being starved for memory or CPU cycles etc., then you may want to
start looking at a multi-box solution. It is all about balancing.
Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
Perform a sample disaster recovery, and I'm not just talking about restoring
the database on the same server. Pretend you had a fire in the building and
have to rebuild a new server from scratch. Where is the s/w located for
the O/S, SQL Server etc. Where are the backups of your current software
packages that runs on this system. How will it connect to it's users
(remember we had a "fire" in the building and lost everying in the
building.). How long does it take to truly recover. Write it all down in
a disaster recovery plan.
HTH
Rick Sawtell|||Thank you for the input. I'm providing answers to the questions you posted.
Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
are in one all day(Case management/contact management). The second is
accessed concurrently by no more than 10 users. The third is time and billin
g
which is accessed sporadically throughout the day. The hardware will
definitely be tier 1.
Do you think it is feasible to house 3 DBs of that size on one tier 1
server? As far as sizing, using the requirements of each application do we
double up or is there some basic formula we can reference to help with sizin
g
a server for this type of deployment.
Are there any other sources you think I should reference that would help?
Thanks again.
Rwbeck
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> size
> same
> We
>
> How big are the databases? How much activity will be going on in those
> systems? How much activity in the front-end applications?
> Depending on what and how the front-end is developed, you may have many
> different points of "single point of failure".
> The best answer is to use Tier 1 hardware for your production environment.
> If it is small and fairly low in activity, then you can put it all on the
> same box. You should continually monitor your SQL Server's performance t
o
> ensure that everything is operating and playing well together. If the SQL
> Server is being starved for memory or CPU cycles etc., then you may want t
o
> start looking at a multi-box solution. It is all about balancing.
> Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
> Perform a sample disaster recovery, and I'm not just talking about restori
ng
> the database on the same server. Pretend you had a fire in the building a
nd
> have to rebuild a new server from scratch. Where is the s/w located for
> the O/S, SQL Server etc. Where are the backups of your current software
> packages that runs on this system. How will it connect to it's users
> (remember we had a "fire" in the building and lost everying in the
> building.). How long does it take to truly recover. Write it all down
in
> a disaster recovery plan.
> HTH
> Rick Sawtell
>
>|||"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> Thank you for the input. I'm providing answers to the questions you
posted.
> Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
> are in one all day(Case management/contact management). The second is
> accessed concurrently by no more than 10 users. The third is time and
billing
> which is accessed sporadically throughout the day. The hardware will
> definitely be tier 1.
> Do you think it is feasible to house 3 DBs of that size on one tier 1
> server? As far as sizing, using the requirements of each application do we
> double up or is there some basic formula we can reference to help with
sizing
> a server for this type of deployment.
> Are there any other sources you think I should reference that would help?
> Thanks again.
> Rwbeck
>
Those databases are relatively small and if you are simply doing contact
management and case management, then I would say that those systems are very
lightweight. The billing application may see some activity if it is
performing calculations, or doing heavy reporting, but with so few users on
the system, I would not worry about this impacting performance much.
As far as sizing your server etc. there are many different books of SQL
Server Administration. Pick one that you like and read through it. Once
you have a good understanding of what SQL Server does behind the scenes you
will be able to make better choices. This website is a gold-mine of great
information http://www.sql-server-performance.com/ Check it out.
HTH
Rick Sawtell|||Really appreciate your help!
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> posted.
> billing
> sizing
> Those databases are relatively small and if you are simply doing contact
> management and case management, then I would say that those systems are ve
ry
> lightweight. The billing application may see some activity if it is
> performing calculations, or doing heavy reporting, but with so few users o
n
> the system, I would not worry about this impacting performance much.
> As far as sizing your server etc. there are many different books of SQL
> Server Administration. Pick one that you like and read through it. Onc
e
> you have a good understanding of what SQL Server does behind the scenes yo
u
> will be able to make better choices. This website is a gold-mine of grea
t
> information http://www.sql-server-performance.com/ Check it out.
> HTH
> Rick Sawtell
>
>
a SQL server to house the 3 databases and the associated programs on the sam
e
box? Or should I put up a SQL box and have the apps on a seperate server? We
are a small company so the IT budget is small so I'm looking for the most
cost effective solution. But I'm also concerned about the single point of
failure this will create. Any suggestions would be appreciated.
Thanks,
rwbeck"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> I have 3 busines applications that will be porting to SQL server. Can I
size
> a SQL server to house the 3 databases and the associated programs on the
same
> box? Or should I put up a SQL box and have the apps on a seperate server?
We
> are a small company so the IT budget is small so I'm looking for the most
> cost effective solution. But I'm also concerned about the single point of
> failure this will create. Any suggestions would be appreciated.
> Thanks,
> rwbeck
How big are the databases? How much activity will be going on in those
systems? How much activity in the front-end applications?
Depending on what and how the front-end is developed, you may have many
different points of "single point of failure".
The best answer is to use Tier 1 hardware for your production environment.
If it is small and fairly low in activity, then you can put it all on the
same box. You should continually monitor your SQL Server's performance to
ensure that everything is operating and playing well together. If the SQL
Server is being starved for memory or CPU cycles etc., then you may want to
start looking at a multi-box solution. It is all about balancing.
Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
Perform a sample disaster recovery, and I'm not just talking about restoring
the database on the same server. Pretend you had a fire in the building and
have to rebuild a new server from scratch. Where is the s/w located for
the O/S, SQL Server etc. Where are the backups of your current software
packages that runs on this system. How will it connect to it's users
(remember we had a "fire" in the building and lost everying in the
building.). How long does it take to truly recover. Write it all down in
a disaster recovery plan.
HTH
Rick Sawtell|||Thank you for the input. I'm providing answers to the questions you posted.
Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
are in one all day(Case management/contact management). The second is
accessed concurrently by no more than 10 users. The third is time and billin
g
which is accessed sporadically throughout the day. The hardware will
definitely be tier 1.
Do you think it is feasible to house 3 DBs of that size on one tier 1
server? As far as sizing, using the requirements of each application do we
double up or is there some basic formula we can reference to help with sizin
g
a server for this type of deployment.
Are there any other sources you think I should reference that would help?
Thanks again.
Rwbeck
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> size
> same
> We
>
> How big are the databases? How much activity will be going on in those
> systems? How much activity in the front-end applications?
> Depending on what and how the front-end is developed, you may have many
> different points of "single point of failure".
> The best answer is to use Tier 1 hardware for your production environment.
> If it is small and fairly low in activity, then you can put it all on the
> same box. You should continually monitor your SQL Server's performance t
o
> ensure that everything is operating and playing well together. If the SQL
> Server is being starved for memory or CPU cycles etc., then you may want t
o
> start looking at a multi-box solution. It is all about balancing.
> Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
> Perform a sample disaster recovery, and I'm not just talking about restori
ng
> the database on the same server. Pretend you had a fire in the building a
nd
> have to rebuild a new server from scratch. Where is the s/w located for
> the O/S, SQL Server etc. Where are the backups of your current software
> packages that runs on this system. How will it connect to it's users
> (remember we had a "fire" in the building and lost everying in the
> building.). How long does it take to truly recover. Write it all down
in
> a disaster recovery plan.
> HTH
> Rick Sawtell
>
>|||"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> Thank you for the input. I'm providing answers to the questions you
posted.
> Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
> are in one all day(Case management/contact management). The second is
> accessed concurrently by no more than 10 users. The third is time and
billing
> which is accessed sporadically throughout the day. The hardware will
> definitely be tier 1.
> Do you think it is feasible to house 3 DBs of that size on one tier 1
> server? As far as sizing, using the requirements of each application do we
> double up or is there some basic formula we can reference to help with
sizing
> a server for this type of deployment.
> Are there any other sources you think I should reference that would help?
> Thanks again.
> Rwbeck
>
Those databases are relatively small and if you are simply doing contact
management and case management, then I would say that those systems are very
lightweight. The billing application may see some activity if it is
performing calculations, or doing heavy reporting, but with so few users on
the system, I would not worry about this impacting performance much.
As far as sizing your server etc. there are many different books of SQL
Server Administration. Pick one that you like and read through it. Once
you have a good understanding of what SQL Server does behind the scenes you
will be able to make better choices. This website is a gold-mine of great
information http://www.sql-server-performance.com/ Check it out.
HTH
Rick Sawtell|||Really appreciate your help!
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> posted.
> billing
> sizing
> Those databases are relatively small and if you are simply doing contact
> management and case management, then I would say that those systems are ve
ry
> lightweight. The billing application may see some activity if it is
> performing calculations, or doing heavy reporting, but with so few users o
n
> the system, I would not worry about this impacting performance much.
> As far as sizing your server etc. there are many different books of SQL
> Server Administration. Pick one that you like and read through it. Onc
e
> you have a good understanding of what SQL Server does behind the scenes yo
u
> will be able to make better choices. This website is a gold-mine of grea
t
> information http://www.sql-server-performance.com/ Check it out.
> HTH
> Rick Sawtell
>
>
Newbie question
Apolgies if this seems obvious.
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age
_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?It's possible that the object owner is not yourself or dbo. Try the
following:
select
table_schema
from
information_schema.tables
where
table_name = 'ascis_acadyear_setup'
This will tell you who the owner is. Then use two-part naming:
SELECT [acadyear_setup_id], [narrative], [census_date], [age
_as_at_date]
FROM [TheOwner].[ascis_acadyear_setup]
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Allison" <,> wrote in message
news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
Apolgies if this seems obvious.
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age
_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?|||Please do not multipost, answered in connect.
HTH, jens Suessmeyer.|||"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140883638.016887.92390@.e56g2000cwe.googlegroups.com...
> Please do not multipost, answered in connect.
> HTH, jens Suessmeyer.
>Very sorry for offending you - newbies need help not a slapped wrist|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [a
ge_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [a
ge_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>|||>>Very sorry for offending you - newbies need help not a slapped wrist
I can't speak for Jens but I believe his reply was quite polite with no
'slapping' intended. As you can see, he is trying to help you in your other
thread.
Multi-posting is a common mistake newbies make and it's appropriate to point
this out so that it can be avoided it in the future. With multiple
independent threads, there's a lot of duplicate effort going on to help you
out.
If you need to post the same question to different forums, you can
cross-post by specify multiple newsgroups in the list and replies will
appear in the all the forums posted.
Hope this helps.
Dan Guzman
SQL Server MVP
"Allison" <,> wrote in message
news:440086ed$0$6962$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1140883638.016887.92390@.e56g2000cwe.googlegroups.com...
>|||?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Allison" <,> wrote in message
news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [a
ge_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [a
ge_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>|||I think she thanked you (just kind of hidden):
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>
>|||Thanx, Adam. It was buried in there somewhere.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23QiIKVmOGHA.1088@.tk2msftngp13.phx.gbl...
I think she thanked you (just kind of hidden):
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>
>sql
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age
_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?It's possible that the object owner is not yourself or dbo. Try the
following:
select
table_schema
from
information_schema.tables
where
table_name = 'ascis_acadyear_setup'
This will tell you who the owner is. Then use two-part naming:
SELECT [acadyear_setup_id], [narrative], [census_date], [age
_as_at_date]
FROM [TheOwner].[ascis_acadyear_setup]
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Allison" <,> wrote in message
news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
Apolgies if this seems obvious.
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age
_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?|||Please do not multipost, answered in connect.
HTH, jens Suessmeyer.|||"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140883638.016887.92390@.e56g2000cwe.googlegroups.com...
> Please do not multipost, answered in connect.
> HTH, jens Suessmeyer.
>Very sorry for offending you - newbies need help not a slapped wrist|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [a
ge_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [a
ge_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>|||>>Very sorry for offending you - newbies need help not a slapped wrist
I can't speak for Jens but I believe his reply was quite polite with no
'slapping' intended. As you can see, he is trying to help you in your other
thread.
Multi-posting is a common mistake newbies make and it's appropriate to point
this out so that it can be avoided it in the future. With multiple
independent threads, there's a lot of duplicate effort going on to help you
out.
If you need to post the same question to different forums, you can
cross-post by specify multiple newsgroups in the list and replies will
appear in the all the forums posted.
Hope this helps.
Dan Guzman
SQL Server MVP
"Allison" <,> wrote in message
news:440086ed$0$6962$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1140883638.016887.92390@.e56g2000cwe.googlegroups.com...
>|||?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Allison" <,> wrote in message
news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [a
ge_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [a
ge_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>|||I think she thanked you (just kind of hidden):
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>
>|||Thanx, Adam. It was buried in there somewhere.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23QiIKVmOGHA.1088@.tk2msftngp13.phx.gbl...
I think she thanked you (just kind of hidden):
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>
>sql
Newbie question
Apolgies if this seems obvious.
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?It's possible that the object owner is not yourself or dbo. Try the
following:
select
table_schema
from
information_schema.tables
where
table_name = 'ascis_acadyear_setup'
This will tell you who the owner is. Then use two-part naming:
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [TheOwner].[ascis_acadyear_setup]
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Allison" <,> wrote in message
news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
Apolgies if this seems obvious.
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?|||Please do not multipost, answered in connect.
HTH, jens Suessmeyer.|||"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140883638.016887.92390@.e56g2000cwe.googlegroups.com...
> Please do not multipost, answered in connect.
> HTH, jens Suessmeyer.
>Very sorry for offending you - newbies need help not a slapped wrist|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>|||>>Very sorry for offending you - newbies need help not a slapped wrist
I can't speak for Jens but I believe his reply was quite polite with no
'slapping' intended. As you can see, he is trying to help you in your other
thread.
Multi-posting is a common mistake newbies make and it's appropriate to point
this out so that it can be avoided it in the future. With multiple
independent threads, there's a lot of duplicate effort going on to help you
out.
If you need to post the same question to different forums, you can
cross-post by specify multiple newsgroups in the list and replies will
appear in the all the forums posted.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Allison" <,> wrote in message
news:440086ed$0$6962$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1140883638.016887.92390@.e56g2000cwe.googlegroups.com...
>> Please do not multipost, answered in connect.
>> HTH, jens Suessmeyer.
>>Very sorry for offending you - newbies need help not a slapped wrist
>|||?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Allison" <,> wrote in message
news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>|||I think she thanked you (just kind of hidden):
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .Thank you this worked first time
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>> It's possible that the object owner is not yourself or dbo. Try the
>> following:
>> select
>> table_schema
>> from
>> information_schema.tables
>> where
>> table_name = 'ascis_acadyear_setup'
>> This will tell you who the owner is. Then use two-part naming:
>> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
>> FROM [TheOwner].[ascis_acadyear_setup]
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .Thank you this worked first time
>> "Allison" <,> wrote in message
>> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
>> Apolgies if this seems obvious.
>> I am using Visual Studio and experimenting with SQL server databases. I
>> can
>> connect to Northwind and Pubs (the samples) and do simple selections on
>> them. At work we have a personnel database which I am tesing at home. I
>> can connect to it and explore the contents but when I run this
>> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
>> FROM [ascis_acadyear_setup]
>> I get the error invlaid object name ascis_acadyear_setup
>> What am I doing wrong?
>>
>|||Thanx, Adam. It was buried in there somewhere.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23QiIKVmOGHA.1088@.tk2msftngp13.phx.gbl...
I think she thanked you (just kind of hidden):
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .Thank you this worked first time
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>> It's possible that the object owner is not yourself or dbo. Try the
>> following:
>> select
>> table_schema
>> from
>> information_schema.tables
>> where
>> table_name = 'ascis_acadyear_setup'
>> This will tell you who the owner is. Then use two-part naming:
>> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
>> FROM [TheOwner].[ascis_acadyear_setup]
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .Thank you this worked first time
>> "Allison" <,> wrote in message
>> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
>> Apolgies if this seems obvious.
>> I am using Visual Studio and experimenting with SQL server databases. I
>> can
>> connect to Northwind and Pubs (the samples) and do simple selections on
>> them. At work we have a personnel database which I am tesing at home. I
>> can connect to it and explore the contents but when I run this
>> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
>> FROM [ascis_acadyear_setup]
>> I get the error invlaid object name ascis_acadyear_setup
>> What am I doing wrong?
>>
>
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?It's possible that the object owner is not yourself or dbo. Try the
following:
select
table_schema
from
information_schema.tables
where
table_name = 'ascis_acadyear_setup'
This will tell you who the owner is. Then use two-part naming:
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [TheOwner].[ascis_acadyear_setup]
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Allison" <,> wrote in message
news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
Apolgies if this seems obvious.
I am using Visual Studio and experimenting with SQL server databases. I can
connect to Northwind and Pubs (the samples) and do simple selections on
them. At work we have a personnel database which I am tesing at home. I
can connect to it and explore the contents but when I run this
SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
FROM [ascis_acadyear_setup]
I get the error invlaid object name ascis_acadyear_setup
What am I doing wrong?|||Please do not multipost, answered in connect.
HTH, jens Suessmeyer.|||"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140883638.016887.92390@.e56g2000cwe.googlegroups.com...
> Please do not multipost, answered in connect.
> HTH, jens Suessmeyer.
>Very sorry for offending you - newbies need help not a slapped wrist|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>|||>>Very sorry for offending you - newbies need help not a slapped wrist
I can't speak for Jens but I believe his reply was quite polite with no
'slapping' intended. As you can see, he is trying to help you in your other
thread.
Multi-posting is a common mistake newbies make and it's appropriate to point
this out so that it can be avoided it in the future. With multiple
independent threads, there's a lot of duplicate effort going on to help you
out.
If you need to post the same question to different forums, you can
cross-post by specify multiple newsgroups in the list and replies will
appear in the all the forums posted.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Allison" <,> wrote in message
news:440086ed$0$6962$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1140883638.016887.92390@.e56g2000cwe.googlegroups.com...
>> Please do not multipost, answered in connect.
>> HTH, jens Suessmeyer.
>>Very sorry for offending you - newbies need help not a slapped wrist
>|||?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Allison" <,> wrote in message
news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
> It's possible that the object owner is not yourself or dbo. Try the
> following:
> select
> table_schema
> from
> information_schema.tables
> where
> table_name = 'ascis_acadyear_setup'
> This will tell you who the owner is. Then use two-part naming:
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [TheOwner].[ascis_acadyear_setup]
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .Thank you this worked first time
> "Allison" <,> wrote in message
> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
> Apolgies if this seems obvious.
> I am using Visual Studio and experimenting with SQL server databases. I
> can
> connect to Northwind and Pubs (the samples) and do simple selections on
> them. At work we have a personnel database which I am tesing at home. I
> can connect to it and explore the contents but when I run this
> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
> FROM [ascis_acadyear_setup]
> I get the error invlaid object name ascis_acadyear_setup
> What am I doing wrong?
>|||I think she thanked you (just kind of hidden):
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .Thank you this worked first time
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>> It's possible that the object owner is not yourself or dbo. Try the
>> following:
>> select
>> table_schema
>> from
>> information_schema.tables
>> where
>> table_name = 'ascis_acadyear_setup'
>> This will tell you who the owner is. Then use two-part naming:
>> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
>> FROM [TheOwner].[ascis_acadyear_setup]
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .Thank you this worked first time
>> "Allison" <,> wrote in message
>> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
>> Apolgies if this seems obvious.
>> I am using Visual Studio and experimenting with SQL server databases. I
>> can
>> connect to Northwind and Pubs (the samples) and do simple selections on
>> them. At work we have a personnel database which I am tesing at home. I
>> can connect to it and explore the contents but when I run this
>> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
>> FROM [ascis_acadyear_setup]
>> I get the error invlaid object name ascis_acadyear_setup
>> What am I doing wrong?
>>
>|||Thanx, Adam. It was buried in there somewhere.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23QiIKVmOGHA.1088@.tk2msftngp13.phx.gbl...
I think she thanked you (just kind of hidden):
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .Thank you this worked first time
Allison:
">" indicates a quote. When you want to add text in response, start
your line without that character so that we can tell when the original post
ends and the reply begins.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OhNwSAjOGHA.2012@.TK2MSFTNGP14.phx.gbl...
> ?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Allison" <,> wrote in message
> news:44008a84$0$6993$ed2619ec@.ptn-nntp-reader02.plus.net...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uVMJYMiOGHA.720@.TK2MSFTNGP14.phx.gbl...
>> It's possible that the object owner is not yourself or dbo. Try the
>> following:
>> select
>> table_schema
>> from
>> information_schema.tables
>> where
>> table_name = 'ascis_acadyear_setup'
>> This will tell you who the owner is. Then use two-part naming:
>> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
>> FROM [TheOwner].[ascis_acadyear_setup]
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .Thank you this worked first time
>> "Allison" <,> wrote in message
>> news:44007a2f$0$6981$ed2619ec@.ptn-nntp-reader02.plus.net...
>> Apolgies if this seems obvious.
>> I am using Visual Studio and experimenting with SQL server databases. I
>> can
>> connect to Northwind and Pubs (the samples) and do simple selections on
>> them. At work we have a personnel database which I am tesing at home. I
>> can connect to it and explore the contents but when I run this
>> SELECT [acadyear_setup_id], [narrative], [census_date], [age_as_at_date]
>> FROM [ascis_acadyear_setup]
>> I get the error invlaid object name ascis_acadyear_setup
>> What am I doing wrong?
>>
>
Newbie Question
I have 3 busines applications that will be porting to SQL server. Can I size
a SQL server to house the 3 databases and the associated programs on the same
box? Or should I put up a SQL box and have the apps on a seperate server? We
are a small company so the IT budget is small so I'm looking for the most
cost effective solution. But I'm also concerned about the single point of
failure this will create. Any suggestions would be appreciated.
Thanks,
rwbeck"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> I have 3 busines applications that will be porting to SQL server. Can I
size
> a SQL server to house the 3 databases and the associated programs on the
same
> box? Or should I put up a SQL box and have the apps on a seperate server?
We
> are a small company so the IT budget is small so I'm looking for the most
> cost effective solution. But I'm also concerned about the single point of
> failure this will create. Any suggestions would be appreciated.
> Thanks,
> rwbeck
How big are the databases? How much activity will be going on in those
systems? How much activity in the front-end applications?
Depending on what and how the front-end is developed, you may have many
different points of "single point of failure".
The best answer is to use Tier 1 hardware for your production environment.
If it is small and fairly low in activity, then you can put it all on the
same box. You should continually monitor your SQL Server's performance to
ensure that everything is operating and playing well together. If the SQL
Server is being starved for memory or CPU cycles etc., then you may want to
start looking at a multi-box solution. It is all about balancing.
Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
Perform a sample disaster recovery, and I'm not just talking about restoring
the database on the same server. Pretend you had a fire in the building and
have to rebuild a new server from scratch. Where is the s/w located for
the O/S, SQL Server etc. Where are the backups of your current software
packages that runs on this system. How will it connect to it's users
(remember we had a "fire" in the building and lost everying in the
building.). How long does it take to truly recover. Write it all down in
a disaster recovery plan.
HTH
Rick Sawtell|||Thank you for the input. I'm providing answers to the questions you posted.
Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
are in one all day(Case management/contact management). The second is
accessed concurrently by no more than 10 users. The third is time and billing
which is accessed sporadically throughout the day. The hardware will
definitely be tier 1.
Do you think it is feasible to house 3 DBs of that size on one tier 1
server? As far as sizing, using the requirements of each application do we
double up or is there some basic formula we can reference to help with sizing
a server for this type of deployment.
Are there any other sources you think I should reference that would help?
Thanks again.
Rwbeck
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> > I have 3 busines applications that will be porting to SQL server. Can I
> size
> > a SQL server to house the 3 databases and the associated programs on the
> same
> > box? Or should I put up a SQL box and have the apps on a seperate server?
> We
> > are a small company so the IT budget is small so I'm looking for the most
> > cost effective solution. But I'm also concerned about the single point of
> > failure this will create. Any suggestions would be appreciated.
> > Thanks,
> >
> > rwbeck
>
> How big are the databases? How much activity will be going on in those
> systems? How much activity in the front-end applications?
> Depending on what and how the front-end is developed, you may have many
> different points of "single point of failure".
> The best answer is to use Tier 1 hardware for your production environment.
> If it is small and fairly low in activity, then you can put it all on the
> same box. You should continually monitor your SQL Server's performance to
> ensure that everything is operating and playing well together. If the SQL
> Server is being starved for memory or CPU cycles etc., then you may want to
> start looking at a multi-box solution. It is all about balancing.
> Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
> Perform a sample disaster recovery, and I'm not just talking about restoring
> the database on the same server. Pretend you had a fire in the building and
> have to rebuild a new server from scratch. Where is the s/w located for
> the O/S, SQL Server etc. Where are the backups of your current software
> packages that runs on this system. How will it connect to it's users
> (remember we had a "fire" in the building and lost everying in the
> building.). How long does it take to truly recover. Write it all down in
> a disaster recovery plan.
> HTH
> Rick Sawtell
>
>|||"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> Thank you for the input. I'm providing answers to the questions you
posted.
> Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
> are in one all day(Case management/contact management). The second is
> accessed concurrently by no more than 10 users. The third is time and
billing
> which is accessed sporadically throughout the day. The hardware will
> definitely be tier 1.
> Do you think it is feasible to house 3 DBs of that size on one tier 1
> server? As far as sizing, using the requirements of each application do we
> double up or is there some basic formula we can reference to help with
sizing
> a server for this type of deployment.
> Are there any other sources you think I should reference that would help?
> Thanks again.
> Rwbeck
>
Those databases are relatively small and if you are simply doing contact
management and case management, then I would say that those systems are very
lightweight. The billing application may see some activity if it is
performing calculations, or doing heavy reporting, but with so few users on
the system, I would not worry about this impacting performance much.
As far as sizing your server etc. there are many different books of SQL
Server Administration. Pick one that you like and read through it. Once
you have a good understanding of what SQL Server does behind the scenes you
will be able to make better choices. This website is a gold-mine of great
information http://www.sql-server-performance.com/ Check it out.
HTH
Rick Sawtell|||Really appreciate your help!
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> > Thank you for the input. I'm providing answers to the questions you
> posted.
> >
> > Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
> > are in one all day(Case management/contact management). The second is
> > accessed concurrently by no more than 10 users. The third is time and
> billing
> > which is accessed sporadically throughout the day. The hardware will
> > definitely be tier 1.
> >
> > Do you think it is feasible to house 3 DBs of that size on one tier 1
> > server? As far as sizing, using the requirements of each application do we
> > double up or is there some basic formula we can reference to help with
> sizing
> > a server for this type of deployment.
> >
> > Are there any other sources you think I should reference that would help?
> >
> > Thanks again.
> > Rwbeck
> >
> Those databases are relatively small and if you are simply doing contact
> management and case management, then I would say that those systems are very
> lightweight. The billing application may see some activity if it is
> performing calculations, or doing heavy reporting, but with so few users on
> the system, I would not worry about this impacting performance much.
> As far as sizing your server etc. there are many different books of SQL
> Server Administration. Pick one that you like and read through it. Once
> you have a good understanding of what SQL Server does behind the scenes you
> will be able to make better choices. This website is a gold-mine of great
> information http://www.sql-server-performance.com/ Check it out.
> HTH
> Rick Sawtell
>
>
a SQL server to house the 3 databases and the associated programs on the same
box? Or should I put up a SQL box and have the apps on a seperate server? We
are a small company so the IT budget is small so I'm looking for the most
cost effective solution. But I'm also concerned about the single point of
failure this will create. Any suggestions would be appreciated.
Thanks,
rwbeck"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> I have 3 busines applications that will be porting to SQL server. Can I
size
> a SQL server to house the 3 databases and the associated programs on the
same
> box? Or should I put up a SQL box and have the apps on a seperate server?
We
> are a small company so the IT budget is small so I'm looking for the most
> cost effective solution. But I'm also concerned about the single point of
> failure this will create. Any suggestions would be appreciated.
> Thanks,
> rwbeck
How big are the databases? How much activity will be going on in those
systems? How much activity in the front-end applications?
Depending on what and how the front-end is developed, you may have many
different points of "single point of failure".
The best answer is to use Tier 1 hardware for your production environment.
If it is small and fairly low in activity, then you can put it all on the
same box. You should continually monitor your SQL Server's performance to
ensure that everything is operating and playing well together. If the SQL
Server is being starved for memory or CPU cycles etc., then you may want to
start looking at a multi-box solution. It is all about balancing.
Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
Perform a sample disaster recovery, and I'm not just talking about restoring
the database on the same server. Pretend you had a fire in the building and
have to rebuild a new server from scratch. Where is the s/w located for
the O/S, SQL Server etc. Where are the backups of your current software
packages that runs on this system. How will it connect to it's users
(remember we had a "fire" in the building and lost everying in the
building.). How long does it take to truly recover. Write it all down in
a disaster recovery plan.
HTH
Rick Sawtell|||Thank you for the input. I'm providing answers to the questions you posted.
Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
are in one all day(Case management/contact management). The second is
accessed concurrently by no more than 10 users. The third is time and billing
which is accessed sporadically throughout the day. The hardware will
definitely be tier 1.
Do you think it is feasible to house 3 DBs of that size on one tier 1
server? As far as sizing, using the requirements of each application do we
double up or is there some basic formula we can reference to help with sizing
a server for this type of deployment.
Are there any other sources you think I should reference that would help?
Thanks again.
Rwbeck
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:A7DC6DB7-2123-4F1B-B362-77DE287D1CF9@.microsoft.com...
> > I have 3 busines applications that will be porting to SQL server. Can I
> size
> > a SQL server to house the 3 databases and the associated programs on the
> same
> > box? Or should I put up a SQL box and have the apps on a seperate server?
> We
> > are a small company so the IT budget is small so I'm looking for the most
> > cost effective solution. But I'm also concerned about the single point of
> > failure this will create. Any suggestions would be appreciated.
> > Thanks,
> >
> > rwbeck
>
> How big are the databases? How much activity will be going on in those
> systems? How much activity in the front-end applications?
> Depending on what and how the front-end is developed, you may have many
> different points of "single point of failure".
> The best answer is to use Tier 1 hardware for your production environment.
> If it is small and fairly low in activity, then you can put it all on the
> same box. You should continually monitor your SQL Server's performance to
> ensure that everything is operating and playing well together. If the SQL
> Server is being starved for memory or CPU cycles etc., then you may want to
> start looking at a multi-box solution. It is all about balancing.
> Ensure that you have a good backup and RECOVERY strategy and PRACTICE it.
> Perform a sample disaster recovery, and I'm not just talking about restoring
> the database on the same server. Pretend you had a fire in the building and
> have to rebuild a new server from scratch. Where is the s/w located for
> the O/S, SQL Server etc. Where are the backups of your current software
> packages that runs on this system. How will it connect to it's users
> (remember we had a "fire" in the building and lost everying in the
> building.). How long does it take to truly recover. Write it all down in
> a disaster recovery plan.
> HTH
> Rick Sawtell
>
>|||"rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> Thank you for the input. I'm providing answers to the questions you
posted.
> Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
> are in one all day(Case management/contact management). The second is
> accessed concurrently by no more than 10 users. The third is time and
billing
> which is accessed sporadically throughout the day. The hardware will
> definitely be tier 1.
> Do you think it is feasible to house 3 DBs of that size on one tier 1
> server? As far as sizing, using the requirements of each application do we
> double up or is there some basic formula we can reference to help with
sizing
> a server for this type of deployment.
> Are there any other sources you think I should reference that would help?
> Thanks again.
> Rwbeck
>
Those databases are relatively small and if you are simply doing contact
management and case management, then I would say that those systems are very
lightweight. The billing application may see some activity if it is
performing calculations, or doing heavy reporting, but with so few users on
the system, I would not worry about this impacting performance much.
As far as sizing your server etc. there are many different books of SQL
Server Administration. Pick one that you like and read through it. Once
you have a good understanding of what SQL Server does behind the scenes you
will be able to make better choices. This website is a gold-mine of great
information http://www.sql-server-performance.com/ Check it out.
HTH
Rick Sawtell|||Really appreciate your help!
"Rick Sawtell" wrote:
> "rwbeck" <rwbeck@.discussions.microsoft.com> wrote in message
> news:9067FEAF-604C-41A8-83C4-33967AD48CD9@.microsoft.com...
> > Thank you for the input. I'm providing answers to the questions you
> posted.
> >
> > Each of the 3 DB's are 2-3GB. Two of the three are core apps, all 40 users
> > are in one all day(Case management/contact management). The second is
> > accessed concurrently by no more than 10 users. The third is time and
> billing
> > which is accessed sporadically throughout the day. The hardware will
> > definitely be tier 1.
> >
> > Do you think it is feasible to house 3 DBs of that size on one tier 1
> > server? As far as sizing, using the requirements of each application do we
> > double up or is there some basic formula we can reference to help with
> sizing
> > a server for this type of deployment.
> >
> > Are there any other sources you think I should reference that would help?
> >
> > Thanks again.
> > Rwbeck
> >
> Those databases are relatively small and if you are simply doing contact
> management and case management, then I would say that those systems are very
> lightweight. The billing application may see some activity if it is
> performing calculations, or doing heavy reporting, but with so few users on
> the system, I would not worry about this impacting performance much.
> As far as sizing your server etc. there are many different books of SQL
> Server Administration. Pick one that you like and read through it. Once
> you have a good understanding of what SQL Server does behind the scenes you
> will be able to make better choices. This website is a gold-mine of great
> information http://www.sql-server-performance.com/ Check it out.
> HTH
> Rick Sawtell
>
>
Subscribe to:
Posts (Atom)