Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts

Friday, March 30, 2012

How to attach a database using SQL Server 2005

Hello
In the full version of SQL Server I can use enterprise manager to attach a
database. I have an SQL Server 2005 database from another machine which I
want to attach to a new computer with SQL Server 2005 Express. Is there a
tool I can use or do I need to run a command?
Angushave you try the sp_attach stored procedure?
"Angus" <nospam@.gmail.com> wrote in message
news:#iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
> Hello
> In the full version of SQL Server I can use enterprise manager to attach a
> database. I have an SQL Server 2005 database from another machine which I
> want to attach to a new computer with SQL Server 2005 Express. Is there a
> tool I can use or do I need to run a command?
> Angus
>|||Yes I have found the sp_attach syntax - but how do I run these commands?
Can I run them from the command line? But if I navigate to prog
files\microsoft SQL Server\MSSQL.1\MSSQL\Binn\ - I cannot run eg sp_attach?
Is this not the right path?
Or have I maybe not installed something?
There is a Start menu item, Microsoft SQL Server 2005... Configuration
Tools... SQL Server Configuration Manager - but can't see where I could type
commands in there?
Angus
"Jeje" <willgart@.hotmail.com> wrote in message
news:uGaU5N8kHHA.2272@.TK2MSFTNGP02.phx.gbl...
> have you try the sp_attach stored procedure?
> "Angus" <nospam@.gmail.com> wrote in message
> news:#iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
> > Hello
> >
> > In the full version of SQL Server I can use enterprise manager to attach
a
> > database. I have an SQL Server 2005 database from another machine which
I
> > want to attach to a new computer with SQL Server 2005 Express. Is there
a
> > tool I can use or do I need to run a command?
> >
> > Angus
> >
> >|||"Angus" <nospam@.gmail.com> wrote in
news:ecHo7S8kHHA.4188@.TK2MSFTNGP02.phx.gbl:
> Yes I have found the sp_attach syntax - but how do I run these
> commands? Can I run them from the command line? But if I navigate to
> prog files\microsoft SQL Server\MSSQL.1\MSSQL\Binn\ - I cannot run eg
> sp_attach? Is this not the right path?
> Or have I maybe not installed something?
> There is a Start menu item, Microsoft SQL Server 2005... Configuration
> Tools... SQL Server Configuration Manager - but can't see where I
> could type commands in there?
You can use the OSQL command-line utility to run stored procedures. See
BOL for how to use it.
> Angus
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:uGaU5N8kHHA.2272@.TK2MSFTNGP02.phx.gbl...
>> have you try the sp_attach stored procedure?
>> "Angus" <nospam@.gmail.com> wrote in message
>> news:#iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
>> > Hello
>> >
>> > In the full version of SQL Server I can use enterprise manager to
>> > attach
> a
>> > database. I have an SQL Server 2005 database from another machine
>> > which
> I
>> > want to attach to a new computer with SQL Server 2005 Express. Is
>> > there
> a
>> > tool I can use or do I need to run a command?
>> >
>> > Angus
>> >
>> >
>|||On Fri, 11 May 2007 12:52:21 +0100, "Angus" <nospam@.gmail.com> wrote:
>Hello
>In the full version of SQL Server I can use enterprise manager to attach a
>database. I have an SQL Server 2005 database from another machine which I
>want to attach to a new computer with SQL Server 2005 Express. Is there a
>tool I can use or do I need to run a command?
>Angus
SQL Server Management Studio Express has an attach command.
Click on Databases, right context mouse click, attach..
Another way to move a database from one machine to another is to make
a backup and then restore the backup to the new machine.|||Hi
CREATE DATABASE ...command has FOR ATTACH option ,please take a look at
BOL.
"Angus" <nospam@.gmail.com> wrote in message
news:%23iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
> Hello
> In the full version of SQL Server I can use enterprise manager to attach a
> database. I have an SQL Server 2005 database from another machine which I
> want to attach to a new computer with SQL Server 2005 Express. Is there a
> tool I can use or do I need to run a command?
> Angus
>

How to attach a database using SQL Server 2005

