Changing the owner of a table

Hi,
I have a table in SQL Server 2000, say its called: "tblName". When
I right mouse click on it and select "Properties" from the menu I see
that beside the "Owner" label is companyName\Administrator.
I want to change this to sa as I'm having problems creating an
index (I think its got to do with this). So my question is: how do you
change the owner of a table please?
Any comments/suggestions/advice greatly appreciated.
Thank you,
Al.
<almurph@.altavista.com> wrote in message
news:1e70ec60-b12a-49dc-b8d4-f070f15d739b@.j20g2000hsi.googlegroups.com...
> Hi,
> I have a table in SQL Server 2000, say its called: "tblName". When
> I right mouse click on it and select "Properties" from the menu I see
> that beside the "Owner" label is companyName\Administrator.
> I want to change this to sa as I'm having problems creating an
> index (I think its got to do with this). So my question is: how do you
> change the owner of a table please?
> Any comments/suggestions/advice greatly appreciated.
> Thank you,
> Al.
Take a look at the sp_changeobjectowner stored procedure. There are some
caveats to this process however. You may impact other views and stored
procedures that depend on that table having the
companyName\Administrator.Table1 name.
You cannot change the ownership to sa. You can change it to dbo.
As for your index, if you are the sa in the database, you could create your
index by specifying the qualified name of the table.
Example:
CREATE NONCLUSTERED INDEX IX_SomeIndex ON companyName\Administrator.Table1
(column list)
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Changing the owner of a table

Hi,
I have a table in SQL Server 2000, say its called: "tblName". When
I right mouse click on it and select "Properties" from the menu I see
that beside the "Owner" label is companyName\Administrator.
I want to change this to sa as I'm having problems creating an
index (I think its got to do with this). So my question is: how do you
change the owner of a table please?
Any comments/suggestions/advice greatly appreciated.
Thank you,
Al.<almurph@.altavista.com> wrote in message
news:1e70ec60-b12a-49dc-b8d4-f070f15d739b@.j20g2000hsi.googlegroups.com...
> Hi,
> I have a table in SQL Server 2000, say its called: "tblName". When
> I right mouse click on it and select "Properties" from the menu I see
> that beside the "Owner" label is companyName\Administrator.
> I want to change this to sa as I'm having problems creating an
> index (I think its got to do with this). So my question is: how do you
> change the owner of a table please?
> Any comments/suggestions/advice greatly appreciated.
> Thank you,
> Al.
Take a look at the sp_changeobjectowner stored procedure. There are some
caveats to this process however. You may impact other views and stored
procedures that depend on that table having the
companyName\Administrator.Table1 name.
You cannot change the ownership to sa. You can change it to dbo.
As for your index, if you are the sa in the database, you could create your
index by specifying the qualified name of the table.
Example:
CREATE NONCLUSTERED INDEX IX_SomeIndex ON companyName\Administrator.Table1
(column list)
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Changing the owner of a table

Hi,
I have a table in SQL Server 2000, say its called: "tblName". When
I right mouse click on it and select "Properties" from the menu I see
that beside the "Owner" label is companyName\Administrator.
I want to change this to sa as I'm having problems creating an
index (I think its got to do with this). So my question is: how do you
change the owner of a table please?
Any comments/suggestions/advice greatly appreciated.
Thank you,
Al.<almurph@.altavista.com> wrote in message
news:1e70ec60-b12a-49dc-b8d4-f070f15d739b@.j20g2000hsi.googlegroups.com...
> Hi,
> I have a table in SQL Server 2000, say its called: "tblName". When
> I right mouse click on it and select "Properties" from the menu I see
> that beside the "Owner" label is companyName\Administrator.
> I want to change this to sa as I'm having problems creating an
> index (I think its got to do with this). So my question is: how do you
> change the owner of a table please?
> Any comments/suggestions/advice greatly appreciated.
> Thank you,
> Al.
Take a look at the sp_changeobjectowner stored procedure. There are some
caveats to this process however. You may impact other views and stored
procedures that depend on that table having the
companyName\Administrator.Table1 name.
You cannot change the ownership to sa. You can change it to dbo.
As for your index, if you are the sa in the database, you could create your
index by specifying the qualified name of the table.
Example:
CREATE NONCLUSTERED INDEX IX_SomeIndex ON companyName\Administrator.Table1
(column list)
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Changing the file name stored in database properties

