It might be easiest to just get this information using SQL-DMO, where they are all properties of the column object, except for "Description"; is that an extended property?

--Jonathan

Use one file per filegroup and one filegroup per drive array. Use up to 80% of disk capacity. If your arrays are twelve-drive RAID 10 on a four-channel...

SELECT CAST(CAST(LEFT([Date],3) + 1900 AS char(4)) + '-' + STUFF(RIGHT([Date],4),3,0,'-') + ' ' +

STUFF(REPLACE(REPLACE(STR([Time]/100,8,2),'.',':'),' ','0'),4,0,':') AS datetime)

FROM StrangeDates

--Jonathan

quote:

---

I decided to go with adding a bitmask to the parameter table and have now found the following code to return the...

quote:

---

I hail thee, o mighty newborn SQL Server Guru.

May thy fountain of wisdom never run dry and may thy attitude never...

quote:

---

You can add constraints to each table and them build a view to union the tables together. The end effect should...

I would use image.

--Jonathan

You omitted not only the percentage but also the entire option. Try:

RESTORE DATABASE DB1

FROM DISK = 'K:\Backups\DB1.bak'

WITH

MOVE 'DB1_Data' TO 'k:\SQL\DB1_data.mdf'

,MOVE 'DB1_Log' TO 'l:\SQL\DB1_Log.ldf'

,REPLACE

,STATS

--Jonathan

quote:

---

Can you think of any logical reason why a referenced key would need to be unique? I haven't checked this in...

quote:

---

So if we do use the /PAE and only have 4GB, is that ignored or should we remove it?

Darren

---

--Jonathan