Hello
In the full version of SQL Server I can use enterprise manager to attach a
database. I have an SQL Server 2005 database from another machine which I
want to attach to a new computer with SQL Server 2005 Express. Is there a
tool I can use or do I need to run a command?
Angushave you try the sp_attach stored procedure?
"Angus" <nospam@.gmail.com> wrote in message
news:#iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
> Hello
> In the full version of SQL Server I can use enterprise manager to attach a
> database. I have an SQL Server 2005 database from another machine which I
> want to attach to a new computer with SQL Server 2005 Express. Is there a
> tool I can use or do I need to run a command?
> Angus
>|||Yes I have found the sp_attach syntax - but how do I run these commands?
Can I run them from the command line? But if I navigate to prog
files\microsoft SQL Server\MSSQL.1\MSSQL\Binn\ - I cannot run eg sp_attach?
Is this not the right path?
Or have I maybe not installed something?
There is a Start menu item, Microsoft SQL Server 2005... Configuration
Tools... SQL Server Configuration Manager - but can't see where I could type
commands in there?
Angus
"Jeje" <willgart@.hotmail.com> wrote in message
news:uGaU5N8kHHA.2272@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> have you try the sp_attach stored procedure?
> "Angus" <nospam@.gmail.com> wrote in message
> news:#iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
a[vbcol=seagreen]
I[vbcol=seagreen]
a[vbcol=seagreen]|||"Angus" <nospam@.gmail.com> wrote in
news:ecHo7S8kHHA.4188@.TK2MSFTNGP02.phx.gbl:

> Yes I have found the sp_attach syntax - but how do I run these
> commands? Can I run them from the command line? But if I navigate to
> prog files\microsoft SQL Server\MSSQL.1\MSSQL\Binn\ - I cannot run eg
> sp_attach? Is this not the right path?
> Or have I maybe not installed something?
> There is a Start menu item, Microsoft SQL Server 2005... Configuration
> Tools... SQL Server Configuration Manager - but can't see where I
> could type commands in there?
You can use the OSQL command-line utility to run stored procedures. See
BOL for how to use it.

> Angus
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:uGaU5N8kHHA.2272@.TK2MSFTNGP02.phx.gbl...
> a
> I
> a
>|||On Fri, 11 May 2007 12:52:21 +0100, "Angus" <nospam@.gmail.com> wrote:

>Hello
>In the full version of SQL Server I can use enterprise manager to attach a
>database. I have an SQL Server 2005 database from another machine which I
>want to attach to a new computer with SQL Server 2005 Express. Is there a
>tool I can use or do I need to run a command?
>Angus
SQL Server Management Studio Express has an attach command.
Click on Databases, right context mouse click, attach..
Another way to move a database from one machine to another is to make
a backup and then restore the backup to the new machine.|||Hi
CREATE DATABASE ...command has FOR ATTACH option ,please take a look at
BOL.
"Angus" <nospam@.gmail.com> wrote in message
news:%23iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
> Hello
> In the full version of SQL Server I can use enterprise manager to attach a
> database. I have an SQL Server 2005 database from another machine which I
> want to attach to a new computer with SQL Server 2005 Express. Is there a
> tool I can use or do I need to run a command?
> Angus
>sql

Wednesday, March 21, 2012

How to add/edit job in MSDE?

Hello
I would like to add/edit job in MSDE, is there any way to do this or any other third party tool like Enerprise Manager ?
Regards
Ashish Kanoongo
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.733 / Virus Database: 487 - Release Date: 08/02/2004
Learn the syntax of sp_add_job, sp_add_jobstep, sp_add_jobschedule, etc.
You can run these in the MSDB database from osql.
You're going to have a tough time getting by the license requirements of
using Enterprise Manager, but there are other graphical tools which may
handle SQL Server Agent, eliminating the need to learn all the syntax and
parameters of the msdb procs. See http://www.aspfaq.com/2442
http://www.aspfaq.com/
(Reverse address to reply.)
"Ashish Kanoongo" <ashishk@.armour.com> wrote in message
news:eAai$9heEHA.384@.TK2MSFTNGP10.phx.gbl...
Hello
I would like to add/edit job in MSDE, is there any way to do this or any
other third party tool like Enerprise Manager ?
Regards
Ashish Kanoongo
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.733 / Virus Database: 487 - Release Date: 08/02/2004
sql