I need to change the file name of a database.
The name I need to change is shown when you right click on a database and
select properties then select the Data File tab.
I need to change the filename associated with the database.
Is this possible and how
Regards
Jeff
--
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003Jeff,
The filename you mentioned is the "logical filename".Why I clarified is
because, normally the xxxx.mdf is referred as filename of data file.As Kalen
mentioned, you can change the logical filename only in SQL2000 and the
command is:
ALTER DATABASE <databasename>
MODIFY FILE (NAME= '<oldlogicalfilename>', NEWNAME = '<newlogicalfilename>')
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Jeff Williams" <jeff.williams@.hardsoft.com.au> wrote in message
news:eUENlIfXDHA.2484@.TK2MSFTNGP09.phx.gbl...
> I need to change the file name of a database.
> The name I need to change is shown when you right click on a database and
> select properties then select the Data File tab.
> I need to change the filename associated with the database.
> Is this possible and how
> Regards
> Jeff
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003
>

Changing table properties

I have 7 tables that I want to remove the checkbox for "Enforce relationship
for replication". These tables are all articles in a publication and I want
them to get down to the merge synchronization laptop subscribers. On a test
system, I unchecked them in EM and the changes took without any errors
(actually I expected to be told I cannot do that on published articles). I
assume that I can just re-create the snapshot and have the laptops
"reinitialize" at their next synch. Am I correct or missing anything.
Thanks.
David
David,
this is fine, although you might be able to just apply a script on the
subscriber to drop the FKs directly (or through sp_addscriptexec) without
doing the reinitialization.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||I tried this in a test environment but when I looked at the database on the
laptop it still had the box checked. Did I miss something?
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:etWoZ9JQHHA.1380@.TK2MSFTNGP05.phx.gbl...
> David,
> this is fine, although you might be able to just apply a script on the
> subscriber to drop the FKs directly (or through sp_addscriptexec) without
> doing the reinitialization.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
|||David - can you post up the script you were using and I'll take a look.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Paul,
I was trying to do it in Enterprise Manager instead of script. I then went
into the Snapshot Agent and restarted the snapshot agent, which I thought
would pick up the new settings. I then re-initialized the subscription at
the laptop but it didn't pick up the removal of "Enforce relationship for
replication".
Do I need to completely re-create the publication? If I can do it in a
script then what script do I use to run on the laptops and where can I find
the syntax for changing this relationship property? Thank you.
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OZyzv$SQHHA.1200@.TK2MSFTNGP02.phx.gbl...
> David - can you post up the script you were using and I'll take a look.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||Also, do I need to run sp_addscriptexec at both the publisher and
subscriber? I read the BOL and they said you have to be sysadmin to run it
but the laptops are not. Thanks.
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OZyzv$SQHHA.1200@.TK2MSFTNGP02.phx.gbl...
> David - can you post up the script you were using and I'll take a look.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||Hi David - have answered your other thread below.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||David,
the script is in the form:
ALTER TABLE dbo.yourFKtable
DROP CONSTRAINT yourFKtable1
GO
ALTER TABLE dbo.yourFKtable WITH NOCHECK ADD CONSTRAINT
yourFKtable1 FOREIGN KEY
(
PKColumn
) REFERENCES dbo.YourPKTable
(
pkcolumn
) NOT FOR REPLICATION
GO
You'll need to run this at the publisher to change the publisher tables then
add it to the publication using sp_addscriptexec.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Thanks Paul. Will I have to run sp_addscriptexec at the subscribers also or
will that happen when they synch?
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ufa1ml4QHHA.4632@.TK2MSFTNGP04.phx.gbl...
> David,
> the script is in the form:
> ALTER TABLE dbo.yourFKtable
> DROP CONSTRAINT yourFKtable1
> GO
> ALTER TABLE dbo.yourFKtable WITH NOCHECK ADD CONSTRAINT
> yourFKtable1 FOREIGN KEY
> (
> PKColumn
> ) REFERENCES dbo.YourPKTable
> (
> pkcolumn
> ) NOT FOR REPLICATION
> GO
> You'll need to run this at the publisher to change the publisher tables
> then add it to the publication using sp_addscriptexec.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
|||David - the merge agent will take care of applying it to the subscribers.
Cheers,
Paul Ibison

Changing table properties

Hi,
I have got approximately 100 tables. Their all attributes are same. But, I w
ant to change their one attribute.
Such as my table;
NAME nvarchar(50)
SNAME nvarchar(50)
SALARY float
I want to change SALARY's property from float to money. It is possible to th
is operation manually. But I need to this operation automaticallay via progr
amming language or via query analizer.
How can I do?Why would you want 100 identical tables? How about combining them into one.
If you have no choice but to support the current design then use a query out
of INFORMATION_SCHEMA.TABLES to generate the script.
SELECT 'ALTER TABLE '+
QUOTENAME(table_schema)+'.'+
QUOTENAME(table_name)+' ALTER COLUMN salary DECIMAL(10,2)'
FROM information_schema.tables
WHERE table_name LIKE ?
Now just cut and paste the results into Query Analyzer.
I recommend you avoid using MONEY for the salary column because MONEY has
some problems with precision in arithmetic operations. Use DECIMAL/NUMERIC
instead.
David Portas
SQL Server MVP
--|||Hi
I would do it slightly differently!!!
SELECT 'ALTER TABLE '+
QUOTENAME(table_schema)+'.'+
QUOTENAME(table_name)+' ALTER COLUMN ' + QUOTENAME(COLUMN_NAME) + '
DECIMAL(10,2)'
FROM information_schema.columns
WHERE COLUMN_NAME = 'Salary'
John
"David Portas" wrote:

