Hi, trouble with the db owner

Hi everybody... I'd like to change the db owner in a SQL Server 2000,
is it possible? I'd like someone to tell me how can i do thisLook in Books Online about how to use: sp_changedbowner
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Emmanuel" <emmanuel.ps@.gmail.com> wrote in message
news:1162054147.202137.27430@.e64g2000cwd.googlegroups.com...
> Hi everybody... I'd like to change the db owner in a SQL Server 2000,
> is it possible? I'd like someone to tell me how can i do this
>

Hi, trouble with the db owner

Hi everybody... I'd like to change the db owner in a SQL Server 2000,
is it possible? I'd like someone to tell me how can i do thisLook in Books Online about how to use: sp_changedbowner
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Emmanuel" <emmanuel.ps@.gmail.com> wrote in message
news:1162054147.202137.27430@.e64g2000cwd.googlegroups.com...
> Hi everybody... I'd like to change the db owner in a SQL Server 2000,
> is it possible? I'd like someone to tell me how can i do this
>

Help:DTC-Firewall-SQL server clustering

Hello All
I am having trouble of DTC to get working thru firewall
The setup we have is
Two web servers load balanced. Componets run off the web servers. (OS:2000 Server
Two SQL server clusered.(OS: 2000 advanced server)
Web servers and SQL Servers are in different domain separated by firewall
Components do not work if I set "transaction required". If I changed it to "Transaction suported" or "not supported" some componets do work
I tried suggestions from kb article
DTCPing: http://support.microsoft.com/?id=30684
Initially DTCping had some problem but for testing purpose we opened all ports on firewall. It worked
I tried another config suggestion
http://support.microsoft.com/?id=25036
When I apply the registry entries for ports mentioned in this article, it disabled Clustering service. I was not able to get it back until I revert back registry settings
I tried DTCtester utility, it doesn't work
Does any one know why it must be disabling the clustering service? or Have any other suggestions on configuration for DTC thru Firewall
Thank
MilsThanks Jeff
I tried the procedure you mentioned. but it did not help
I have already tried the DTCping utility. At first it did not work but then I opened all the ports on firewall. now DTCping works.
DTCtester.exe utility still does not run, it gives error
Output of utility
****************
E:\netins>dtctester vssql01 uname Pw
Executed: dtcteste
DSN: vssql0
User Name: unam
Password: pw
tablename= #dtc1236
Creating Temp Table for Testing: #dtc1236
Warning: No Columns in Result Set From Executing: 'create table #dtc12365 (iva
int)
Initializing DT
Beginning DTC Transactio
Enlisting Connection in Transactio
Error
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server Driver
Distributed transaction error
Error
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid cu
sor stat
Typical Errors in DTC Output Whe
a. Firewall Has Ports Close
-OR
b. Bad WINS/DNS entrie
-OR
c. Misconfigured networ
-OR
d. Misconfigured SQL Server machine that has multiple netcards
Aborting DTC Transactio
Releasing DTC Interface Pointer
Successfully Released pTransaction Pointer.
*********************************
One of the error description refers to multiple netcards. Our SQL server has multiple netcards.
Any idea if there's any specific configuration for SQL Server using multiple netcards
Thanks
Milin|||1. Are the ports still open. If not then you need to open ports 445, 135,137-9, plus the ones you set in DCOMCNFG
2. Do you have an entry in each server of the cluster's host file with an entry to the destination server. and likewise on the destination for each of the Clustered servers
3. Does DTCPing work both ways now also
Jef
MCDBA, MCSE+I|||Yes. All ports are still open in both directions
I have entries in hosts files of both servers. I can access these servers using network names from each other
DTCping work in both directions
Thank
mil|||Did you actually set the ports with DCOMCNFG and reboot or did you just try the reg hack
If not then set DCOMCNFG on all servers to use the proper ports and reboot all servers
Other than that I cannot think of anything else
Good Luc
Jeff|||Mil
I am sorry then. In all my experience once I have had DTCping working I have had DTC working as well
Jeff|||"mils" wrote:
> When I apply the registry entries for ports mentioned in this article, it disabled Clustering service. I was not able to get it back until I revert back registry settings.
Hi,
I have the same problem.
when i set the port by dcomcfg (or by registry), the nodes cannot start clustering services.
WhY '
How can i do ?
thanks in advance !!
Regards, Dario