Monday, March 19, 2012

How to add services to SQL Server Service Manager

I have 2 SQL Servers.
On the 1st server, when I go to the Service Manager, I can se all the 4
services:
1. Distributed Transaction Coordinator
2. Microsoft Search
3. SQL Server
4. SQL Server Agent
On the 2nd server, when I go to the Service Manager, I only see the last two
services! How can I add the DTC and the MS Search to the Service manager?
Thank you
BlackpitHi
Have you checked that these are installed?
John
"blackpit" wrote:

> I have 2 SQL Servers.
> On the 1st server, when I go to the Service Manager, I can se all the 4
> services:
> 1. Distributed Transaction Coordinator
> 2. Microsoft Search
> 3. SQL Server
> 4. SQL Server Agent
> On the 2nd server, when I go to the Service Manager, I only see the last t
wo
> services! How can I add the DTC and the MS Search to the Service manager?
> Thank you
> Blackpit|||Hello John!
I did checked this out and, yes, they are installed.
Actually I have a suspicion that the fault is on the Security Policy applied
to the server that misses these 2 services on the Service Manager. The 2
servers are in diffferent Active Directory OUs, so different security
policies are applied in each case.
The problem is that I don't know what the exact security issue is the one
that creates the problem (e.g. NTFS permissions? Where and for Who?). If I
did, I could let the System Administrator know and he would be able to help
me grant/revoke the necessary privileges.
Do you have any idea, who needs What privileges on Where so that the 2
missing services can appear in the Service Manager?
Thank you for your time.
Vagelis
Ο χρ?στη? "John Bell" _γγραψε:
[vbcol=seagreen]
> Hi
> Have you checked that these are installed?
> John
> "blackpit" wrote:
>|||Hi
I am not sure where the permissions could be causing a problem, but I would
guess it would be permissions on a specific registry entry that causes this
.
Can you stop/start these services from the services applet on the
administrators menu?
John
"blackpit" wrote:
[vbcol=seagreen]
> Hello John!
> I did checked this out and, yes, they are installed.
> Actually I have a suspicion that the fault is on the Security Policy appli
ed
> to the server that misses these 2 services on the Service Manager. The 2
> servers are in diffferent Active Directory OUs, so different security
> policies are applied in each case.
> The problem is that I don't know what the exact security issue is the one
> that creates the problem (e.g. NTFS permissions? Where and for Who?). If I
> did, I could let the System Administrator know and he would be able to he
lp
> me grant/revoke the necessary privileges.
> Do you have any idea, who needs What privileges on Where so that the 2
> missing services can appear in the Service Manager?
> Thank you for your time.
> Vagelis
> Ο χρ?στη? "John Bell" _γγραψε:
>|||When I tried to start the Microsoft Search Service (via services applet)
using the same account that the MSSQLSERVER service starts, it didn't
startup. I guess I must find out where to give permissions for this account.
At least we found out that it is a security issue.
I will update the post when I find out the exact grants.
Thanks for your help.
Ο χρ?στη? "John Bell" _γγραψε:
[vbcol=seagreen]
> Hi
> I am not sure where the permissions could be causing a problem, but I woul
d
> guess it would be permissions on a specific registry entry that causes th
is.
> Can you stop/start these services from the services applet on the
> administrators menu?
> John
> "blackpit" wrote:
>

How to add services to SQL Server Service Manager

