Viewing 15 posts - 38,941 through 38,955 (of 39,754 total)
I've had this a few times with v6.5 and had to call MS to get debugging support from the Level 3 support team.
Steve Jones
December 12, 2001 at 2:29 pm
Here's a VB example. You can modify this to run in script.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthappendchunkx.asp
Steve Jones
December 12, 2001 at 2:23 pm
Here's a VB example. You can modify this to run in script.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthappendchunkx.asp
Steve Jones
December 12, 2001 at 2:23 pm
December 12, 2001 at 1:14 pm
December 12, 2001 at 1:13 pm
December 12, 2001 at 1:12 pm
Perf does this automatically. In profiler, there is a data column for starttime.
Steve Jones
December 12, 2001 at 12:53 pm
This is an old example and article from Les and I'm not sure he will update this. I'll build an example soon and post it.
Steve Jones
December 12, 2001 at 10:36 am
Thanks for the feedback and I may update the article with some of these items (or write a more detailed one).
You are correct in your assumptions. I manually order the...
December 12, 2001 at 10:33 am
If this is SQL 2000, you can use the Dynamic Properties task to change the data pump.
Steve Jones
December 12, 2001 at 10:18 am
This error looks like you do not have change rights to the file. Ave you checked that?
There might be a 255 char limit.
Steve Jones
December 12, 2001 at 10:17 am
Follow Pau;s advice. This is not possible directly except with dynamic sql.
Steve Jones
December 12, 2001 at 10:13 am
Also the information_schema.xx views are SQL standards. There are:
tables
columns
etc. check master/views for the list.
Steve Jones
December 12, 2001 at 10:07 am
PLs do. This is one reason I avoid Temp tables if possible. There are more bugs associated with temp tables.
Steve Jones
December 12, 2001 at 10:02 am
You will have to use the timestamps to correlate them. You are trying to match an event in Profiler with the worsening or changing performance in Performance Monitor.
Steve Jones
December 12, 2001 at 10:00 am
Viewing 15 posts - 38,941 through 38,955 (of 39,754 total)