A one-to-one relationship means that there is one row in table Sarah_1 that matches one row in Sarah_2. If there is a one-to-many relationship, e.g. one row in Sarah_1 with...

To list extended properties you can use fn_listextendedproperty instead of querying system tables though. And like I mentioned above, if you want to see them in EM then the special...

Do you mean something like this:

CREATE TABLE foo (a int NOT NULL, b int NOT NULL)

CREATE TABLE bar (a int NOT NULL, c int NOT NULL)

GO

INSERT INTO foo VALUES (1,...

Please do not cross-post questions to different forums. We read all of them.

Continue the discussion in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=194238.

Please do not cross-post questions to different forums. We read all of them.

Continue the discussion in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=194238.

Please do not cross-post questions to different forums. We read all of them.

Continue the discussion in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=194238.

I have to store at least 2.5 M files of 10KB monthly and I have to keep the data for 10 years

It seems to me that performance is not the...

What are you using this for? The design seems very strange. First, having a master table referencing child table(s) seems strange. But referencing one of three tables is not possible,...

Take a look at extended properties in Books Online. These are how Enterprise Manager manages the description property. The property should be called MS_Description to show up in Enterprise Manager.

Aha, then you have not installed SQL Server 2005 Developer Edition CTP. You have installed the Express Edition, which is the replacement for MSDE (SQL Server 2000 Desktop Edition). Although...

Np, happy to help. And in SQL Server 2005, it is even easier:

SELECT OBJECT_NAME(object_id) AS tablename

, [name] AS indexname

, is_unique

FROM sys.indexes

The new catalog views for metadata are really great with...

You should still set a strong password for sa, since all that is required is for someone that has access to the registry to change the key I mentioned above...

I am not sure you should be using sp_OA* at all, they can easily cause a lot of harm to your system. But I do not really understand what you...

DBCC USEROPTIONS will return a resultset with two columns, the first showing names of different SET options and the second with the current value. One of the rows will have...

In SQL Server 2005, Enterprise Manager and Query Analyzer has been replaced by a single application called SQL Server Management Studio. Do you not have this item in you start...