it's a downloadable msi, which attaches an mdf i think; ; too big to actually script out

here's a link to 2005 databases:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

and here's a link to the base page for...

there's two ways I can think of to interpret "lock the table", which is why we ask.

you can "lock the table" with permissions, so noone, or noone but an sysadmin...

there is an optional OUTPUT clause you can use to retrieve all the values that were inserted; typically you insert the output into a temp table and use it for...

timestamp is a misnomer; the proper datatype is actually rowversion;

it is NOT related to time in any way, it is just a unique number which is created/updated automaticall when an...

i think your issue is the NOT EXISTS...

whenever you do that, You have to test for nulls, as that will screw up the EXISTS

WHERE NOT EXISTS

(SELECT OldLicenseNumber FROM...

another way to consider is to take away access to the tables themselves, and only grant access via stored procedures.

then you simply make sure the stored proc will execute onyl...

OK matthew; here's two versions for you, one for 2000, another for 2005;

as you'd guess, the 2000 version gets truncated if you have a huge table definition of 8000 or...

ahh, now if the defrag is introducing problems, yeah, I see your point;

Any chance you can reschedule either the defrag or the backup so they don't intersect at the same...

Steve, for my shop, we also believe it is a good idea to defrag at the OS level; most machines are scheduled for once a week, and my dev machine...

OK as I'm testing this, I've found that the code I'm using for the PK/UQ/indexes, which uses sys.views instead of things like sysindexes, makes the proc work only if it...

ok you got me thinking and in the mood, so i rewrote the procedure to get rid of all the cursors.

it's at least 5 times faster, cleaner code, blah blah......

vinothd (7/6/2009)

---

Lowell,

I tried executing the Procedure on my server and both the trace and the view have sucessfully got created .I have one last question.The Event Viewer tries to track...

==edit==

DOH i didn't see where you tried and failed due to indexes....sorry.

==edit==

here's a script I use to change collation;

in the example here, I'm grabbing only the top 5...you'd...

I think a lot of new posters don't have the experience/confidence to make sense of a quality article found on google, and are looking for the teacher/mentor to really rub...

vinothd (7/6/2009)

---

Hi Lowell,

Thanks for u'r prompt reply.I went and viewed the trace thru the view created.

I have a couple of questions.

1.Is there any Option to Run the trace for a...