Help: trouble dropping master key

It could be trivial question.

I have trouble dropping master key. when i execute the following query..

open master key decryption by password = 'pass1234$'

alter master key drop encryption by password = 'pass1234$'

close master key

drop master key

go

I get the following result..

Msg 15558, Level 16, State 1, Line 3

Cannot drop encryption by password '********'.

Msg 15580, Level 16, State 1, Line 5

Cannot drop master key because certificate 'BackofficeServiceAccount' is encrypted by it.

But 'BackofficeServiceAccount' was already dropped.

Can any one help me how to drop master key?

I appreciate any input..

regards...

I realized the script was creating login and certificate with the same name.

Dropping the certificate first, helped dropping the master key...

HELP: Problem with naming convention.

I'm trying to update a table in one database with data from a table in
another database on the same server, but I'm having trouble with my naming
convention.
Here's the script (thanks to Russel Loski for providing it):
update DB1.dbo.table1
set col1 = Db2.dbo.table1.col1
from DB1.dbo.table1
inner join
DB2.dbo.table1
on DB1.dbo.table1.col2 = DB2.dbo.table1.col2
where DB2.dbo.table1.col1 like 'text string'
When I run it I get this error:
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'DB2' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
I'm sure it's because I'm using a 4-part name (Db2.dbo.table1.col1) and it's
trying to resolve the database as a server. I don't know of another way to
point to the database. Can anyone help?
Thanks in advance.
John
Hi John,
Are u able to see another server(linked server on which DB2 resides) in
sysservers table. If yes, then please use the following notation:
Servername.dbname.tablename--make it an alias and then refer the desired
column using aliasname.columnname
For e.g
select Server2.col1 from Linkedservername.DB2.dbo.table1 Server2
Manu
"John Steen" wrote:

> I'm trying to update a table in one database with data from a table in
> another database on the same server, but I'm having trouble with my naming
> convention.
> Here's the script (thanks to Russel Loski for providing it):
> update DB1.dbo.table1
> set col1 = Db2.dbo.table1.col1
> from DB1.dbo.table1
> inner join
> DB2.dbo.table1
> on DB1.dbo.table1.col2 = DB2.dbo.table1.col2
> where DB2.dbo.table1.col1 like 'text string'
> When I run it I get this error:
> Server: Msg 7202, Level 11, State 2, Line 1
> Could not find server 'DB2' in sysservers. Execute
> sp_addlinkedserver to add the server to sysservers.
> I'm sure it's because I'm using a 4-part name (Db2.dbo.table1.col1) and it's
> trying to resolve the database as a server. I don't know of another way to
> point to the database. Can anyone help?
> Thanks in advance.
> John
>
|||John Steen wrote:
> I'm trying to update a table in one database with data from a table in
> another database on the same server, but I'm having trouble with my naming
> convention.
> Here's the script (thanks to Russel Loski for providing it):
> update DB1.dbo.table1
> set col1 = Db2.dbo.table1.col1
> from DB1.dbo.table1
> inner join
> DB2.dbo.table1
> on DB1.dbo.table1.col2 = DB2.dbo.table1.col2
> where DB2.dbo.table1.col1 like 'text string'
> When I run it I get this error:
> Server: Msg 7202, Level 11, State 2, Line 1
> Could not find server 'DB2' in sysservers. Execute
> sp_addlinkedserver to add the server to sysservers.
> I'm sure it's because I'm using a 4-part name (Db2.dbo.table1.col1) and it's
> trying to resolve the database as a server. I don't know of another way to
> point to the database. Can anyone help?
> Thanks in advance.
> John
>
Use aliases.
update DB1.dbo.table1
set col1 = Db2.dbo.table1.col1
from DB1.dbo.table1 d1
inner join
DB2.dbo.table1 d2
on d1.col2 = d2.col2
where d2.col1 like 'text string'

HELP: Problem with naming convention.

