New to SQL and Web development

I have been in systems for many years on the admin side, and have had experience working with developers, however I am attempting to start the learning process for creating a data store with a web based UI. I have an understanding of the theories of what
is possible, but I don't know where to start. I have experience with HTML coding and static pages, but nothing that interfaces with a back end.
What are your suggestions of where to start.
This is a great site with lots of good answers to many questions:
http://www.aspfaq.com/
You will find good examples and information out on =
http://www.asp101.com/
--=20
Keith
"Otts73" <sh_tmail@.charter.net> wrote in message =
news:EFF6B423-F1FA-41D1-9139-3929979CCB3F@.microsoft.com...
> I have been in systems for many years on the admin side, and have had =
experience working with developers, however I am attempting to start the =
learning process for creating a data store with a web based UI. I have =
an understanding of the theories of what is possible, but I don't know =
where to start. I have experience with HTML coding and static pages, =
but nothing that interfaces with a back end.
>=20
> What are your suggestions of where to start.
|||As well as Keith's references, you might like to look at
http://www.w3schools.com/ado/default.asp
Regards,
Paul Ibison

New to SQL and Web development

I have been in systems for many years on the admin side, and have had experi
ence working with developers, however I am attempting to start the learning
process for creating a data store with a web based UI. I have an understand
ing of the theories of what
is possible, but I don't know where to start. I have experience with HTML c
oding and static pages, but nothing that interfaces with a back end.
What are your suggestions of where to start.This is a great site with lots of good answers to many questions:
http://www.aspfaq.com/
You will find good examples and information out on =
http://www.asp101.com/
--=20
Keith
"Otts73" <sh_tmail@.charter.net> wrote in message =
news:EFF6B423-F1FA-41D1-9139-3929979CCB3F@.microsoft.com...
> I have been in systems for many years on the admin side, and have had =
experience working with developers, however I am attempting to start the =
learning process for creating a data store with a web based UI. I have =
an understanding of the theories of what is possible, but I don't know =
where to start. I have experience with HTML coding and static pages, =
but nothing that interfaces with a back end.
>=20
> What are your suggestions of where to start.|||As well as Keith's references, you might like to look at
http://www.w3schools.com/ado/default.asp
Regards,
Paul Ibison

New to SQL and Web development

I have been in systems for many years on the admin side, and have had experience working with developers, however I am attempting to start the learning process for creating a data store with a web based UI. I have an understanding of the theories of what is possible, but I don't know where to start. I have experience with HTML coding and static pages, but nothing that interfaces with a back end
What are your suggestions of where to start.This is a great site with lots of good answers to many questions:
http://www.aspfaq.com/
You will find good examples and information out on =http://www.asp101.com/
-- Keith
"Otts73" <sh_tmail@.charter.net> wrote in message =news:EFF6B423-F1FA-41D1-9139-3929979CCB3F@.microsoft.com...
> I have been in systems for many years on the admin side, and have had =experience working with developers, however I am attempting to start the =learning process for creating a data store with a web based UI. I have =an understanding of the theories of what is possible, but I don't know =where to start. I have experience with HTML coding and static pages, =but nothing that interfaces with a back end.
> > What are your suggestions of where to start.|||As well as Keith's references, you might like to look at
http://www.w3schools.com/ado/default.asp
Regards,
Paul Ibisonsql

New to SQL 2005 Express

I haven't used this software except locally on my laptop. If you have built a databased web app using this, how do you deploy the db? Does it have to be installed and/or supported on your webhosting service? If so, it seems to be of limited use, if not, very helpful.

Thanks for the help

To deploy the application, the destination will need to have SQL Server Express installed as well. You can read a detailed article about that here:

http://msdn2.microsoft.com/en-us/library/ms165639.aspx

Buck Woody

|||

That's what I was afraid of....doesn't look as this will be the answer. Back to mysql or MS SQl 2000.

Thanks for the reply!!

TLCoop

|||No problem - but MySQL or MS SQL 2000 will have the same issue, won't it?|||

There might be some confusion here. SQL Express is SQL Server 2005. Your hoster will need to support SQL Server 2005, but they don't have to have SQL Express installed. It's the exact same database file because they are the exact same products, just with different feature sets.

If you're hosting company requires that you upload your database using scripts, we are working on a tool to help do that. You can find a CTP of the tool on CodePlex.

Mike

|||

Thanks Mike,

My host doesn't offer mssql 2005 yet. They do have mssql 2000, and maybe(hopefully)some of sqlexpress2005 is backwards compatible. I can always generate scripts and run a query for db population on mssql 2000. I'll take a look at CodePlex.

I appreciate the help!

Terry

|||

Thanks Buck for the reply. My Host doesn't offer MSSQL 2005 nor SQLExpress 2005 support yet. They offer both MySQl and MS SQL 2000 right now, so I'll try and 'script' a db from express 2005. I appreciate the help.

Terry

New System

I am setting up a web based survey for the personnel in my company and would
like to use SQL. Is this a practical applicaiton for SQL 2000?It doesn't hurt !
It depends upon the size and complexity of Survey, if you want to know if
you are really leveraging SQL 2K power and features.
HTH
Satish Balusa
Corillian Corp.
"Heimann" <gheimann@.heimannonline.com> wrote in message
news:238DE8DB-8F5C-46E0-8941-788B5A3FB8C1@.microsoft.com...

