[dba-SQLServer] Must Relating Fields Have Different Names?

Dan Waters dwaters at usinternet.com
Wed Jul 30 18:32:44 CDT 2008


Have you been using SSMA?

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Harkins
Sent: Wednesday, July 30, 2008 5:21 PM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] Must Relating Fields Have Different Names?

If you figure it out, I'd like to know. I'm writing about upsizing right 
now, but I haven't run into that one before.

Susan H.


> Susan & Liz
>
> I looked at one of the affected tables in SQL, and it was the FK 
> constraint
> name, which I can change.  SSMA also created an extra index, which I can
> delete.  I've only got 7 of these so I can carry on!
>
> I got a warning for each of these in the SSMA Report, but it didn't 
> explain
> why it was changing the Foreign Key constraint name.

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list