I'm trying to update a table in one database with data from a table in
another database on the same server, but I'm having trouble with my naming
convention.
Here's the script (thanks to Russel Loski for providing it):
update DB1.dbo.table1
set col1 = Db2.dbo.table1.col1
from DB1.dbo.table1
inner join
DB2.dbo.table1
on DB1.dbo.table1.col2 = DB2.dbo.table1.col2
where DB2.dbo.table1.col1 like 'text string'
When I run it I get this error:
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'DB2' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
I'm sure it's because I'm using a 4-part name (Db2.dbo.table1.col1) and it's
trying to resolve the database as a server. I don't know of another way to
point to the database. Can anyone help?
Thanks in advance.
JohnHi John,
Are u able to see another server(linked server on which DB2 resides) in
sysservers table. If yes, then please use the following notation:
Servername.dbname.tablename--make it an alias and then refer the desired
column using aliasname.columnname
For e.g
select Server2.col1 from Linkedservername.DB2.dbo.table1 Server2
Manu
"John Steen" wrote:

> I'm trying to update a table in one database with data from a table in
> another database on the same server, but I'm having trouble with my naming
> convention.
> Here's the script (thanks to Russel Loski for providing it):
> update DB1.dbo.table1
> set col1 = Db2.dbo.table1.col1
> from DB1.dbo.table1
> inner join
> DB2.dbo.table1
> on DB1.dbo.table1.col2 = DB2.dbo.table1.col2
> where DB2.dbo.table1.col1 like 'text string'
> When I run it I get this error:
> Server: Msg 7202, Level 11, State 2, Line 1
> Could not find server 'DB2' in sysservers. Execute
> sp_addlinkedserver to add the server to sysservers.
> I'm sure it's because I'm using a 4-part name (Db2.dbo.table1.col1) and it
's
> trying to resolve the database as a server. I don't know of another way t
o
> point to the database. Can anyone help?
> Thanks in advance.
> John
>|||John Steen wrote:
> I'm trying to update a table in one database with data from a table in
> another database on the same server, but I'm having trouble with my naming
> convention.
> Here's the script (thanks to Russel Loski for providing it):
> update DB1.dbo.table1
> set col1 = Db2.dbo.table1.col1
> from DB1.dbo.table1
> inner join
> DB2.dbo.table1
> on DB1.dbo.table1.col2 = DB2.dbo.table1.col2
> where DB2.dbo.table1.col1 like 'text string'
> When I run it I get this error:
> Server: Msg 7202, Level 11, State 2, Line 1
> Could not find server 'DB2' in sysservers. Execute
> sp_addlinkedserver to add the server to sysservers.
> I'm sure it's because I'm using a 4-part name (Db2.dbo.table1.col1) and it
's
> trying to resolve the database as a server. I don't know of another way t
o
> point to the database. Can anyone help?
> Thanks in advance.
> John
>
Use aliases.
update DB1.dbo.table1
set col1 = Db2.dbo.table1.col1
from DB1.dbo.table1 d1
inner join
DB2.dbo.table1 d2
on d1.col2 = d2.col2
where d2.col1 like 'text string'

HELP: Problem with naming convention.

