Connect to internal SharePoint database from web site.

Hello,
There's information on my Internal SharePoint DataBase that I want to access. How can I do this? Could you help me or at least point me in the right direction.

The information I am requesting is just text.

Thank you,
Mark

Hi Mark,

I don't think so that kind of info is available. The table structure and relationships are quite messy. It's not recommended to access those tables directly, not to say it's prohibited.

I have done a lot of Sharepoint customizations, and what I did was accessing the Sharepoint internal object with it's object model. You can download the WSS SDK (both 2.0 and 3.0), and install it. The help file in the SDK has alot of sample code that we can use.

Happy coding :)

|||

Hi Mark,

I don't think so that kind of info is available. The table structure and relationships are quite messy. It's not recommended to access those tables directly, not to say it's prohibited.

I have done a lot of Sharepoint customizations, and what I did was access the Sharepoint internal object with it's object model. You can download the WSS SDK (both 2.0 and 3.0) are available. There are alot of sample code that we can use.

Happy coding :)

|||

Hi Mark,

I don't think so that kind of info is available. The table structure and relationships are quite messy. It's not recommended to access those tables directly, not to say it's prohibited.

I have done a lot of Sharepoint customizations, and what I did was accessing the Sharepoint internal object with it's object model. You can download the WSS SDK (both 2.0 and 3.0), and install it. The help file in the SDK has alot of sample code that we can use.

Happy coding :)

|||

I am starting to see this now. Thank you for your response.

Configuring a failsafe or backup server

I am not sure exactly which newsgroup to post this to so I will ask here
with the hopes that someone either can answer or at least point me to a
better newsgroup to pose the question.
We have a single SQL Server 2000 server machine. We are increasingly adding
more and more db's and applications and more and more users are depending on
this data being available. We have a sales force and dealers that access the
data remotely 24/7 from varios time zones. Now I am starting to think in
terms of data availability - making sure that if the server goes down or we
need to take the server offline for any period of time, we can move the db's
over either manually or automatically to another server. We do also have a
Win2K small business server that includes SQL server - and it is really
sitting idle so we could use that machine as the backup SQL server in a
pinch. Then we'd have to repoint all users to the new machine which would
allow them to be back up and running again in a decent time frame. Then when
we are back online with the actual SQL Server, the db would have to be
migrated back over...
There are a couple of options I am thinking...
1) to implement a complete failover system so that if one server goes down,
up comes the other one almost instantly? I doubt we really need to go to
this level but perhaps someone could elaborate on exactly what
hardware/software would be needed to implement such a scheme. I am thinking
Win2K3 R2 DFS or a Doubletake solution?
2) Manually backup and restore from one machine to the other and back again
when the other machine is back on line. This would mean that if the SQL
server went down in the afternoon, and we were unable to access the drives
for whatever reason, we would have to restore from the previous nights SQL
server backup (on disk). meaning a loss of almost a full days work
potentially..
What other options are there out there? What have other folks been doing?
Should we be backing up transaction logs every hour possibly? That way we
could restore from previous night and then play back all the transaction
logs to get current within an hour at least...
Thanks, Brad
Log shipping is another option for maintaining a warm
standby. You can write your own and don't necessarily need
to be using SQL Server 2000 Enterprise Edition. That edition
just gives you a GUI to setup and monitor the log shipping.
There are other options - depending on the business needs.
This article does a good job of going though the different
options and their advantages, disadvantages:
http://vyaskn.tripod.com/maintaining_standby_sql_server.htm
-Sue
On Mon, 28 May 2007 16:34:34 -0400, "Brad Pears"
<bradp@.truenorthloghomes.com> wrote:

