Sysname is the data type used for SQL Server identifiers like table names and column names.  By using sysname, you ensure that your code will upgrade if Microsoft changes the...

For that you would use the sysname data type and dynamic SQL, e.g.:

use northwind

go

CREATE PROC p_FetchDyn @Tablename sysname, @Var1 varchar(8), @Var2 varchar(10) AS

SET NOCOUNT ON

DECLARE @sql varchar(500)

SET @sql = 'SELECT...

The table data type cannot be used as a stored procedure parameter.  Use a temporary table instead.

You expect me to read the subject line? 

Are you sure?  What is the eaxct statement you used?  I see no support for this in the ALTER TABLE ALTER COLUMN syntax, and this certainly doesn't remove the property:

use...

You cannot remove the identity property from a column.  You can disable the property using SET IDENTITY INSERT.

DELETE FROM T1

WHERE NOT EXISTS

(SELECT *

 FROM T2

 WHERE Id = T1.Id)

I am going to register now as frank kalis. 

> It seems that data pages and procedures are both handled by the lazywriter, which seems to imply that seldomly used pages are kicked out of the cache after a while.

No,...

Okay; it's probably the foreign keys.  What indexes exist for the eight tables with foreign keys referencing the RetailMember table?  What DRI options (e.g. CASCADE DELETE) exist for those constraints?

The lower date is indeed chosen because of the disjoint in the British calendar when changed to Gregorian.  It is interesting that this shift was made at different times in...

> Jonathan, I am very interested how you were able to guage the speed gain and if you gauged the inserts as well or monitored for page splits or messed...

INSERT #TempTable

EXEC ProcB

You wrote you're trying to write a table structure, right? 

CREATE TABLE AssetTypes(

TypeID int IDENTITY PRIMARY KEY,

Descr varchar(20))

CREATE UNIQUE INDEX ux_AssetTypes_Descr ON AssetTypes(Descr)

CREATE TABLE...

If there's an error thrown, I think it would be documented.

You can't insert into a table variable using EXEC.