I'm trying to update a table in one database with data from a table in
another database on the same server, but I'm having trouble with my naming
convention.
Here's the script (thanks to Russel Loski for providing it):
update DB1.dbo.table1
set col1 = Db2.dbo.table1.col1
from DB1.dbo.table1
inner join
DB2.dbo.table1
on DB1.dbo.table1.col2 = DB2.dbo.table1.col2
where DB2.dbo.table1.col1 like 'text string'
When I run it I get this error:
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'DB2' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
I'm sure it's because I'm using a 4-part name (Db2.dbo.table1.col1) and it's
trying to resolve the database as a server. I don't know of another way to
point to the database. Can anyone help?
Thanks in advance.
JohnHi John,
Are u able to see another server(linked server on which DB2 resides) in
sysservers table. If yes, then please use the following notation:
Servername.dbname.tablename--make it an alias and then refer the desired
column using aliasname.columnname
For e.g
select Server2.col1 from Linkedservername.DB2.dbo.table1 Server2
Manu
"John Steen" wrote:
> I'm trying to update a table in one database with data from a table in
> another database on the same server, but I'm having trouble with my naming
> convention.
> Here's the script (thanks to Russel Loski for providing it):
> update DB1.dbo.table1
> set col1 = Db2.dbo.table1.col1
> from DB1.dbo.table1
> inner join
> DB2.dbo.table1
> on DB1.dbo.table1.col2 = DB2.dbo.table1.col2
> where DB2.dbo.table1.col1 like 'text string'
> When I run it I get this error:
> Server: Msg 7202, Level 11, State 2, Line 1
> Could not find server 'DB2' in sysservers. Execute
> sp_addlinkedserver to add the server to sysservers.
> I'm sure it's because I'm using a 4-part name (Db2.dbo.table1.col1) and it's
> trying to resolve the database as a server. I don't know of another way to
> point to the database. Can anyone help?
> Thanks in advance.
> John
>|||John Steen wrote:
> I'm trying to update a table in one database with data from a table in
> another database on the same server, but I'm having trouble with my naming
> convention.
> Here's the script (thanks to Russel Loski for providing it):
> update DB1.dbo.table1
> set col1 = Db2.dbo.table1.col1
> from DB1.dbo.table1
> inner join
> DB2.dbo.table1
> on DB1.dbo.table1.col2 = DB2.dbo.table1.col2
> where DB2.dbo.table1.col1 like 'text string'
> When I run it I get this error:
> Server: Msg 7202, Level 11, State 2, Line 1
> Could not find server 'DB2' in sysservers. Execute
> sp_addlinkedserver to add the server to sysservers.
> I'm sure it's because I'm using a 4-part name (Db2.dbo.table1.col1) and it's
> trying to resolve the database as a server. I don't know of another way to
> point to the database. Can anyone help?
> Thanks in advance.
> John
>
Use aliases.
update DB1.dbo.table1
set col1 = Db2.dbo.table1.col1
from DB1.dbo.table1 d1
inner join
DB2.dbo.table1 d2
on d1.col2 = d2.col2
where d2.col1 like 'text string'

HELP: problem updating table from table in same server

I'm trying to update a table in one database with data from a table in
another database on the same server, but I'm having trouble with my naming
convention.
Here's the script:
update DB1.dbo.table1
set col1 = Db2.dbo.table1.col1
from DB1.dbo.table1
inner join
DB2.dbo.table1
on DB1.dbo.table1.col2 = DB2.dbo.table1.col2
where DB2.dbo.table1.col1 like
'textstring'
When I run it I get this error:
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'lobbysqldbrawtest' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
I'm sure it's because I'm using a 4-part name (Db2.dbo.table1.col1) and it's
trying to resolve the database as a server. I don't know of another way to
point to the database. Any suggestions?
Thanks in advance.
John
On Tue, 27 Mar 2007 19:03:20 -0700, John Steen
<moderndads(nospam)@.hotmail.com> wrote:

>I'm trying to update a table in one database with data from a table in
>another database on the same server, but I'm having trouble with my naming
>convention.
>Here's the script:
>update DB1.dbo.table1
>set col1 = Db2.dbo.table1.col1
>from DB1.dbo.table1
> inner join
> DB2.dbo.table1
> on DB1.dbo.table1.col2 = DB2.dbo.table1.col2
>where DB2.dbo.table1.col1 like
>'textstring'
>When I run it I get this error:
>Server: Msg 7202, Level 11, State 2, Line 1
>Could not find server 'lobbysqldbrawtest' in sysservers. Execute
>sp_addlinkedserver to add the server to sysservers.
Hi John,
I don't see any 'lobbysqldbrawtest' in the code you posted. May I assume
that you simplified the code?

>I'm sure it's because I'm using a 4-part name (Db2.dbo.table1.col1) and it's
>trying to resolve the database as a server. I don't know of another way to
>point to the database. Any suggestions?
In column names, you don't repeat the server name. In fact, the database
name can be omitted as well; just the table name is enough - though I
personally prefer to use an alias. In this case, with the table names
being equal, you actually *need* to use an alias!
UPDATE dest
SET col1 = src.col1
FROM DB1.dbo.table1 AS src
INNER JOIN DB2.dbo.table1 AS dest
ON src.col2 = dest.col2
WHERE src.col1 LIKE 'textstring';
(untested)
And since there are no wildcards in 'textstring', you can replace LIKE
with = to gain some performance.
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

HELP: Physical Database Design

Hello to all.

I'm having trouble translating this requirement into physical DB tables:

- Information about users in general are:

- Username and Password

- Users belong to a group which have different roles

- (e.g. Customers, Administrators)

- Users can only belong to one group

- Information about groups are:

- GroupID, GroupName, Roles

- Customers and Administrators have different fields