quote:

---

> I am setting up a web based survey for the personnel in my company and

---

would like to use SQL. Is this a practical applicaiton for SQL 2000?

New System

I am setting up a web based survey for the personnel in my company and would like to use SQL. Is this a practical applicaiton for SQL 2000?It doesn't hurt !
It depends upon the size and complexity of Survey, if you want to know if
you are really leveraging SQL 2K power and features.
--
HTH
Satish Balusa
Corillian Corp.
"Heimann" <gheimann@.heimannonline.com> wrote in message
news:238DE8DB-8F5C-46E0-8941-788B5A3FB8C1@.microsoft.com...
> I am setting up a web based survey for the personnel in my company and
would like to use SQL. Is this a practical applicaiton for SQL 2000?sql

New Sqlcommand question??

Hello,

I was trying to do the following:

Dim cmd As SqlCommand
Dim objConnection As SqlConnection
objConnection = New SqlConnection = Web.config

where the We.config is where my connection string is set. but I get a sintax error in the Web.config line.

is it possible to asign the value of the web.config content to the new sql connection?

thanks for any suggestions.

Hi, you can use WebConfigurationManager class to get connection string from web.config. Please refer to this article:

http://msdn2.microsoft.com/en-us/library/system.web.configuration.webconfigurationmanager(d=ide).aspx

new server gives login error URGENT

This is on my web page from a log in:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
trusted SQL Server connection.
/admin/addconn_1.asp, line 7
I have take a new server given it the former IP of the old one, restored the
data from the old one, and done a DTS for transfer of users.
That DTS gives an error, but no details. I can see Error Occured in the
status, and nothing more
Where do I go to next?Hi
Please check out what is sql server's authentication.
Probably you have "windows only" authentication , try to change it to
"mixed"
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
> a trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored
> the data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>|||Do you call the DTS from a job ?
If you do ,an another option is that you have created a package on your
workstation , i mean the owner of the package is not the same as an acount
that SQL Server Agent running under.
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
> Thanks, correct that new box was set as Win only. that has been changed
> to mixed. DTS package still fails after stop & start of service.
> Any other ideas?
> I see the UserID in the actual db for the serve and I see the userid in
> the security login for that server for all dbs.
> Stephen
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>|||Stephen,
Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
windows group on the new server and that you have granted that windows group
appropriate windows permissions.
"__Stephen" wrote:

> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
a
> trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored t
he
> data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>
>|||Thanks Uri, I even went to the cold cellar or server room, and it failed
there as well.
The mixed authentication worked when I fixed the login/pw to be correct. I
hate an old dheap monitor for the server rack!
__Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ux1XGfgEGHA.2040@.TK2MSFTNGP14.phx.gbl...
> Do you call the DTS from a job ?
> If you do ,an another option is that you have created a package on your
> workstation , i mean the owner of the package is not the same as an
> acount that SQL Server Agent running under.
>
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
>|||"Pradeep Gharat" <PradeepGharat@.discussions.microsoft.com> wrote in message
news:63A6D7CC-98DA-4759-A39A-58CE46191F82@.microsoft.com...
> Stephen,
> Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
> windows group on the new server and that you have granted that windows
> group
> appropriate windows permissions.
Actually I don't want to do that. I added the SQL Authentication and it's
running now.

new server gives login error URGENT

This is on my web page from a log in:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
trusted SQL Server connection.
/admin/addconn_1.asp, line 7
I have take a new server given it the former IP of the old one, restored the
data from the old one, and done a DTS for transfer of users.
That DTS gives an error, but no details. I can see Error Occured in the
status, and nothing more
Where do I go to next?
Hi
Please check out what is sql server's authentication.
Probably you have "windows only" authentication , try to change it to
"mixed"
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
> a trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored
> the data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>
|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>
|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>
|||Do you call the DTS from a job ?
If you do ,an another option is that you have created a package on your
workstation , i mean the owner of the package is not the same as an acount
that SQL Server Agent running under.
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
> Thanks, correct that new box was set as Win only. that has been changed
> to mixed. DTS package still fails after stop & start of service.
> Any other ideas?
> I see the UserID in the actual db for the serve and I see the userid in
> the security login for that server for all dbs.
> Stephen
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>
|||Stephen,
Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
windows group on the new server and that you have granted that windows group
appropriate windows permissions.
"__Stephen" wrote:

> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
> trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored the
> data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>
>
|||Thanks Uri, I even went to the cold cellar or server room, and it failed
there as well.
The mixed authentication worked when I fixed the login/pw to be correct. I
hate an old dheap monitor for the server rack!
__Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ux1XGfgEGHA.2040@.TK2MSFTNGP14.phx.gbl...
> Do you call the DTS from a job ?
> If you do ,an another option is that you have created a package on your
> workstation , i mean the owner of the package is not the same as an
> acount that SQL Server Agent running under.
>
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
>
|||"Pradeep Gharat" <PradeepGharat@.discussions.microsoft.com> wrote in message
news:63A6D7CC-98DA-4759-A39A-58CE46191F82@.microsoft.com...
> Stephen,
> Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
> windows group on the new server and that you have granted that windows
> group
> appropriate windows permissions.
Actually I don't want to do that. I added the SQL Authentication and it's
running now.