>I am not sure exactly which newsgroup to post this to so I will ask here
>with the hopes that someone either can answer or at least point me to a
>better newsgroup to pose the question.
>We have a single SQL Server 2000 server machine. We are increasingly adding
>more and more db's and applications and more and more users are depending on
>this data being available. We have a sales force and dealers that access the
>data remotely 24/7 from varios time zones. Now I am starting to think in
>terms of data availability - making sure that if the server goes down or we
>need to take the server offline for any period of time, we can move the db's
>over either manually or automatically to another server. We do also have a
>Win2K small business server that includes SQL server - and it is really
>sitting idle so we could use that machine as the backup SQL server in a
>pinch. Then we'd have to repoint all users to the new machine which would
>allow them to be back up and running again in a decent time frame. Then when
>we are back online with the actual SQL Server, the db would have to be
>migrated back over...
>There are a couple of options I am thinking...
>1) to implement a complete failover system so that if one server goes down,
>up comes the other one almost instantly? I doubt we really need to go to
>this level but perhaps someone could elaborate on exactly what
>hardware/software would be needed to implement such a scheme. I am thinking
>Win2K3 R2 DFS or a Doubletake solution?
>2) Manually backup and restore from one machine to the other and back again
>when the other machine is back on line. This would mean that if the SQL
>server went down in the afternoon, and we were unable to access the drives
>for whatever reason, we would have to restore from the previous nights SQL
>server backup (on disk). meaning a loss of almost a full days work
>potentially..
>What other options are there out there? What have other folks been doing?
>Should we be backing up transaction logs every hour possibly? That way we
>could restore from previous night and then play back all the transaction
>logs to get current within an hour at least...
>Thanks, Brad
>
|||Thanks for that...
Brad
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:vbkm53lfq2197a3ah6tfasd2q2ie875n62@.4ax.com...
> Log shipping is another option for maintaining a warm
> standby. You can write your own and don't necessarily need
> to be using SQL Server 2000 Enterprise Edition. That edition
> just gives you a GUI to setup and monitor the log shipping.
> There are other options - depending on the business needs.
> This article does a good job of going though the different
> options and their advantages, disadvantages:
> http://vyaskn.tripod.com/maintaining_standby_sql_server.htm
> -Sue
> On Mon, 28 May 2007 16:34:34 -0400, "Brad Pears"
> <bradp@.truenorthloghomes.com> wrote:
>

Configuring a failsafe or backup server

I am not sure exactly which newsgroup to post this to so I will ask here
with the hopes that someone either can answer or at least point me to a
better newsgroup to pose the question.
We have a single SQL Server 2000 server machine. We are increasingly adding
more and more db's and applications and more and more users are depending on
this data being available. We have a sales force and dealers that access the
data remotely 24/7 from varios time zones. Now I am starting to think in
terms of data availability - making sure that if the server goes down or we
need to take the server offline for any period of time, we can move the db's
over either manually or automatically to another server. We do also have a
Win2K small business server that includes SQL server - and it is really
sitting idle so we could use that machine as the backup SQL server in a
pinch. Then we'd have to repoint all users to the new machine which would
allow them to be back up and running again in a decent time frame. Then when
we are back online with the actual SQL Server, the db would have to be
migrated back over...
There are a couple of options I am thinking...
1) to implement a complete failover system so that if one server goes down,
up comes the other one almost instantly? I doubt we really need to go to
this level but perhaps someone could elaborate on exactly what
hardware/software would be needed to implement such a scheme. I am thinking
Win2K3 R2 DFS or a Doubletake solution?
2) Manually backup and restore from one machine to the other and back again
when the other machine is back on line. This would mean that if the SQL
server went down in the afternoon, and we were unable to access the drives
for whatever reason, we would have to restore from the previous nights SQL
server backup (on disk). meaning a loss of almost a full days work
potentially..
What other options are there out there? What have other folks been doing?
Should we be backing up transaction logs every hour possibly? That way we
could restore from previous night and then play back all the transaction
logs to get current within an hour at least...
Thanks, BradLog shipping is another option for maintaining a warm
standby. You can write your own and don't necessarily need
to be using SQL Server 2000 Enterprise Edition. That edition
just gives you a GUI to setup and monitor the log shipping.
There are other options - depending on the business needs.
This article does a good job of going though the different
options and their advantages, disadvantages:
http://vyaskn.tripod.com/maintainin..._sql_server.htm
-Sue
On Mon, 28 May 2007 16:34:34 -0400, "Brad Pears"
<bradp@.truenorthloghomes.com> wrote:

>I am not sure exactly which newsgroup to post this to so I will ask here
>with the hopes that someone either can answer or at least point me to a
>better newsgroup to pose the question.
>We have a single SQL Server 2000 server machine. We are increasingly adding
>more and more db's and applications and more and more users are depending o
n
>this data being available. We have a sales force and dealers that access th
e
>data remotely 24/7 from varios time zones. Now I am starting to think in
>terms of data availability - making sure that if the server goes down or we
>need to take the server offline for any period of time, we can move the db'
s
>over either manually or automatically to another server. We do also have a
>Win2K small business server that includes SQL server - and it is really
>sitting idle so we could use that machine as the backup SQL server in a
>pinch. Then we'd have to repoint all users to the new machine which would
>allow them to be back up and running again in a decent time frame. Then whe
n
>we are back online with the actual SQL Server, the db would have to be
>migrated back over...
>There are a couple of options I am thinking...
>1) to implement a complete failover system so that if one server goes down,
>up comes the other one almost instantly? I doubt we really need to go to
>this level but perhaps someone could elaborate on exactly what
>hardware/software would be needed to implement such a scheme. I am thinking
>Win2K3 R2 DFS or a Doubletake solution?
>2) Manually backup and restore from one machine to the other and back again
>when the other machine is back on line. This would mean that if the SQL
>server went down in the afternoon, and we were unable to access the drives
>for whatever reason, we would have to restore from the previous nights SQL
>server backup (on disk). meaning a loss of almost a full days work
>potentially..
>What other options are there out there? What have other folks been doing?
>Should we be backing up transaction logs every hour possibly? That way we
>could restore from previous night and then play back all the transaction
>logs to get current within an hour at least...
>Thanks, Brad
>|||Thanks for that...
Brad
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:vbkm53lfq2197a3ah6tfasd2q2ie875n62@.
4ax.com...
> Log shipping is another option for maintaining a warm
> standby. You can write your own and don't necessarily need
> to be using SQL Server 2000 Enterprise Edition. That edition
> just gives you a GUI to setup and monitor the log shipping.
> There are other options - depending on the business needs.
> This article does a good job of going though the different
> options and their advantages, disadvantages:
> http://vyaskn.tripod.com/maintainin..._sql_server.htm
> -Sue
> On Mon, 28 May 2007 16:34:34 -0400, "Brad Pears"
> <bradp@.truenorthloghomes.com> wrote:
>
>

configuring a database in sqlserver?

I am learning dotnet thru Microsoft Official Curriculum and I got stuck up at one point. That is I couldn't configure the required databases according to the sql server I have installed and configured. I created a doctors database and while configuring using the below code I couldn't know what is '\ASPNET' in "SELECT @.s = @.@.servername + '\ASPNET'"
Also what is 'webuser'

Configure Doctors
USE doctors

GO

DECLARE @.s varchar(50)
SELECT @.s = @.@.servername + '\ASPNET'
EXECUTE sp_grantlogin @.s

EXECUTE sp_grantdbaccess @.s, 'webuser'

GO

GRANT EXECUTE ON [getUniqueCities] TO webuser
GRANT EXECUTE ON [getDrSpecialty] TO webuser

GRANT SELECT ON [specialties] TO webuser
GRANT SELECT ON [doctors] TO webuser
GRANT SELECT ON [drspecialties] TO webuser

GO

Can anyone help me how to solve my problem?
Your help would be very much appreciated

Thanks and Regards

Kavitha

Probably best to consult the TSQL forum.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=85&SiteID=1