- Customers : (CustomerID, CompanyName, BillingAddress, ShippingAddress, etc.)

- Administrators: (AdministratorID, AdministratorName)

- The system must be able to do the following:

- Ban a group

- Ban a specific user

- Information about a user must be based on the group that he/she is in. (e.g. Customer info must be queried from the Customers table) with the username as the only provided information initially.

- Add a new user type in the future

Any comments and suggestions will do. Thanks in advance.

- Raymond

Here is a good resource for classwork design problems such as this.

If you review some of the designs listed at this site, you will have a better idea of how to accomplish your assignment. (Note: the models and designs at this site are only a suggestion and should be used with caution -but they are better than nothing...)

http://www.databaseanswers.org/data_models/index.htm

Help: MS Access to SQL Server 2005 using SSMA

I am new to databases and need some info that I'm having trouble researching. I just migrated a access database to SQL server 2005 using SQL Server Migration assistant (SSMA). I wondered how SSMA handles NULL values? Also how it treats differences between Access and SQL? Any help would be appreciated.

SSMA will create a table in SQL Server that has equivalent fields to those in Access and then transfer the data. So if you have a Text field in Access that is not Required (i.e. it allows NULL values) you will get an NVarchar(255) filed in SQL with the Nullable property set to True. When the data is migrated, the NULLs will be migrated as well.

Mike

HELP: Exporting to excel

Hi,
I have been working on this problem for some time now and I am no closer to
a solution/answer.
The trouble is that I have created two reports which are basically tables
which display database data, with the input of several search parameters, but
when they get to a certain size (it appears to be like this) and I try to
export to excel I get this error when trying to open the file:
************
Microsoft Office Excel File Repair Log
Errors were detected in file 'ViewRequests.xls'
The following is a list of repairs:
Damage to the file was so extensive that repairs were not possible. Excel
attempted to recover your formulas and values, but some data may have been
lost or corrupted.
************
From this error, it seems like an excel problem, but we have tried different
versions and we do have a possible workaround we got from this site:
http://support.microsoft.com/default.aspx?scid=kb en-us 820712
but it is very time consuming and not many users have two versions on their
machine.
A couple of people have told me that it must be something in the report, so
I am wondering if formulas or something else would cause this, or if anyone
as encountered this before, or if anyone can confirm is this is a report or
excel error. It appers to be happening only for larger files, but I am not
sure.
ThanksThis command reaks havick on my emf files.
=System.Math.Floor((RowNumber(table4_Group1)-1)/10)
It makes all of multiple page reports act differently and look
differently.
Trint|||Specer23,
You made no mention of clearing out your user/system temp folders or creating a
new Excel template or being sure that there are no Addins or similar templates
loaded in your Excel.
Nor did you mention the scope of affected users.
These are all cursory steps to solving any MSO product issue and if not done is
a grand waste of time if not done.
You certainly could have a problem w/your report, however once you tip Excel,
you must do a little clean up.
I also would through trial & error, get to the magic number between a rendered
report and Excel or not.
Then I'd look at the raw data near that point and look for things like coma's in
numeric fields, invalid dates etc...
HTH
JeffP....
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:76DEC6BB-B20C-41BE-9CD3-60A1D638120C@.microsoft.com...
> Hi,
> I have been working on this problem for some time now and I am no closer to
> a solution/answer.
> The trouble is that I have created two reports which are basically tables
> which display database data, with the input of several search parameters, but
> when they get to a certain size (it appears to be like this) and I try to
> export to excel I get this error when trying to open the file:
> ************
> Microsoft Office Excel File Repair Log
> Errors were detected in file 'ViewRequests.xls'
> The following is a list of repairs:
> Damage to the file was so extensive that repairs were not possible. Excel
> attempted to recover your formulas and values, but some data may have been
> lost or corrupted.
> ************
> From this error, it seems like an excel problem, but we have tried different
> versions and we do have a possible workaround we got from this site:
> http://support.microsoft.com/default.aspx?scid=kb en-us 820712
> but it is very time consuming and not many users have two versions on their
> machine.
> A couple of people have told me that it must be something in the report, so
> I am wondering if formulas or something else would cause this, or if anyone
> as encountered this before, or if anyone can confirm is this is a report or
> excel error. It appers to be happening only for larger files, but I am not
> sure.
>
> Thanks