Viewing 15 posts - 10,876 through 10,890 (of 13,469 total)
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...
July 9, 2009 at 6:17 am
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...
July 9, 2009 at 6:05 am
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...
July 8, 2009 at 3:08 pm
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...
July 8, 2009 at 3:01 pm
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...
July 8, 2009 at 9:41 am
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...
July 8, 2009 at 9:35 am
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...
July 8, 2009 at 8:13 am
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...
July 8, 2009 at 6:13 am
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...
July 8, 2009 at 5:16 am
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...
July 7, 2009 at 1:08 pm
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......
July 7, 2009 at 12:06 pm
vinothd (7/6/2009)
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...
July 6, 2009 at 10:46 pm
==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...
July 6, 2009 at 9:21 am
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...
July 6, 2009 at 7:05 am
vinothd (7/6/2009)
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...
July 6, 2009 at 6:24 am
Viewing 15 posts - 10,876 through 10,890 (of 13,469 total)