I have 2 SQL Servers.
On the 1st server, when I go to the Service Manager, I can se all the 4
services:
1. Distributed Transaction Coordinator
2. Microsoft Search
3. SQL Server
4. SQL Server Agent
On the 2nd server, when I go to the Service Manager, I only see the last two
services! How can I add the DTC and the MS Search to the Service manager?
Thank you
BlackpitHi
Have you checked that these are installed?
John
"blackpit" wrote:
> I have 2 SQL Servers.
> On the 1st server, when I go to the Service Manager, I can se all the 4
> services:
> 1. Distributed Transaction Coordinator
> 2. Microsoft Search
> 3. SQL Server
> 4. SQL Server Agent
> On the 2nd server, when I go to the Service Manager, I only see the last two
> services! How can I add the DTC and the MS Search to the Service manager?
> Thank you
> Blackpit|||Hello John!
I did checked this out and, yes, they are installed.
Actually I have a suspicion that the fault is on the Security Policy applied
to the server that misses these 2 services on the Service Manager. The 2
servers are in diffferent Active Directory OUs, so different security
policies are applied in each case.
The problem is that I don't know what the exact security issue is the one
that creates the problem (e.g. NTFS permissions? Where and for Who?). If I
did, I could let the System Administrator know and he would be able to help
me grant/revoke the necessary privileges.
Do you have any idea, who needs What privileges on Where so that the 2
missing services can appear in the Service Manager?
Thank you for your time.
Vagelis
Î? Ï?Ï?ήÏ?Ï?ηÏ? "John Bell" έγγÏ?αÏ?ε:
> Hi
> Have you checked that these are installed?
> John
> "blackpit" wrote:
> > I have 2 SQL Servers.
> >
> > On the 1st server, when I go to the Service Manager, I can se all the 4
> > services:
> > 1. Distributed Transaction Coordinator
> > 2. Microsoft Search
> > 3. SQL Server
> > 4. SQL Server Agent
> >
> > On the 2nd server, when I go to the Service Manager, I only see the last two
> > services! How can I add the DTC and the MS Search to the Service manager?
> >
> > Thank you
> > Blackpit|||Hi
I am not sure where the permissions could be causing a problem, but I would
guess it would be permissions on a specific registry entry that causes this.
Can you stop/start these services from the services applet on the
administrators menu?
John
"blackpit" wrote:
> Hello John!
> I did checked this out and, yes, they are installed.
> Actually I have a suspicion that the fault is on the Security Policy applied
> to the server that misses these 2 services on the Service Manager. The 2
> servers are in diffferent Active Directory OUs, so different security
> policies are applied in each case.
> The problem is that I don't know what the exact security issue is the one
> that creates the problem (e.g. NTFS permissions? Where and for Who?). If I
> did, I could let the System Administrator know and he would be able to help
> me grant/revoke the necessary privileges.
> Do you have any idea, who needs What privileges on Where so that the 2
> missing services can appear in the Service Manager?
> Thank you for your time.
> Vagelis
> Î? Ï?Ï?ήÏ?Ï?ηÏ? "John Bell" έγγÏ?αÏ?ε:
> > Hi
> >
> > Have you checked that these are installed?
> >
> > John
> >
> > "blackpit" wrote:
> >
> > > I have 2 SQL Servers.
> > >
> > > On the 1st server, when I go to the Service Manager, I can se all the 4
> > > services:
> > > 1. Distributed Transaction Coordinator
> > > 2. Microsoft Search
> > > 3. SQL Server
> > > 4. SQL Server Agent
> > >
> > > On the 2nd server, when I go to the Service Manager, I only see the last two
> > > services! How can I add the DTC and the MS Search to the Service manager?
> > >
> > > Thank you
> > > Blackpit|||When I tried to start the Microsoft Search Service (via services applet)
using the same account that the MSSQLSERVER service starts, it didn't
startup. I guess I must find out where to give permissions for this account.
At least we found out that it is a security issue.
I will update the post when I find out the exact grants.
Thanks for your help.
Î? Ï?Ï?ήÏ?Ï?ηÏ? "John Bell" έγγÏ?αÏ?ε:
> Hi
> I am not sure where the permissions could be causing a problem, but I would
> guess it would be permissions on a specific registry entry that causes this.
> Can you stop/start these services from the services applet on the
> administrators menu?
> John
> "blackpit" wrote:
> > Hello John!
> >
> > I did checked this out and, yes, they are installed.
> >
> > Actually I have a suspicion that the fault is on the Security Policy applied
> > to the server that misses these 2 services on the Service Manager. The 2
> > servers are in diffferent Active Directory OUs, so different security
> > policies are applied in each case.
> >
> > The problem is that I don't know what the exact security issue is the one
> > that creates the problem (e.g. NTFS permissions? Where and for Who?). If I
> > did, I could let the System Administrator know and he would be able to help
> > me grant/revoke the necessary privileges.
> >
> > Do you have any idea, who needs What privileges on Where so that the 2
> > missing services can appear in the Service Manager?
> >
> > Thank you for your time.
> > Vagelis
> >
> > Î? Ï?Ï?ήÏ?Ï?ηÏ? "John Bell" έγγÏ?αÏ?ε:
> >
> > > Hi
> > >
> > > Have you checked that these are installed?
> > >
> > > John
> > >
> > > "blackpit" wrote:
> > >
> > > > I have 2 SQL Servers.
> > > >
> > > > On the 1st server, when I go to the Service Manager, I can se all the 4
> > > > services:
> > > > 1. Distributed Transaction Coordinator
> > > > 2. Microsoft Search
> > > > 3. SQL Server
> > > > 4. SQL Server Agent
> > > >
> > > > On the 2nd server, when I go to the Service Manager, I only see the last two
> > > > services! How can I add the DTC and the MS Search to the Service manager?
> > > >
> > > > Thank you
> > > > Blackpit

