what are the specific row values that are not coming over;

the WHERE statement you posted has WHERE items that might filter it out, as well as a group by to...

Sapen (3/21/2012)

---

Thanks for the reply Lynn.

The option "prevent saving changes that require table re-creation" is currently checked. But I dont want any data loss if I am making changes...

ramadesai108 (3/21/2012)

---

I have too many tables. If I use "generate script" then it will create the table creation script as well. I don't want to create the scripts for creating...

Tom Brown (3/21/2012)

---

If you select the Build...Deploy option in VS (at least in VS 2010), then Visual studio creates the deployment .SQL in the bin/debug or bin/release directory along...

Thanks for the reply...

How could i now take that script but update a new column in my database to show the sequence.

At the moment that seq column is blank but...

yes, SSMS provides a built in GUI functionality to do that; it's highly configurable via checkboxes to determine what to script or not.

simply right click on the database and follow...

With actually seeing the procedure itself, all we can do is offer basic advise.

if the Prof is skipping data, it is usually because a WHERE or JOIN statement in it...

well as the error says, the INSERTED and DELETED tables will not let you use the text fields from those two special tables...so just get it from the base table...

do you have a lot of defaults for the parameters, for example @datefrom dateime = NULL in your definitions?

it might be because of parameter sniffing exactly because of the defaults...the...

a serverside trace for DML changes is very lightweight; if you have it rollover you won't have to worry too much about log file sizes,a nd it may help you...

first guess:

does this return the same results as the two hour procedure?

SELECT

ent.document_version_id,

ent.[name],

ent.[value],

ent.entry_path

FROM mydb.dbo.entry ent WITH (READCOMMITTED)

LEFT OUTER JOIN

(SELECT

d.document_id,

MAX(dv.document_version_id ) AS document_version_id

FROM

Dot_Net_Installer_REP.dbo.document d WITH...

does a plan for this look any better?

Declare @param int

SET @param=5506

SELECT [this_].[EcomConfigurationId] [EcomConf1_3_0_],

[this_].[EcomEmailAddress] [EcomEmai2_3_0_],

[this_].[SecondryEcomEmailAddress] [Secondry3_3_0_],

...

I'm guessing that because the command sent was ...

WHERE [this_].[SiteId] = 5506

the 5506 has to be implicitly converted to the approriate type(the column it is compared to)

if you...

go to Control panel>>Administrative Tools>>Services.

you want to make sure the service exists first.

if it doesn't, then you probably only installed the client tools.

if it does, look at the name of...

is the datatype of the parameter passed also int, or is there an ISNULL(@param,0) used anywhere in the code?