It is generally unwise to shrink a...

See Creating Compressed Tables and Indexes in Books Online.

See this blog entry by the SQL Server Storage Engine Team for more information.

SQL Server provides a facility to estimate the space...

The CLR solution is faster than T-SQL solution in all but a very few cases - and even then there's not much in it.

Full code, by Adam Machanic, is available...

DECLARE @Header

TABLE (

header_id INTEGER IDENTITY PRIMARY KEY,

data ...

DECLARE @ProductMaster

TABLE (part_code VARCHAR(50) NOT NULL);

INSERT @ProductMaster VALUES ('S001:Sprocket');

INSERT @ProductMaster VALUES ('W562:Widget');

INSERT @ProductMaster VALUES ('Gearbox');

INSERT @ProductMaster VALUES ('B498:Banana');

INSERT @ProductMaster VALUES ('Q992:Petunia');

INSERT @ProductMaster...

Even CLR assemblies marked with...

Right-click on the database name in Object Explorer, choose Tasks, then Generate Scripts...follow the instructions and be sure to tick the option marked Script Data.

If the tables are large, you...

I feel your pain! It is an interesting...

Thanks for the great feedback there Jon. CLR is definitely a superior option to extended stored procedures!

Paul

Almost certainly a DDL Trigger. Event Notifications are asynchronous. If you want to be able to roll back the action, you have to be part of the transaction.

Understanding...

...and here is the link to that section of Books Online:

http://msdn.microsoft.com/en-us/library/ms191250.aspx

Click and enjoy.

Paul

barry.hostead (2/19/2010)

---

Hi Paul,

Thanks for your efforts on this one.

The reason for wanting to return the Contraint Name and Definition in the catch block is because there are multiple...

oageng_e_baruti (2/19/2010)

---

I used SCRIPT TABLE AS ---> CREATE TO

It gave me the exact definition that I had used.

The RIGHT CLICK --->DRAG doesn't work. It didn't work. I think may be...

You can. The details are in the same main section of Books Online.

This might give you some ideas too:

-- Test table

CREATE TABLE #Test (row_id INTEGER PRIMARY KEY, data VARCHAR(50) COLLATE LATIN1_GENERAL_BIN NOT NULL);

-- Sample data

INSERT #Test (row_id, data) VALUES (1, '1234567890');

INSERT...