Monday, March 12, 2012

How to add printer icon and print the report itself

Hi there,
Is there any way to add printer icon besides refresh and help icons in
Report manager?
If not exporting to any other type file, how can we print the report
itself in Report Manager when the report has more than one page? Right
now it looks like screen print when the report is bigger than one
page.
Thanks.
HenryUntil SP2 your only choice is to export to pdf and print. There are other
options is you have your own application and integrate with RS using URL
integration or web services but if you are using the portal that ships with
RS (report manager) there is nothing you can do. With SP2 they will be
shipping support for client printing (Yeah!!)
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Henry" <fanh@.tycoelectronics.com> wrote in message
news:d2a411ae.0411011251.2e423030@.posting.google.com...
> Hi there,
> Is there any way to add printer icon besides refresh and help icons in
> Report manager?
> If not exporting to any other type file, how can we print the report
> itself in Report Manager when the report has more than one page? Right
> now it looks like screen print when the report is bigger than one
> page.
> Thanks.
> Henry|||The answer everyone wants is when is SP2 being released?
"Bruce L-C [MVP]" wrote:
> Until SP2 your only choice is to export to pdf and print. There are other
> options is you have your own application and integrate with RS using URL
> integration or web services but if you are using the portal that ships with
> RS (report manager) there is nothing you can do. With SP2 they will be
> shipping support for client printing (Yeah!!)
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Henry" <fanh@.tycoelectronics.com> wrote in message
> news:d2a411ae.0411011251.2e423030@.posting.google.com...
> > Hi there,
> >
> > Is there any way to add printer icon besides refresh and help icons in
> > Report manager?
> > If not exporting to any other type file, how can we print the report
> > itself in Report Manager when the report has more than one page? Right
> > now it looks like screen print when the report is bigger than one
> > page.
> > Thanks.
> >
> > Henry
>
>|||What other options are available if i have my own app integrated wirh RS
using URL access?
Rodrigo Sanchez
Netshore Programming Corp.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
news:uPkGTZFwEHA.3296@.TK2MSFTNGP10.phx.gbl...
> Until SP2 your only choice is to export to pdf and print. There are other
> options is you have your own application and integrate with RS using URL
> integration or web services but if you are using the portal that ships
with
> RS (report manager) there is nothing you can do. With SP2 they will be
> shipping support for client printing (Yeah!!)
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Henry" <fanh@.tycoelectronics.com> wrote in message
> news:d2a411ae.0411011251.2e423030@.posting.google.com...
> > Hi there,
> >
> > Is there any way to add printer icon besides refresh and help icons in
> > Report manager?
> > If not exporting to any other type file, how can we print the report
> > itself in Report Manager when the report has more than one page? Right
> > now it looks like screen print when the report is bigger than one
> > page.
> > Thanks.
> >
> > Henry
>|||Search the newsgroup, there are definitely people doing this and there has
been code shared. I have not done this so I can not help you directly.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
news:uLbLVPIwEHA.3916@.TK2MSFTNGP10.phx.gbl...
> What other options are available if i have my own app integrated wirh RS
> using URL access?
> Rodrigo Sanchez
> Netshore Programming Corp.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
> news:uPkGTZFwEHA.3296@.TK2MSFTNGP10.phx.gbl...
> > Until SP2 your only choice is to export to pdf and print. There are
other
> > options is you have your own application and integrate with RS using URL
> > integration or web services but if you are using the portal that ships
> with
> > RS (report manager) there is nothing you can do. With SP2 they will be
> > shipping support for client printing (Yeah!!)
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Henry" <fanh@.tycoelectronics.com> wrote in message
> > news:d2a411ae.0411011251.2e423030@.posting.google.com...
> > > Hi there,
> > >
> > > Is there any way to add printer icon besides refresh and help icons in
> > > Report manager?
> > > If not exporting to any other type file, how can we print the report
> > > itself in Report Manager when the report has more than one page? Right
> > > now it looks like screen print when the report is bigger than one
> > > page.
> > > Thanks.
> > >
> > > Henry
> >
> >
>|||You and me both.
I wish I knew but I don't know either.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:ED1D2E1B-F3E3-4C1D-84BE-B7DABBABDF0E@.microsoft.com...
> The answer everyone wants is when is SP2 being released?
> "Bruce L-C [MVP]" wrote:
> > Until SP2 your only choice is to export to pdf and print. There are
other
> > options is you have your own application and integrate with RS using URL
> > integration or web services but if you are using the portal that ships
with
> > RS (report manager) there is nothing you can do. With SP2 they will be
> > shipping support for client printing (Yeah!!)
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Henry" <fanh@.tycoelectronics.com> wrote in message
> > news:d2a411ae.0411011251.2e423030@.posting.google.com...
> > > Hi there,
> > >
> > > Is there any way to add printer icon besides refresh and help icons in
> > > Report manager?
> > > If not exporting to any other type file, how can we print the report
> > > itself in Report Manager when the report has more than one page? Right
> > > now it looks like screen print when the report is bigger than one
> > > page.
> > > Thanks.
> > >
> > > Henry
> >
> >
> >

