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...

Hi vinothd;

basically the script does two things, it creates a trace on the server; server side traces do not have an appreciable impact on the server.

second, it creates a view...

thanks matthew; I'm glad it looks like it might be useful for you.

it's something i play with when i have spare time; it started out before varchar(max) was available, but...

definitely fatfingered...i meant to say EXEC will use all you pass it, whether concatenated (max) variables or whatever, where sp_executesql is the one that will truncate at 4000; thanks, and...

sp_executesql, even though its an "internal" stored procedure, is still a proc, and it has a parameter that is an nvarchar(4000);

EXEC is a command, and has no parameters.. just...

I...

in addition to what ps said, maybe your friend sent you a backup file which contains more than one backup, and you restored only the first backup in the file,...

anything in double quotes or square brackets are expected to be a column name, not a static value:

SELECT 0 AS SupplierID, "All Suppliers" AS CompanyName

--should be

SELECT 0 AS SupplierID,...