new server gives login error URGENT

This is on my web page from a log in:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
trusted SQL Server connection.
/admin/addconn_1.asp, line 7
I have take a new server given it the former IP of the old one, restored the
data from the old one, and done a DTS for transfer of users.
That DTS gives an error, but no details. I can see Error Occured in the
status, and nothing more :(
Where do I go to next?Do you have mixed authentication mode on that server?
right click the server-->properties-->security and take a look, is
windows only checked?|||Hi
Please check out what is sql server's authentication.
Probably you have "windows only" authentication , try to change it to
"mixed"
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
> a trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored
> the data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more :(
> Where do I go to next?
>
>|||Seems that your are not using mixed authentication. Try to set the
server to mixed authentication.
HTH, jens Suessmeyer.|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
>> a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one, restored
>> the data from the old one, and done a DTS for transfer of users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in the
>> status, and nothing more :(
>> Where do I go to next?
>>
>>
>|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1136471412.242368.94270@.f14g2000cwb.googlegroups.com...
> Do you have mixed authentication mode on that server?
> right click the server-->properties-->security and take a look, is
> windows only checked?
>|||Thanks
I wasn't using mixed authentication as well as confusing * with " on a fuzzy
server monitor!!
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1136471757.457363.194350@.g14g2000cwa.googlegroups.com...
> Seems that your are not using mixed authentication. Try to set the
> server to mixed authentication.
> HTH, jens Suessmeyer.
>|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
>> a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one, restored
>> the data from the old one, and done a DTS for transfer of users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in the
>> status, and nothing more :(
>> Where do I go to next?
>>
>>
>|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1136471412.242368.94270@.f14g2000cwb.googlegroups.com...
> Do you have mixed authentication mode on that server?
> right click the server-->properties-->security and take a look, is
> windows only checked?
>|||Do you call the DTS from a job ?
If you do ,an another option is that you have created a package on your
workstation , i mean the owner of the package is not the same as an acount
that SQL Server Agent running under.
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
> Thanks, correct that new box was set as Win only. that has been changed
> to mixed. DTS package still fails after stop & start of service.
> Any other ideas?
> I see the UserID in the actual db for the serve and I see the userid in
> the security login for that server for all dbs.
> Stephen
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> Please check out what is sql server's authentication.
>> Probably you have "windows only" authentication , try to change it to
>> "mixed"
>>
>> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
>> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated
>> with a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one, restored
>> the data from the old one, and done a DTS for transfer of users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in the
>> status, and nothing more :(
>> Where do I go to next?
>>
>>
>>
>|||Stephen,
Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
windows group on the new server and that you have granted that windows group
appropriate windows permissions.
"__Stephen" wrote:
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
> trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored the
> data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more :(
> Where do I go to next?
>
>
>|||Thanks Uri, I even went to the cold cellar or server room, and it failed
there as well.
The mixed authentication worked when I fixed the login/pw to be correct. I
hate an old dheap monitor for the server rack!
__Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ux1XGfgEGHA.2040@.TK2MSFTNGP14.phx.gbl...
> Do you call the DTS from a job ?
> If you do ,an another option is that you have created a package on your
> workstation , i mean the owner of the package is not the same as an
> acount that SQL Server Agent running under.
>
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
>> Thanks, correct that new box was set as Win only. that has been changed
>> to mixed. DTS package still fails after stop & start of service.
>> Any other ideas?
>> I see the UserID in the actual db for the serve and I see the userid in
>> the security login for that server for all dbs.
>> Stephen
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> Please check out what is sql server's authentication.
>> Probably you have "windows only" authentication , try to change it to
>> "mixed"
>>
>> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
>> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated
>> with a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one,
>> restored the data from the old one, and done a DTS for transfer of
>> users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in
>> the status, and nothing more :(
>> Where do I go to next?
>>
>>
>>
>>
>|||"Pradeep Gharat" <PradeepGharat@.discussions.microsoft.com> wrote in message
news:63A6D7CC-98DA-4759-A39A-58CE46191F82@.microsoft.com...
> Stephen,
> Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
> windows group on the new server and that you have granted that windows
> group
> appropriate windows permissions.
Actually I don't want to do that. I added the SQL Authentication and it's
running now.

new Reporting Services

I just read an article online about SQL Server Reporting Services. Any
sense of whether this functionality can be embeded in an ASP.NET web
application? The article made it sound like you'd have to go to a separate
web page in order to view the reports ...
http://www.sqlmag.com/articles/index.cfm?articleid=40529
Thanks in advance.
MarkYes you can. Have a look at the developer samples (if you are on B2). They
include a ReportViewer Sample ASP.NET Server Control for integrating
Reporting Services reports in a Web application. RS is basically a web
service so you can do pretty much what you want with it. Flexibility and
extensibility are key features
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mark" <mfield@.idonotlikespam.cce.umn.edu> wrote in message
news:uOCOw7rsDHA.2408@.tk2msftngp13.phx.gbl...
I just read an article online about SQL Server Reporting Services. Any
sense of whether this functionality can be embeded in an ASP.NET web
application? The article made it sound like you'd have to go to a separate
web page in order to view the reports ...
http://www.sqlmag.com/articles/index.cfm?articleid=40529
Thanks in advance.
Mark

New Query with Current Connection

I am missing "New Query with Current Connection" button in SQL Editor in the
SQL management studio. Few posts on the Web refer explain that this button
should allow me to open a new query in the existing window.
I've checked "Add Remove Buttons" for SQL editor but I still cannot find it.
Any ideas?
Bojan Kuhar wrote:
> I am missing "New Query with Current Connection" button in SQL Editor in the
> SQL management studio. Few posts on the Web refer explain that this button
> should allow me to open a new query in the existing window.
> I've checked "Add Remove Buttons" for SQL editor but I still cannot find it.
> Any ideas?
I'm not sure it can be done, but "Ctrl-N" will give you the "New query
with current connection".
Regards
Steen
|||Fantastic.
Now, one more. Is there something like "Open Query with Current Connection".
I'd like to avoid the Connect to Database Enginde dialog.
More-less like Qury Analyzer that allows you to open a new query in the
existing window.
Regards
Bojan
"Steen Persson (DK)" wrote:

> Bojan Kuhar wrote:
> I'm not sure it can be done, but "Ctrl-N" will give you the "New query
> with current connection".
> Regards
> Steen
>
|||My fault. The button was called New Query with Current Connection in one of
the betas. The released version renamed it to New Query. I changed most of
the references, but I missed a few. I think I got rid of them all by web
release 1 of Books Online though.
The New Query button will use the connection that has focus when you click
it. Either Object Explorer, or an existing Query Editor window. If your
current context has no connection, then it will pop up the Connect to Server
dialog box.
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Bojan Kuhar" <BojanKuhar@.discussions.microsoft.com> wrote in message
news:01230DB5-BEE5-4452-B89E-470DCCE488F2@.microsoft.com...
>I am missing "New Query with Current Connection" button in SQL Editor in
>the
> SQL management studio. Few posts on the Web refer explain that this
> button
> should allow me to open a new query in the existing window.
> I've checked "Add Remove Buttons" for SQL editor but I still cannot find
> it.
> Any ideas?
|||Bojan Kuhar (BojanKuhar@.discussions.microsoft.com) writes:
> Fantastic.
> Now, one more. Is there something like "Open Query with Current
> Connection". I'd like to avoid the Connect to Database Enginde dialog.
> More-less like Qury Analyzer that allows you to open a new query in the
> existing window.
What Steen said, CTRL-N is the key. Provided one thing: under Tools->
Options->Keyboard select SQL 2000 instead of Standard.
The New Query button also works if you are in a query window or Object
Explorer, and so does File->New->Query with Current Connection.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

New Log or append?

I'm backing into the DBA position from being an app / web designer. Using SQL 2005 and hating wizards, I'm trying to code a BACKUP LOG query to run every 15 minutes and create a separate date-time-stamped TRN. I have several questions starting with - should I be doing this? Is it better to create separate LOGs or append to one? Isn't it true that the only time I'll need the LOGs is when I have a crash and that then I'll need to RESTORE in date-time-order?

I'm doing a FULL backup every 6 hours and intend on automating deleting the TRNs on a successful completion of the BAK.

The following code runs fine and creates a date-time-stamped TRN but doesn't do what I want, as it overwrites the first TRN, so how do I create, say, four JOBSTEPs and get a JOBSTEP @.COMMAND to run the SETs?

USE msdb

IFEXISTS(SELECTNameFROM sysjobs WHEREName='jobDBBackupWedb_1Log')

EXECsp_delete_job @.job_name ='jobDBBackupWedb_1Log'

GO

DECLARE @.now char(14)-- current date in the form of yyyymmddhhmmss

DECLARE @.dbName sysname-- database name to include date-time-stamp

DECLARE @.Cmd nvarchar(260)-- variable used to build JobStep command

SET @.now =REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(50),GETDATE(), 120),'-',''),' ',''),':','')

SET @.dbName ='Wedb_1_'+ @.now +'_.trn'

SET @.Cmd ='BACKUP LOG Wedb_1 TO DISK = '+CHAR(39)+'\\SERVER1\D$\SQLDatabases\Backup\WebEoc\'+ @.dbName +CHAR(39)

EXECsp_add_job

@.Job_Name ='jobDBBackupWedb_1Log',

@.Description ='Run Wedb_1 DB Backup Transaction Log Every 15 Minutes',

@.Category_Name ='Database Maintenance'

EXECsp_add_jobstep

@.Job_Name ='jobDBBackupWedb_1Log',

@.step_name ='DB_Backup_Log',

@.step_id = 1,

@.Database_Name ='Master',

@.subsystem ='TSQL',

@.command = @.Cmd

/*

Start time for the Transaction Log backups is seven and one half minutes after midnight

to not conflict with the Full database backups run every 6 hours starting at midnight.

The Transaction Log backups are to be run every fifteen minutes.

*/

EXECsp_Add_JobSchedule

@.Job_Name ='jobDBBackupWedb_1Log',

@.Name ='schedDB_BackupLog',

@.Freq_Type = 4,-- Daily

@.Freq_Interval = 1,-- Each day

@.Freq_Subday_Type = 0x4,-- Interval in minutes

@.Freq_Subday_Interval = 15,-- Every fifteen minutes

@.Active_Start_Time = 000730 -- Start Time is seven and one half minutes after midnight

--@.Active_End_Time = 235959 -- End Time is next midnight

EXECsp_Add_JobServer

@.Job_Name ='jobDBBackupWedb_1Log'

GO

My opinion, I'd create DB Maint Plans to do database and trans log backups, and not write my own, unless there is some real good reason to. Main plans aren't perfect, but still better then trying to reproduce the same end result. One of the points of backing up the trans log is for disaster recovery. You could backup your trans log every 30 minutes, then copy/move those backups off to a different server/tape, etc... So, I wouldn't stack them on one file, becuase you need to move them continually to a different box, or yea, backup cross server, ehhhh.... I prefer local backups and then copying them somewhere else, like with RoboCopy. The times you nee the trans logs are for recovery, or to do log shipping to a different server (similar concept to database mirroring, but still more in use then mirroring is I think). If doing a full backup every 6 hours, same thing, back it up and move it off somewhere safe, not leave that on teh same drives as your database files! I'd still leave the old TRN files on teh other location, there COULD be a case where you need to go back 9 hours, then you'd have the old trans and backups to get there, I wouldnt delete the TRN files every 6 hours as you said.

Bruce

|||

Thanks ... but ...

I'm backing up to a separate / different network drive on a different / separate server that my network admin has established as a SANs - Storage Area Network - drive. That SANs drive is data specific and is being snap-shot-backed-up every 5 minutes. Then it goes to tape every night at 11:00 PM.

The nature of the DB is that the WebEoc is for running the SEOC - State Emergency Operations Center - during hurricanes, earthquakes, etc.

|||

I think that the problem with your original script is that you are creating the backup command when you create the job rather than dynamically creating and executing the command when executing the job.

Try the re-worked version below.

Chris

Code Snippet

USE msdb

IF EXISTS ( SELECT Name
FROM sysjobs
WHERE Name = 'jobDBBackupWedb_1Log' )
EXEC sp_delete_job @.job_name = 'jobDBBackupWedb_1Log'

GO

DECLARE @.cmd NVARCHAR(3201)

SET @.cmd = N'DECLARE @.sql VARCHAR(8000)

DECLARE @.now char(14)
-- current date in the form of yyyymmddhhmmss

DECLARE @.dbName sysname
-- database name to include date-time-stamp

SET @.now = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(50), GETDATE(), 120), ''-'',
''''), '' '', ''''), '':'', '''')

SET @.dbName = ''Wedb_1_'' + @.now + ''_.trn''

SET @.sql = ''BACKUP LOG Wedb_1 TO DISK = '' + CHAR(39)
+ ''\\SERVER1\D$\SQLDatabases\Backup\WebEoc\'' + @.dbName + CHAR(39)

EXEC(@.sql)'
EXEC sp_add_job @.Job_Name = 'jobDBBackupWedb_1Log',
@.Description = 'Run Wedb_1 DB Backup Transaction Log Every 15 Minutes',
@.Category_Name = 'Database Maintenance'

EXEC sp_add_jobstep @.Job_Name = 'jobDBBackupWedb_1Log',
@.step_name = 'DB_Backup_Log', @.step_id = 1, @.Database_Name = 'Master',
@.subsystem = 'TSQL', @.command = @.Cmd

/*

Start time for the Transaction Log backups is seven and one half minutes after midnight

to not conflict with the Full database backups run every 6 hours starting at midnight.

The Transaction Log backups are to be run every fifteen minutes.

*/

EXEC sp_Add_JobSchedule @.Job_Name = 'jobDBBackupWedb_1Log',
@.Name = 'schedDB_BackupLog', @.Freq_Type = 4, -- Daily
@.Freq_Interval = 1, -- Each day
@.Freq_Subday_Type = 0x4, -- Interval in minutes
@.Freq_Subday_Interval = 15, -- Every fifteen minutes
@.Active_Start_Time = 000730
-- Start Time is seven and one half minutes after midnight

--@.Active_End_Time = 235959 -- End Time is next midnight

EXEC sp_Add_JobServer @.Job_Name = 'jobDBBackupWedb_1Log'

GO

|||

Chris,

Thank you very kindly! I take your comment about run-time, create/execute; that was spot on. Thanks for the code change - works like a charm ...

... but, I've looked and not found an answer, what is the "N" doing for me in SET @.cmd = N'DECLARE ... ?

Is it declaring that what follows is all an NVARCHAR string?

New in SQL Server 2000

Iam new in SQL Server 2000 & Preior i have knowledge in Oracle ,Ms Access. I want to learn Server 2000 Can any body guide me for any web site where i can lean how to make relationship in Tables in a database,How to impliment Constrant,How to make cursor & Apply Triger...?
Thanks aain advance...Try The Holy Book (http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp)

New Id

I am using Microsoft Visual Studios 2005 Pro creating a web form in asp.net with a vb.net code page. I am trying to get the id of a newly inserted record. I am using the sqldatasource insert command to insert the record. Does anybody know how to return the new id. during the insert? Thanks, Any help is appreciated

there are basically 2 ways of doing that.

1. Create ID before you do insert using something like SELECT Max(id) +1 FROM ... Use this approach if you ID field is not set as a identity column

2. If your id field is an identity field then you can write a stored procedure that inserts the record and then you do something like

SET @.ID = scope_identity()

Where @.ID is your output parameter or you can return it as a return value.

|||

Here is a modified sample from Quickstarts tutorial with inline SQL for insert (ContactID is the Identity field of the table):

ProtectedSub SqlDataSource1_Inserted(ByVal senderAsObject,ByVal eAs System.Web.UI.WebControls.SqlDataSourceStatusEventArgs)

Response.Write("Record Inserted: " + Server.HtmlEncode(e.Command.Parameters("@.ContactID").Value.ToString()) +"<br/>")

EndSub

<asp:GridViewAutoGenerateColumns="False"DataKeyNames="ContactID"DataSourceID="SqlDataSource1"

ID="GridView1"runat="server">

<Columns>

<asp:CommandFieldShowDeleteButton="True"/>

<asp:BoundFieldDataField="ContactID"HeaderText="ContactID"InsertVisible="False"

ReadOnly="True"SortExpression="ContactID"/>

<asp:BoundFieldDataField="ContactName"HeaderText="ContactName"SortExpression="ContactName"/>

</Columns>

</asp:GridView>

<asp:SqlDataSourceConnectionString="<%$ ConnectionStrings:MSDN_forumConnectionString %>"ID="SqlDataSource1"

runat="server"SelectCommand="select ContactID, ContactName from Contacts"

InsertCommand="INSERT INTO Contacts (ContactName) VALUES (@.contactName);SELECT @.contactID = Scope_Identity()"

OnInserted="SqlDataSource1_Inserted"DeleteCommand="DELETE FROM Contacts WHERE ContactID = @.ContactID">

<InsertParameters>

<asp:ParameterName="contactName"Type="String"/>

<asp:ParameterDirection="Output"Name="contactID"Type="Int32"/>

</InsertParameters>

<DeleteParameters>

<asp:ParameterName="ContactID"/>

</DeleteParameters>

</asp:SqlDataSource>

<br/>

<asp:DetailsViewAutoGenerateRows="False"DataKeyNames="ContactID"DataSourceID="SqlDataSource1"

DefaultMode="Insert"HeaderText="Insert New Contact"Height="50px"ID="DetailsView1"

runat="server"Width="125px">

<Fields>

<asp:BoundFieldDataField="ContactID"HeaderText="ContactID"InsertVisible="False"

ReadOnly="True"SortExpression="ContactID"/>

<asp:BoundFieldDataField="ContactName"HeaderText="ContactName"SortExpression="ContactName"/>

<asp:CommandFieldShowInsertButton="True"/>

</Fields>

</asp:DetailsView>

|||

orka777:

there are basically 2 ways of doing that.

1. Create ID before you do insert using something like SELECT Max(id) +1 FROM ... Use this approach if you ID field is not set as a identity column

2. If your id field is an identity field then you can write a stored procedure that inserts the record and then you do something like

SET @.ID = scope_identity()

Where @.ID is your output parameter or you can return it as a return value.

For Number 1, is correct but might no be that good even it will do the job for you.

For Number 2, the code should be like:

1SET @.MyIdentity =@.@.IDENTITY

Where @.MyIdentity in an output parameter of type int.

Here I prefere to not return the identity of the inserted record as an output parameter, I perefere to return it using the Return statment in the stored procedure., like:

1CREATE PROCEDURE MySP23AS45SET NOCOUNT ON67declare MyIdentityint-- as a normal variable in the stored procedure body89Insert Into MyTable (col1, col2)values ('A','B')10SET @.MyIdentity =ISNULL(@.@.IDENTITY,-1)-- if no record is inserted then you will get -1111213Return @.MyIdentity1415SET NOCOUNT OFF16

Good luck.|||

I am trying to do this through the sqldatasource1.insert statement that I have built using the querybuilder. When I try to put in the @.ID as an output or as a return value It says I need to declare the scalar variable. I have already added in the parameters area and it is set to output with the control being the textbox that I want the Id in. But when I add the line "SET @.NewID = scope_identity()" or "SET @.NewID = @.@.identity" then I get an error on both @.NewId and @.SN which is another scalar variable which normally works fine and works fine again after I pull that line out. But I'm not doing it as a stored procedure. Could that be the problem? I don't know about stored procedures. How do I create them?

|||

Carehalf:

I don't know about stored procedures. How do I create them?

Just check my last post, it is a complete running fine example.

Anyway.. here is a very simple example:

1CREATE PROCEDURE MyStoredProcedureName2@.MyInputParameterint,-- input parameter of type integer3@.MyOutputParameterint OUTPUT-- output parameter of type integer45AS67-- write you statments here8-- and here9-- and here as well :)1011-- how to set a value for ourput parameter12SET @.MyOutputParameter = 100-- just for example1314-- how to increment the input parameter by 1 (for example)15SET @.MyInputParameter = @.MyInputParameter + 1161718/* At the end you the @.MyOutputParameter output parameter value19 will be 100 (as per the logic in this simple example20 Did you see how easy it is to created a stored procedure? */21

Good luck.

|||

I understand the stored procedure from looking at your last statement and this one, but I am not sure where to create it

|||

Carehalf:

I understand the stored procedure from looking at your last statement and this one, but I am not sure where to create it

Create you stored procedures in your application/project database.

Example:

USE MyDatabase
GO

Then the CREATE PROCEDURE statment as in my last two posts.

Good luck.

|||

Carehalf:

Create a table in your database and copy the code sample I posted (change the connection string in the code) and check the syntax to work for you if you don't want to create the Stored Procedure.

Here is the table definition:

CREATETABLE [dbo].[Contacts](

[ContactID] [int]IDENTITY(1,1)NOTNULL,

[ContactName] [nvarchar](50)

)

New Hardware

I have found a couple of web sites that discuss moving a sql server and its
database from one machine to another but nothing in good detail.
I have also looked out on the Knowledgebase and have found nothing as of
yet. I know there has to be some articles on this.
Anybody have a link to one?
Paul Bergson
In your Knowledge Base search you missed:
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default...;en-us;Q314546
Jacco Schalkwijk
SQL Server MVP
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
>I have found a couple of web sites that discuss moving a sql server and its
> database from one machine to another but nothing in good detail.
> I have also looked out on the Knowledgebase and have found nothing as of
> yet. I know there has to be some articles on this.
> Anybody have a link to one?
> --
> Paul Bergson
>
>
|||Actually this isn't what I need this is to move individual db's not the
entire system. It is required that I move all the system db's as well.
Paul Bergson
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> In your Knowledge Base search you missed:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/default...;en-us;Q314546
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
its
>
|||Please clarify...
moving a few user databases OR all the databases (system and user)?
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --
|||1. backup your DBs on first server
2. restore your DBs on second server
3. on second server create user accounts that you wanted to transferred from
first server to second server
4. in each DB run sp_change_users_login 'Update_One' to map each database
user (select * from sysusers) to the new accts you just created in step 3.
You can write a cursor to run dynamically.
hth,
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --
> Paul Bergson
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid >
> wrote
> in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...
> its
>
|||Go to google groups and search this NG for "move system database". IIRC,
Andrew Kelly has posted a rather complete list of links that cover this
frequently asked topic.
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --
> Paul Bergson
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid >
wrote[vbcol=seagreen]
> in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...
> its
of
>
|||New hardware. Retiring the old sql server. I need to move everything...
Paul Bergson
"CD" <mcdye1@.hotmail.REMOVETHIS.com> wrote in message
news:#Nr$t#0SFHA.3636@.TK2MSFTNGP14.phx.gbl...
> Please clarify...
> moving a few user databases OR all the databases (system and user)?
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
>

New Hardware

I have found a couple of web sites that discuss moving a sql server and its
database from one machine to another but nothing in good detail.
I have also looked out on the Knowledgebase and have found nothing as of
yet. I know there has to be some articles on this.
Anybody have a link to one?
Paul BergsonIn your Knowledge Base search you missed:
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/defaul...b;en-us;Q314546
Jacco Schalkwijk
SQL Server MVP
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
>I have found a couple of web sites that discuss moving a sql server and its
> database from one machine to another but nothing in good detail.
> I have also looked out on the Knowledgebase and have found nothing as of
> yet. I know there has to be some articles on this.
> Anybody have a link to one?
> --
> Paul Bergson
>
>|||Actually this isn't what I need this is to move individual db's not the
entire system. It is required that I move all the system db's as well.
Paul Bergson
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...
> In your Knowledge Base search you missed:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/defaul...b;en-us;Q314546
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
its[vbcol=seagreen]
>|||Please clarify...
moving a few user databases OR all the databases (system and user)?
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --|||1. backup your DBs on first server
2. restore your DBs on second server
3. on second server create user accounts that you wanted to transferred from
first server to second server
4. in each DB run sp_change_users_login 'Update_One' to map each database
user (select * from sysusers) to the new accts you just created in step 3.
You can write a cursor to run dynamically.
hth,
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --
> Paul Bergson
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid>
> wrote
> in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...
> its
>|||Go to google groups and search this NG for "move system database". IIRC,
Andrew Kelly has posted a rather complete list of links that cover this
frequently asked topic.
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --
> Paul Bergson
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid>
wrote
> in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...
> its
of[vbcol=seagreen]
>|||New hardware. Retiring the old sql server. I need to move everything...
Paul Bergson
"CD" <mcdye1@.hotmail.REMOVETHIS.com> wrote in message
news:#Nr$t#0SFHA.3636@.TK2MSFTNGP14.phx.gbl...
> Please clarify...
> moving a few user databases OR all the databases (system and user)?
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
>

New Hardware

I have found a couple of web sites that discuss moving a sql server and its
database from one machine to another but nothing in good detail.
I have also looked out on the Knowledgebase and have found nothing as of
yet. I know there has to be some articles on this.
Anybody have a link to one?
--
Paul BergsonIn your Knowledge Base search you missed:
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
Jacco Schalkwijk
SQL Server MVP
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
>I have found a couple of web sites that discuss moving a sql server and its
> database from one machine to another but nothing in good detail.
> I have also looked out on the Knowledgebase and have found nothing as of
> yet. I know there has to be some articles on this.
> Anybody have a link to one?
> --
> Paul Bergson
>
>|||Actually this isn't what I need this is to move individual db's not the
entire system. It is required that I move all the system db's as well.
--
Paul Bergson
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...
> In your Knowledge Base search you missed:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
> >I have found a couple of web sites that discuss moving a sql server and
its
> > database from one machine to another but nothing in good detail.
> >
> > I have also looked out on the Knowledgebase and have found nothing as of
> > yet. I know there has to be some articles on this.
> >
> > Anybody have a link to one?
> >
> > --
> >
> > Paul Bergson
> >
> >
> >
>|||Please clarify...
moving a few user databases OR all the databases (system and user)?
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --|||1. backup your DBs on first server
2. restore your DBs on second server
3. on second server create user accounts that you wanted to transferred from
first server to second server
4. in each DB run sp_change_users_login 'Update_One' to map each database
user (select * from sysusers) to the new accts you just created in step 3.
You can write a cursor to run dynamically.
hth,
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --
> Paul Bergson
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid>
> wrote
> in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...
>> In your Knowledge Base search you missed:
>> HOW TO: Move Databases Between Computers That Are Running SQL Server
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
>>
>> --
>> Jacco Schalkwijk
>> SQL Server MVP
>>
>> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
>> news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
>> >I have found a couple of web sites that discuss moving a sql server and
> its
>> > database from one machine to another but nothing in good detail.
>> >
>> > I have also looked out on the Knowledgebase and have found nothing as
>> > of
>> > yet. I know there has to be some articles on this.
>> >
>> > Anybody have a link to one?
>> >
>> > --
>> >
>> > Paul Bergson
>> >
>> >
>> >
>>
>|||Go to google groups and search this NG for "move system database". IIRC,
Andrew Kelly has posted a rather complete list of links that cover this
frequently asked topic.
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --
> Paul Bergson
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid>
wrote
> in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...
> > In your Knowledge Base search you missed:
> >
> > HOW TO: Move Databases Between Computers That Are Running SQL Server
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
> >
> >
> > --
> > Jacco Schalkwijk
> > SQL Server MVP
> >
> >
> > "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> > news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
> > >I have found a couple of web sites that discuss moving a sql server and
> its
> > > database from one machine to another but nothing in good detail.
> > >
> > > I have also looked out on the Knowledgebase and have found nothing as
of
> > > yet. I know there has to be some articles on this.
> > >
> > > Anybody have a link to one?
> > >
> > > --
> > >
> > > Paul Bergson
> > >
> > >
> > >
> >
> >
>|||New hardware. Retiring the old sql server. I need to move everything...
--
Paul Bergson
"CD" <mcdye1@.hotmail.REMOVETHIS.com> wrote in message
news:#Nr$t#0SFHA.3636@.TK2MSFTNGP14.phx.gbl...
> Please clarify...
> moving a few user databases OR all the databases (system and user)?
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> > Actually this isn't what I need this is to move individual db's not the
> > entire system. It is required that I move all the system db's as well.
> >
> > --
>

New db?

I am going to design a new db that will be accessed thru web pages on my
intranet and the internet. Currently I am using a MS Access db and I have
been told that this is not the best, most efficient "core" for a db. Will
the "Express" edition of MS SQL give me what I am looking for or do I need
to look at the Workgroup Edition? I want to make sure that what ever I use,
it will be robust enough to handle growth.
Hello,
Express edition has a limitation 4 GB database size, So it may not be a good
oprion for you. COnsidering the features available in SQL Server standard
edition
I will recommend you for standard edition over workgroup edition. Take a
look into the below URL:-
http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp
Thanks
Hari
"Jeff Klein" <jklein@.nospam> wrote in message
news:%232IHD9jRHHA.3592@.TK2MSFTNGP06.phx.gbl...
>I am going to design a new db that will be accessed thru web pages on my
>intranet and the internet. Currently I am using a MS Access db and I have
>been told that this is not the best, most efficient "core" for a db. Will
>the "Express" edition of MS SQL give me what I am looking for or do I need
>to look at the Workgroup Edition? I want to make sure that what ever I
>use, it will be robust enough to handle growth.
>
|||Since you're coming from Access/JET, SQL Server Express would be the best
first step. Yes, it has a 4GB database limit but unless you're storing BLOBs
in the database, this would be more than enough for a seriously large
database. Yes, there are features in the Workgroup and Standard that might
prove useful (eventually), but (again), given that you're coming from JET, I
don't expect you'll need them.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Jeff Klein" <jklein@.nospam> wrote in message
news:%232IHD9jRHHA.3592@.TK2MSFTNGP06.phx.gbl...
>I am going to design a new db that will be accessed thru web pages on my
>intranet and the internet. Currently I am using a MS Access db and I have
>been told that this is not the best, most efficient "core" for a db. Will
>the "Express" edition of MS SQL give me what I am looking for or do I need
>to look at the Workgroup Edition? I want to make sure that what ever I
>use, it will be robust enough to handle growth.
>

New DB Web: www.hispabd.com

Hello,
This is the new DB comunity for spanish speakers. www.hispabd.com .

Regards!!!"Nukano" <nukanodj_NOSPAM_@.hotmail.com> wrote in message
news:2j0mktFs6j6pU1@.uni-berlin.de...
> Hello,
> This is the new DB comunity for spanish speakers. www.hispabd.com .
> Regards!!!

so kool. you gibbon a way ennee free tacos?