How to add or modify "login name" of existing users

How is it possible to add or modify "login name"
through "Enterprise Manager" on an existing users of a
database.
The "login name" has been created but I need to effect the
changes on the users. An example is either to either add
or change the "login name" of the user "dbo".
Advise would be appreciated.There is no way that I know of to edit the login name of a login through EM.
From your post, are you trying to change the dbo of the database? If so,
look at sp_changedbowner
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"topokin" <bimosekin@.hotmail.com> wrote in message
news:021901c3c540$546acc90$a001280a@.phx.gbl...
quote:

> How is it possible to add or modify "login name"
> through "Enterprise Manager" on an existing users of a
> database.
> The "login name" has been created but I need to effect the
> changes on the users. An example is either to either add
> or change the "login name" of the user "dbo".
> Advise would be appreciated.
|||You can change the login name of the dbo with the sp_changedbowner
procedure, but you cannot change the login name that current exists for the
dbo.
Rand
This posting is provided "as is" with no warranties and confers no rights.

How to add or change "login name" on users

How is it possible to add or modify "login name"
through "Enterprise Manager" on an existing users of a
database.
The "login name" has been created but I need to effect the
changes on the users. An example is either to either add
or change the "login name" of the user "dbo".
Advise would be appreciated.sp_change_users_login
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"topokin" <bimosekin@.hotmail.com> wrote in message news:04b601c3c540$3a4d2920$a101280a@.phx.gbl...
> How is it possible to add or modify "login name"
> through "Enterprise Manager" on an existing users of a
> database.
> The "login name" has been created but I need to effect the
> changes on the users. An example is either to either add
> or change the "login name" of the user "dbo".
> Advise would be appreciated.