> Why would you want 100 identical tables? How about combining them into one
.
> If you have no choice but to support the current design then use a query o
ut
> of INFORMATION_SCHEMA.TABLES to generate the script.
> SELECT 'ALTER TABLE '+
> QUOTENAME(table_schema)+'.'+
> QUOTENAME(table_name)+' ALTER COLUMN salary DECIMAL(10,2)'
> FROM information_schema.tables
> WHERE table_name LIKE ?
> Now just cut and paste the results into Query Analyzer.
> I recommend you avoid using MONEY for the salary column because MONEY has
> some problems with precision in arithmetic operations. Use DECIMAL/NUMERIC
> instead.
> --
> David Portas
> SQL Server MVP
> --
>
>

Changing table properties

Hi,
I have got approximately 100 tables. Their all attributes are same. But, I w
ant to change their one attribute.
Such as my table;
NAME nvarchar(50)
SNAME nvarchar(50)
SALARY float
I want to change SALARY's property from float to money. It is possible to th
is operation manually. But I need to this operation automaticallay via progr
amming language or via query analizer.
How can I do?See http://tinyurl.com/a3f26
"huseyin_akturk" wrote:

> Hi,
> I have got approximately 100 tables. Their all attributes are same.
> But, I want to change their one attribute.
> Such as my table;
> NAME nvarchar(50)
> SNAME nvarchar(50)
> SALARY float
> I want to change SALARY's property from float to money. It is possible
> to this operation manually. But I need to this operation automaticallay
> via programming language or via query analizer.
> How can I do?
>
> --
> huseyin_akturk
> ---
> Posted via http://www.codecomments.com
> ---
>

Changing table colon's properties

Hi,
I have got approximately 100 tables. Their all attributes are same. But, I
want to change their one attribute.
Such as my table;
NAME nvarchar(50)
SNAME nvarchar(50)
SALARY float
I want to change SALARY's property from float to money. It is possible to th
is operation manually. But I need to this operation automaticallay via
programming language or via query analizer.
How can I do?huseyin_akturk wrote:
> Hi,
> I have got approximately 100 tables. Their all attributes are same.
> But, I want to change their one attribute.
> Such as my table;
> NAME nvarchar(50)
> SNAME nvarchar(50)
> SALARY float
> I want to change SALARY's property from float to money. It is
> possible to th is operation manually. But I need to this operation
> automaticallay via programming language or via query analizer.
> How can I do?
You can add a new column Salary2 Money, Update the table and move all
the float values into the new money type (cast the value and round as
needed), drop the old column, and then rename the new column. Test in
dev before applying to production. You may also want to consider using a
DECIMAL(X) or INT for the salary, especially if you want a fixed number
of decimal places (say 2) or do not require decimal places at all.
The following example moves the salary values directly from one column
to the other.
Create Table dbo.SalaryTestXXX (
MyID INT IDENTITY NOT NULL PRIMARY KEY,
Salary FLOAT NULL )
go
Insert Into dbo.SalaryTestXXX Values (25000)
Insert Into dbo.SalaryTestXXX Values (50000)
Insert Into dbo.SalaryTestXXX Values (75000)
Insert Into dbo.SalaryTestXXX Values (100000)
Select * from dbo.SalaryTestXXX
go
Alter Table dbo.SalaryTestXXX
Add Salary2 Money
go
Select * from dbo.SalaryTestXXX
Update dbo.SalaryTestXXX
Set Salary2 = Salary
Where Salary IS NOT NULL
go
Select * from dbo.SalaryTestXXX
go
Alter Table dbo.SalaryTestXXX
Drop Column Salary
go
Select * from dbo.SalaryTestXXX
Exec sp_rename 'dbo.SalaryTestXXX.Salary2', 'Salary', 'COLUMN'
Select * from dbo.SalaryTestXXX
Drop Table dbo.SalaryTestXXX
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Are you sure you want to change it to MONEY? MONEY data type might not be
exactly what you think it is. You might want to use NUMERIC(18, 2) or
NUMERIC(18, 4) or some other variation of NUMERIC instead of MONEY... MONEY
stores currency display information in the same column as the value, which
can cause headaches.
"huseyin_akturk" <huseyinakturk@.discussions.microsoft.com> wrote in message
news:7C2B0E2B-FEA8-4BA2-8777-CC1D0DED37E3@.microsoft.com...
> Hi,
> I have got approximately 100 tables. Their all attributes are same. But, I
> want to change their one attribute.
> Such as my table;
> NAME nvarchar(50)
> SNAME nvarchar(50)
> SALARY float
> I want to change SALARY's property from float to money. It is possible to
> th
> is operation manually. But I need to this operation automaticallay via
> programming language or via query analizer.
> How can I do?
>|||See if this helps:
use tempdb
go
create table t1 (
salary float
)
go
insert into t1 values(1245.07)
go
select * from t1
go
declare @.sql nvarchar(4000)
declare @.ts sysname
declare @.tn sysname
declare @.cn sysname
declare columns_cursor cursor local fast_forward
for
select
table_schema,
table_name
from
information_schema.columns
where
column_name = 'salary'
and data_type = 'float'
and objectproperty(object_id(quotename(table
_schema) + '.' +
quotename(table_name)), 'IsMSShipped') = 0
open columns_cursor
while 1 = 1
begin
fetch next from columns_cursor into @.ts, @.tn
if @.@.error != 0 or @.@.fetch_status != 0 break
set @.sql = N'alter table ' + quotename(@.ts) + '.' + quotename(@.tn) + N'
alter column salary money'
print @.sql
exec sp_executesql @.sql
end
close columns_cursor
deallocate columns_cursor
go
select * from t1
go
drop table t1
go
AMB
"huseyin_akturk" wrote:

> Hi,
> I have got approximately 100 tables. Their all attributes are same. But, I
> want to change their one attribute.
> Such as my table;
> NAME nvarchar(50)
> SNAME nvarchar(50)
> SALARY float
> I want to change SALARY's property from float to money. It is possible to
th
> is operation manually. But I need to this operation automaticallay via
> programming language or via query analizer.
> How can I do?
>

Changing SubNet Mask in Virtual SQL server

Hi,
Due to re-engineering of our Network infrastructure, we need to change the
SubNet Mask Properties in the SQL Virtual IP resource. We are using SQL 7.0
clustered on 2 Active & Passive nodes. The SubNet masks and Gateway of the 2
nodes also required to be changed. IP address remain the same.
Can anyone advise if I required to unclustered the SQL to change the SubNet
Mask or What is the proper procedure to do this exercise. This is a
production system and downtime has to be minimised. Pls advise asap.
Thank you in advance.
Thong KC
Just follow the steps listed here
http://support.microsoft.com/default...b;en-us;244980
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"kcThong" <kcThong@.discussions.microsoft.com> wrote in message
news:2DFCFD98-1349-4844-90E6-AE281DD1269F@.microsoft.com...
> Hi,
> Due to re-engineering of our Network infrastructure, we need to change the
> SubNet Mask Properties in the SQL Virtual IP resource. We are using SQL
> 7.0
> clustered on 2 Active & Passive nodes. The SubNet masks and Gateway of the
> 2
> nodes also required to be changed. IP address remain the same.
> Can anyone advise if I required to unclustered the SQL to change the
> SubNet
> Mask or What is the proper procedure to do this exercise. This is a
> production system and downtime has to be minimised. Pls advise asap.
> Thank you in advance.
> Thong KC
>

Changing SSIS property defaults

To make certain SSIS features work there are many properties that need to be set over and over for most containers in the package. For example with Checkpoint\Restart, you need to set (in most cases) all of the tasks' FailPackageOnFailure to True. If you miss one, the package may not restart properly and you might never know. There are other situations where as a development team we want certain properties to be usually set the same but differently from the SSIS default.

Is there a way to control the defaults that the SSIS IDE uses?

I remember back in classic VB that if you wanted to change the defaults of a bare form you could create a template form adjusted the way you like and put it in a templates folder. Then new forms added to a project would be based on the template form.

No worries. The same thing exists for SSIS:

