supplying the missing DDL and DML setup that is preventing analysis:

drop table container_attribute_type

CREATE TABLE container_attribute_type(container_attribute_type_id int,priority_sequence int,branch_id int,updated datetime,updatedby varchar(30))

INSERT INTO container_attribute_type(container_attribute_type_id,priority_sequence,branch_id)

SELECT 4,1,3 UNION ALL

SELECT 11,2,3 UNION...

another way is to backup and restore the database, then delete everything in foreign key hierarchy order in the new copy.

also, i know you said no data, but from experience...

a coded example of what Seans' first thought: clearly item 2 you wanted, at 40,000, does not give the desired results.

you'll need to clarify either the biz logic or the...

saxena200 (2/11/2013)

---

Created a view with schemabinding, and then created index on it...

Question - before data loading is it necessary to drop the view or if i drop the index...

99% of the time, you do this kind of image inserts/updates in a programming language.

TSQL does not have a native, built in way to do image to disk operations....

but it's...

what if they have 2008R2 or 2012 installed? 2005 is already eight years old...wow. keep in mind that official support from MS (end of life?) for that product is probably...

Mike Seattle (2/8/2013)

---

OMG! I've worked with SQL Server for over 10 years and I've never heard of assertions. Really. This is the first time I hear there is something like...

Richard Warr (2/8/2013)

---

Create a table with the same structure as the output from sp_help (e.g. tblHelp) and modify your code to insert to it, e.g.

Select @sql = @sql +...

you created teh case in the CTE, but you never use it in your final query, i think.

see my reformatted post of your code, with this comment:

e.TermWeek,--<<--don't you want...

Like Anthony mentioned, the default trace has the information you are looking for, if not to much time has passed.

SSMS has a handy report which queries the trace for you:

Additionally,...

maybe use the metadata to generate the scripts for you?

this seems to be doing it right?

EXEC sp_msForEachDb 'USE [?];SELECT ''?'' As DbName,''DENY IMPERSONATE ON LOGIN::MyAuditor TO '' + quotename(name) +...

Howard i think this has an example of what you want, but i have not done this myself

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

A. Denying IMPERSONATE permission on a login

The following example denies IMPERSONATE permission on...

Andrew From experience, doing it all in TSQL can get very wordy and long. the headers require a lot of customization to match the shape / number of columns in...

a heap table never releases the space that were used by rows that existed, and then were deleted (unless a full table schema lock was applied, like when deleting ALL...

also, you want to bulletproof the comparison if the value for the Start_Date is changing from null to not null: that's not necessary if the field is not-nullable to begin...