How to add new article to publication?

Hi,
I'm use MSSQL2000 SP3 with replication.
I want to know that Can i add new article to existing publication by
Enterprice Manager ?
someone told me that we can do that in older version but not now,right? :confused:In UI you have to rebuild your replication/subscription from scratch. You can however use sp_addarticle/sp_addmergearticle (depending on your replication type).

how to add login user (ASPNET) to MS SQL 2000 Desktop Engine server (MSDE2000)?

How do I add login user ASPNET to my SQL 2000 Desktop Engine Server?. I can not find the "Server Manager" in the Start - Programs. Is there any other way to get around adding ASPNET login to the SQL server so I can test my VB program. I got the error: Login failed for user 'com_name\ASPNET'.Use OSQL, a command line tool. Find it, and from the command prompt:

osql -S servername\instancename -E -q
--Line numbers will appear
EXEC sp_grantlogin 'com_name\ASPNET'
go
use <databasename>
go
EXEC sp_grantdbaccess 'com_name\ASPNET'
go
EXEC sp_addrolemember 'db_owner', 'com_name\ASPNET'
go

Friday, March 9, 2012

How to add files to Tempdb using Enterprise Manager?

This may seem easy but better to ask than mess up. Of course have now
seen the articles about adding files to the tempdb but none really indicate
the proper method for doing this they just say do it. Do I just right click
on Tempdb, properties, select data files and then just add the files and make
sure they are all the same size? I do not need to add more Log files just
the data files, correct? Once this is done does it require a restart of SQL?
This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
a TON of activity on it.
Thank you!Inline.
"Transam388" wrote:
> This may seem easy but better to ask than mess up. Of course have now
> seen the articles about adding files to the tempdb but none really indicate
> the proper method for doing this they just say do it. Do I just right click
> on Tempdb, properties, select data files and then just add the files and make
> sure they are all the same size?
You can do this. I'd prefer to just run a series of T-SQL statements:
ALTER DATABASE tempdb ADD FILE (...)
> I do not need to add more Log files just the data files, correct?
Correct (unless you need more tempdb log space and the current log file
can't be grow any larger).
> Once this is done does it require a restart of SQL?
No.
> This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
> a TON of activity on it.
> Thank you!

How to add files to Tempdb using Enterprise Manager?

This may seem easy but better to ask than mess up. Of course have now
seen the articles about adding files to the tempdb but none really indicate
the proper method for doing this they just say do it. Do I just right click
on Tempdb, properties, select data files and then just add the files and make
sure they are all the same size? I do not need to add more Log files just
the data files, correct? Once this is done does it require a restart of SQL?
This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
a TON of activity on it.
Thank you!
Inline.
"Transam388" wrote:

> This may seem easy but better to ask than mess up. Of course have now
> seen the articles about adding files to the tempdb but none really indicate
> the proper method for doing this they just say do it. Do I just right click
> on Tempdb, properties, select data files and then just add the files and make
> sure they are all the same size?
You can do this. I'd prefer to just run a series of T-SQL statements:
ALTER DATABASE tempdb ADD FILE (...)

> I do not need to add more Log files just the data files, correct?
Correct (unless you need more tempdb log space and the current log file
can't be grow any larger).

> Once this is done does it require a restart of SQL?
No.

> This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
> a TON of activity on it.
> Thank you!

How to add date and time to Flat File Connection Manager

I have specified a name for my output file in the properties of my Flat File Connection but how can I add the date and time to that filename? If it is using expressions, what would be the expression and where exactly do I paste that expression?

Nice one:

Expression:

"FileNameBase_" + (DT_WSTR,15)(DT_DBDATE)GETDATE() + "_" + (DT_WSTR, 15)(DT_DBTIME)GETDATE()

Looks like this:

FileNameBase_2006-01-03_08:55:28

Place is on the Connection String property of the Flat File Connection Manager.

HTH,

K

|||

I have the following expression attached to the ConnectionString property of a File Connection Manager:

@.[System::PackageName] + (DT_STR, 4, 1252) DATEPART( "yyyy", @.[System::StartTime] ) + RIGHT("0" + (DT_STR, 2, 1252) DATEPART( "mm", @.[System::StartTime] ), 2) + RIGHT("0" + (DT_STR, 4, 1252) DATEPART( "dd", @.[System::StartTime] ), 2) + RIGHT("0" + (DT_STR, 4, 1252) DATEPART( "hh", @.[System::StartTime] ), 2) + RIGHT("0" + (DT_STR, 4, 1252) DATEPART( "mi", @.[System::StartTime] ), 2) + RIGHT("0" + (DT_STR, 4, 1252) DATEPART( "ss", @.[System::StartTime] ), 2) + ".log"

Which looks horrible, I know, but evaluates to something alot more user-friendly:

PackageName20060103084130.log

You can choose to make this as difficult or simple as you like. For example

@.[System::PackageName] + (DT_STR, 30, 1252) @.[System::StartTime]

evaluates to:

PackageName03/01/2006 08:41:30

Hope that helps!!

-Jamie

|||Thanks a lot! this gives me a real good start to working more with expressions in SSIS|||

one more question. I tried putting it at the end of my string but it doesn't like it because it is malformed:

C:\Documents and Settings\sss\Desktop\output.txt + (DT_WSTR,15)(DT_DBDATE)GETDATE() + "_" + (DT_WSTR, 15)(DT_DBTIME)GETDATE()

|||

Gotta escape the '\' character and gotta be in quotes... :)

"C:\\Documents and Settings\\sss\\Desktop\\output.txt" + (DT_WSTR,15)(DT_DBDATE)GETDATE() + "_" + (DT_WSTR, 15)(DT_DBTIME)GETDATE()

Friday, February 24, 2012

How to add a foreign key constraint using the SQL server 2000 enterprise manager

Hi,

How to add a foreign key constraint using the SQL server 2000
enterprise manager?
Not by SQL.

thanks"Mark" <mchung_pc@.hotmail.com> wrote in message
news:1117734724.479577.321970@.o13g2000cwo.googlegr oups.com...
> Hi,
> How to add a foreign key constraint using the SQL server 2000
> enterprise manager?
> Not by SQL.
> thanks

I think you have to create a database diagram, then manage relationships in
that somehow, but I don't really know - EM is not a very good tool for
database design or programming. I would do it in Query Analyzer, because
then you have complete control over what you're doing and you also have a
script you can save, put under version control, run against multiple
databases etc.

Simon|||Many thanks.

regards|||Actually, this is NOT a very complicated procedure.
Assume table1.custID = table2.custID.

In EM, open table1 in design mode. Click the menu bar icon for "Manage
Relationships". Click the "Relationships" tab. Click the "New" button.

Now you can select keys/fields from the tables. I'm sure you can figure
it out from there.

ldh

Simon Hayes wrote:
> "Mark" <mchung_pc@.hotmail.com> wrote in message
> news:1117734724.479577.321970@.o13g2000cwo.googlegr oups.com...
>>Hi,
>>
>>How to add a foreign key constraint using the SQL server 2000
>>enterprise manager?
>>Not by SQL.
>>
>>thanks
>>
>
> I think you have to create a database diagram, then manage relationships in
> that somehow, but I don't really know - EM is not a very good tool for
> database design or programming. I would do it in Query Analyzer, because
> then you have complete control over what you're doing and you also have a
> script you can save, put under version control, run against multiple
> databases etc.
> Simon
>

Sunday, February 19, 2012

how to access sql server on windows small businness server 2003

Hello,

I have windows small business server 2003 premium installed, I can see the server service manager but can not start any service(nothing is listed).
How do I set it up?

I can not find the enterprise manager to create a database.

Thanks for your help

The Small Business Server 2003 comes with SQL Server 2000 for 75 users, ISA(internet security server) and Exchange 2003 also for 75 users, how to install the first two is covered below by Microsoft. Hope this helps.

http://download.microsoft.com/download/8/2/4/824e18ac-8503-4277-aeb6-b3f24c316f6c/PremiumInstallSteps.htm