SSIS: Location for your package templates
(http://blogs.conchango.com/jamiethomson/archive/2005/11/12/2380.aspx)

It won't allow you to set default properties of tasks though - which I think is what you are after.

-Jamie

|||

Yes, I was hoping to set defaults for packages and tasks. Any recommendations? Our DTS developers are balking at the multitude of properties needed to be set to implement certain features.

What do you name the templates that you put in the templates folder so that they are used in the IDE? Package1.dtsx?

Thanks.

|||

Chopaka wrote:

Yes, I was hoping to set defaults for packages and tasks. Any recommendations? Our DTS developers are balking at the multitude of properties needed to be set to implement certain features.

Sorry, that's not possible. It would be nice if it were though - perhaps you could suggest it at Microsoft Connect.

Whenever they build the ability to reuse pre-configured tasks then you will be able to do it. I wouldn't expect that until v3 at the earliest though.

Chopaka wrote:

What do you name the templates that you put in the templates folder so that they are used in the IDE? Package1.dtsx?

Whatever you like!

-Jamie

Changing Server Report on the fly

I would like to modify some of the properties of a ServerReport entity from a desktop app using the ReportViewer control. In particular, I would like to have the document map displayed as expanded, and make some changes to the group toggle items based on the user's parameter selection.

Can someone please point me in the right direction? How do I get access programmatically to the ServerReport layout?

Thx

In the event I'm way off base just disregard this post.

Create a parameter of your choice and name it for example "ExpandDetails" and apply the Data Type as Boolean. In the default values select “Non-Queried” and type “False”

Select the table in question, open up the Properties of the table, select the group that controls the expanded element, Edit the group you selected, change from the General tab to the Visibility tab, select Expression, add this code"=Iif(Parameters!ExpandDetails.Value = True, False, True)"

Select the textbox where the expanded element will occur, open up the Properties of the textbox. Change from the General tab to the Visibility tab. Select Expression at the bottom of the dialog box where you see “Expanded” and “Collapsed”, add this code “=Iif(Parameters!ExpandDetails.Value = True, True, False)”

This will create a parameter named ExpandDetails with a radio box selection. Click on the appropriate value and select “View Report”

Tweak the logic to work in the manner you need. by that I mean the true or false of the IIF statements.

|||

Thanks for the reply.

I've actually tried what you suggest. My situation is that I allow my users to choose an outer group, and an inner group, with the option of choosing "None" (I.e. no inner grouping) for the inner group. I've managed to get it all working (except for the +/- icons being reversed in some cases) but I have not been able to get the Expand/Collapse to work, mainly because I have no way (that I can see) of changing a ToggleItem based on an expression.

So I need to get down and dirty with the rdl before rendering the report, and am hunting around for how to proceed. I suspect I need to dump the report using LoadReport into a memory stream and cast it somehow, but some sample code with be helpful.

Cheers,

changing password for sql server service and sql agent service

If I change the password for sql server under the server/properties/security
tab and for sql agent under sql server agent/properties/general tab do I
still have to change the password in windows services? Or does changing the
passwords within em also change the password in services?
But if I change the passwords in windows services do I also have to change
the passwords in sql server?
Thanks,
Dan D.
Always change them in Enterprise Manager. That is enough. You don't have to
change them again from Services.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
> If I change the password for sql server under the
> server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing
> the
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.
|||> If I change the password for sql server under the server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing the
> passwords within em also change the password in services?
Yes it does.

> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
No, but it is recommended to do this using SQLEM. There are other things
that EM does regarding to this operation. Read the "Important" note at the
end.
Changing Passwords and User Accounts
http://msdn.microsoft.com/library/de...stall_4p0z.asp
AMB
"Dan D." wrote:

> If I change the password for sql server under the server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing the
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.
|||I did try to change the password in sql agent/properties after changing the
password for sql agent in services and I got this message:
"SQL Server Agent start-up account could not be verifited."
Do you think it means that the password entered in SQL Agent/Properties and
the password entered in the SQL Agent service were not the same?
Thanks,
Dan D.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Yes it does.
>
> No, but it is recommended to do this using SQLEM. There are other things
> that EM does regarding to this operation. Read the "Important" note at the
> end.
> Changing Passwords and User Accounts
> http://msdn.microsoft.com/library/de...stall_4p0z.asp
>
> AMB
> "Dan D." wrote:
|||Dan,
Sorry, no idea.
AMB
"Dan D." wrote:
[vbcol=seagreen]
> I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
|||Thanks.
Dan D.
"Narayana Vyas Kondreddi" wrote:

> Always change them in Enterprise Manager. That is enough. You don't have to
> change them again from Services.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
>
>
|||Are the two services using the same service account? I could imagine that if they aren't, then SQL
Server cannot verify the password for another account (Agent).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...[vbcol=seagreen]
>I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
|||The sql server service and the sql agen tservice are using different
accounts. But the account that the sql agent servce is using and the account
under sql agent/properties/general tab are the same.
Dan D.
"Tibor Karaszi" wrote:

> Are the two services using the same service account? I could imagine that if they aren't, then SQL
> Server cannot verify the password for another account (Agent).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...
>
|||Hello, I'm Legacy. I have no idea what sql server is, but could someone
please tell me how to change my password.
"Dan D." wrote:
[vbcol=seagreen]
> I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:

changing password for sql server service and sql agent service

If I change the password for sql server under the server/properties/security
tab and for sql agent under sql server agent/properties/general tab do I
still have to change the password in windows services? Or does changing the
passwords within em also change the password in services?
But if I change the passwords in windows services do I also have to change
the passwords in sql server?
Thanks,
--
Dan D.Always change them in Enterprise Manager. That is enough. You don't have to
change them again from Services.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
> If I change the password for sql server under the
> server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing
> the
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.|||> If I change the password for sql server under the server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing the
> passwords within em also change the password in services?
Yes it does.
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
No, but it is recommended to do this using SQLEM. There are other things
that EM does regarding to this operation. Read the "Important" note at the
end.
Changing Passwords and User Accounts
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
AMB
"Dan D." wrote:
> If I change the password for sql server under the server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing the
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.|||I did try to change the password in sql agent/properties after changing the
password for sql agent in services and I got this message:
"SQL Server Agent start-up account could not be verifited."
Do you think it means that the password entered in SQL Agent/Properties and
the password entered in the SQL Agent service were not the same?
Thanks,
--
Dan D.
"Alejandro Mesa" wrote:
> > If I change the password for sql server under the server/properties/security
> > tab and for sql agent under sql server agent/properties/general tab do I
> > still have to change the password in windows services? Or does changing the
> > passwords within em also change the password in services?
> Yes it does.
> > But if I change the passwords in windows services do I also have to change
> > the passwords in sql server?
> No, but it is recommended to do this using SQLEM. There are other things
> that EM does regarding to this operation. Read the "Important" note at the
> end.
> Changing Passwords and User Accounts
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
>
> AMB
> "Dan D." wrote:
> > If I change the password for sql server under the server/properties/security
> > tab and for sql agent under sql server agent/properties/general tab do I
> > still have to change the password in windows services? Or does changing the
> > passwords within em also change the password in services?
> >
> > But if I change the passwords in windows services do I also have to change
> > the passwords in sql server?
> >
> > Thanks,
> > --
> > Dan D.|||Dan,
Sorry, no idea.
AMB
"Dan D." wrote:
> I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
> > > If I change the password for sql server under the server/properties/security
> > > tab and for sql agent under sql server agent/properties/general tab do I
> > > still have to change the password in windows services? Or does changing the
> > > passwords within em also change the password in services?
> >
> > Yes it does.
> >
> > > But if I change the passwords in windows services do I also have to change
> > > the passwords in sql server?
> >
> > No, but it is recommended to do this using SQLEM. There are other things
> > that EM does regarding to this operation. Read the "Important" note at the
> > end.
> >
> > Changing Passwords and User Accounts
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
> >
> >
> > AMB
> >
> > "Dan D." wrote:
> >
> > > If I change the password for sql server under the server/properties/security
> > > tab and for sql agent under sql server agent/properties/general tab do I
> > > still have to change the password in windows services? Or does changing the
> > > passwords within em also change the password in services?
> > >
> > > But if I change the passwords in windows services do I also have to change
> > > the passwords in sql server?
> > >
> > > Thanks,
> > > --
> > > Dan D.|||Thanks.
--
Dan D.
"Narayana Vyas Kondreddi" wrote:
> Always change them in Enterprise Manager. That is enough. You don't have to
> change them again from Services.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
> > If I change the password for sql server under the
> > server/properties/security
> > tab and for sql agent under sql server agent/properties/general tab do I
> > still have to change the password in windows services? Or does changing
> > the
> > passwords within em also change the password in services?
> >
> > But if I change the passwords in windows services do I also have to change
> > the passwords in sql server?
> >
> > Thanks,
> > --
> > Dan D.
>
>|||Are the two services using the same service account? I could imagine that if they aren't, then SQL
Server cannot verify the password for another account (Agent).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...
>I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
>> > If I change the password for sql server under the server/properties/security
>> > tab and for sql agent under sql server agent/properties/general tab do I
>> > still have to change the password in windows services? Or does changing the
>> > passwords within em also change the password in services?
>> Yes it does.
>> > But if I change the passwords in windows services do I also have to change
>> > the passwords in sql server?
>> No, but it is recommended to do this using SQLEM. There are other things
>> that EM does regarding to this operation. Read the "Important" note at the
>> end.
>> Changing Passwords and User Accounts
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
>>
>> AMB
>> "Dan D." wrote:
>> > If I change the password for sql server under the server/properties/security
>> > tab and for sql agent under sql server agent/properties/general tab do I
>> > still have to change the password in windows services? Or does changing the
>> > passwords within em also change the password in services?
>> >
>> > But if I change the passwords in windows services do I also have to change
>> > the passwords in sql server?
>> >
>> > Thanks,
>> > --
>> > Dan D.|||The sql server service and the sql agen tservice are using different
accounts. But the account that the sql agent servce is using and the account
under sql agent/properties/general tab are the same.
--
Dan D.
"Tibor Karaszi" wrote:
> Are the two services using the same service account? I could imagine that if they aren't, then SQL
> Server cannot verify the password for another account (Agent).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...
> >I did try to change the password in sql agent/properties after changing the
> > password for sql agent in services and I got this message:
> >
> > "SQL Server Agent start-up account could not be verifited."
> >
> > Do you think it means that the password entered in SQL Agent/Properties and
> > the password entered in the SQL Agent service were not the same?
> >
> > Thanks,
> >
> > --
> > Dan D.
> >
> >
> > "Alejandro Mesa" wrote:
> >
> >> > If I change the password for sql server under the server/properties/security
> >> > tab and for sql agent under sql server agent/properties/general tab do I
> >> > still have to change the password in windows services? Or does changing the
> >> > passwords within em also change the password in services?
> >>
> >> Yes it does.
> >>
> >> > But if I change the passwords in windows services do I also have to change
> >> > the passwords in sql server?
> >>
> >> No, but it is recommended to do this using SQLEM. There are other things
> >> that EM does regarding to this operation. Read the "Important" note at the
> >> end.
> >>
> >> Changing Passwords and User Accounts
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
> >>
> >>
> >> AMB
> >>
> >> "Dan D." wrote:
> >>
> >> > If I change the password for sql server under the server/properties/security
> >> > tab and for sql agent under sql server agent/properties/general tab do I
> >> > still have to change the password in windows services? Or does changing the
> >> > passwords within em also change the password in services?
> >> >
> >> > But if I change the passwords in windows services do I also have to change
> >> > the passwords in sql server?
> >> >
> >> > Thanks,
> >> > --
> >> > Dan D.
>|||Hello, I'm Legacy. I have no idea what sql server is, but could someone
please tell me how to change my password.
"Dan D." wrote:
> I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
> > > If I change the password for sql server under the server/properties/security
> > > tab and for sql agent under sql server agent/properties/general tab do I
> > > still have to change the password in windows services? Or does changing the
> > > passwords within em also change the password in services?
> >
> > Yes it does.
> >
> > > But if I change the passwords in windows services do I also have to change
> > > the passwords in sql server?
> >
> > No, but it is recommended to do this using SQLEM. There are other things
> > that EM does regarding to this operation. Read the "Important" note at the
> > end.
> >
> > Changing Passwords and User Accounts
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
> >
> >
> > AMB
> >
> > "Dan D." wrote:
> >
> > > If I change the password for sql server under the server/properties/security
> > > tab and for sql agent under sql server agent/properties/general tab do I
> > > still have to change the password in windows services? Or does changing the
> > > passwords within em also change the password in services?
> > >
> > > But if I change the passwords in windows services do I also have to change
> > > the passwords in sql server?
> > >
> > > Thanks,
> > > --
> > > Dan D.

changing password for sql server service and sql agent service

If I change the password for sql server under the server/properties/security
tab and for sql agent under sql server agent/properties/general tab do I
still have to change the password in windows services? Or does changing the
passwords within em also change the password in services?
But if I change the passwords in windows services do I also have to change
the passwords in sql server?
Thanks,
--
Dan D.Always change them in Enterprise Manager. That is enough. You don't have to
change them again from Services.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
> If I change the password for sql server under the
> server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing
> the
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.|||> If I change the password for sql server under the server/properties/securityn">
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing th
e
> passwords within em also change the password in services?
Yes it does.

> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
No, but it is recommended to do this using SQLEM. There are other things
that EM does regarding to this operation. Read the "Important" note at the
end.
Changing Passwords and User Accounts
http://msdn.microsoft.com/library/d...nstall_4p0z.asp
AMB
"Dan D." wrote:

> If I change the password for sql server under the server/properties/securi
ty
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing th
e
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.|||I did try to change the password in sql agent/properties after changing the
password for sql agent in services and I got this message:
"SQL Server Agent start-up account could not be verifited."
Do you think it means that the password entered in SQL Agent/Properties and
the password entered in the SQL Agent service were not the same?
Thanks,
Dan D.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Yes it does.
>
> No, but it is recommended to do this using SQLEM. There are other things
> that EM does regarding to this operation. Read the "Important" note at the
> end.
> Changing Passwords and User Accounts
> http://msdn.microsoft.com/library/d...nstall_4p0z.asp
>
> AMB
> "Dan D." wrote:
>|||Dan,
Sorry, no idea.
AMB
"Dan D." wrote:
[vbcol=seagreen]
> I did try to change the password in sql agent/properties after changing th
e
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties an
d
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
>|||Thanks.
--
Dan D.
"Narayana Vyas Kondreddi" wrote:

> Always change them in Enterprise Manager. That is enough. You don't have t
o
> change them again from Services.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
>
>|||Are the two services using the same service account? I could imagine that if
they aren't, then SQL
Server cannot verify the password for another account (Agent).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...[vbcol=seagreen]
>I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties an
d
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
>|||The sql server service and the sql agen tservice are using different
accounts. But the account that the sql agent servce is using and the account
under sql agent/properties/general tab are the same.
--
Dan D.
"Tibor Karaszi" wrote:

> Are the two services using the same service account? I could imagine that
if they aren't, then SQL
> Server cannot verify the password for another account (Agent).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...
>|||Hello, I'm Legacy. I have no idea what sql server is, but could someone
please tell me how to change my password.
"Dan D." wrote:
[vbcol=seagreen]
> I did try to change the password in sql agent/properties after changing th
e
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties an
d
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
>

Changing Object Explorer Details Window

is it possible to change the columns that display in the Object Explorer
Details Window? I'd like to be able see some Extended Properties in this
window.
TIA
Dean
Nope...sorry but that's not an option.
-Sue
On Fri, 10 Aug 2007 09:51:26 -0400, "Dean"
<deanl144@.hotmail.com.nospam> wrote:

>is it possible to change the columns that display in the Object Explorer
>Details Window? I'd like to be able see some Extended Properties in this
>window.
>TIA
>Dean
>

Changing number to date

I have a table in SQL Server that has a date field whose properties are 'number'. I want to export this data to a table in Oracle. I can't touch the Server table to alter it to be a date. Is there some way I can do this in the Oracle table? Example- SQL Server= 20030324 (March 24,2003). In Oracle I want it to read '24/03/2003', or some other date format.declare @.d as int
set @.d = 20031105
select cast(substring(cast(@.d as varchar(8)),5,2)+ '/' +
substring(cast(@.d as varchar(8)),7,2)+ '/' +
left(cast(@.d as varchar(8)),4)as smalldatetime)|||I need to update a whole column in an Oracle table. Thanks.

Changing MS SQL Server Express table properties

Hi,
I have a MS SQL Server Express database wich I upsized once from MSAccess. I can connect to it and get/insert data but I can't update thefield properties.
I've used Access 2003, Visual Studio .Net and SQL Server Web DataAdministrator, but I can't change the properties of existing tables. Icán add new tables and add their properties afterwards. Since I have alot of tables it would be too much work too recreate them all. So howcan I edit my existing tables?
Create new identical tables for each and do INSERT INTO and drop all the old tables so you have new SQL Server Express tables that you can modify. Hope this helps.

Changing language helps ( rrRenderingError) but.....

I want to display my reports in dutch.
Of what is the language dependent? server properties ?
Can you explain how the export to PDF-format effects the report-language
properties and/or serverproperties ?
Thanks in AdvanceLanguage is a Report property.
Open the Properties window (F4), and select 'Report' from the dropdown list.
Language is the second-last property displayed.
If you set it to Dutch, functions like Month() will return Dutch month names.
My 2c.
Flip
"Bobby" wrote:
> I want to display my reports in dutch.
> Of what is the language dependent? server properties ?
> Can you explain how the export to PDF-format effects the report-language
> properties and/or serverproperties ?
> Thanks in Advance
>
>
>

Changing Data and Backup folder properties in SSAS

Hi All -

Can we change the data and backup folder location from SSAS properties? Can it have any kind of adverse impact ?

Thanks for help in advance.

Hi,

Changing the backup location is not an issue, just remember to create the new directory folder otherwise it doesn't actually back it up. Would assume the same is true for the data folder, but I haven't tried this.

Cheers

Matt

Changing control/Property box values

Help!
I'm trying to figure out how to change the values on the properties control
box dynamically. Things such as Hidden, size, font. With the RS format of
<name>!<fieldname>.Value, how are such things called?
Example code (which doesn't work because of compile problems:
=iif(Fields!TableName.Value = Parameters!tblName.Value,
ReportItems!Hidden.Value = "False", ReportItems!Hidden.Value = "True")
The goal is to hide a list box/field. What do I use in place of
ReportItems!Hidden.Value to make this work?
Thanks,
CatadminHi,
I have the same problem as you. I'm trying with custom code, you can see a
description:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_1nfp.asp
But only can access the "value", somethig like this:
Function NullData (txt As textbox) As Boolean
If (txt.value = "") Or _
(txt.value) Is Nothing Then
Return False
End If
Return True
End Function
I'm working to change the width property value. If I'm sucess I will post
here.
Maybe you can do something more with this. I hope it can be helpfull.
"Catadmin" wrote:
> Help!
> I'm trying to figure out how to change the values on the properties control
> box dynamically. Things such as Hidden, size, font. With the RS format of
> <name>!<fieldname>.Value, how are such things called?
> Example code (which doesn't work because of compile problems:
> =iif(Fields!TableName.Value = Parameters!tblName.Value,
> ReportItems!Hidden.Value = "False", ReportItems!Hidden.Value = "True")
> The goal is to hide a list box/field. What do I use in place of
> ReportItems!Hidden.Value to make this work?
> Thanks,
> Catadmin