Viewing 15 posts - 34,096 through 34,110 (of 39,800 total)
Are you at the latest service pack? I know there were some leakage issues with the XML stuff. PSS might have a special hot fix for it as well.
May 5, 2005 at 10:29 am
No difference really. The job would run a stored proc of a DTS package, but the DTS could run your proc. If you have more than one task or want...
May 5, 2005 at 10:28 am
thanks for the update.
May 5, 2005 at 10:28 am
Igor,
Thanks. Would you like to post some of these in the script section?
May 5, 2005 at 10:27 am
Do you mean the actual server names from each connection? The object model of DTS supports this.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspothobj_5x7t.asp
May 5, 2005 at 10:27 am
There isn't a good way to do this. You could use a stored procedure and run it in batches, say of 100 or 10 or something. That would give you...
May 5, 2005 at 10:25 am
Kishore,
The granularity of permissions and number in Yukon has greatly increased. There are schema permissions, definition permissions, etc. The idea is that you probably do not want to grant all...
May 5, 2005 at 10:21 am
Thanks for the complement on the writing ![]()
I used to hate generating this editorials because they take time and effort, but it's become kind...
May 4, 2005 at 4:30 pm
Mary,
Yikes
, I feel bad. Graduated in '89 with an Economics degree and I haven't heard of Dr. Samuelson.
Or at least I don't...
May 4, 2005 at 10:27 am
You can setup triggers to audit things. ApexSQL has a tool to automate this.
Profiler will catch the inserts/updates.
May 4, 2005 at 10:25 am
What are the processes doing? Have you run profiler and perf mon on the server when things hang?
May 4, 2005 at 10:24 am
It could be. Have you uninstalled other CTPs and reinstalled this one? I saw a thread somewhere on the Beta newsgroupw or Blogs about the fact that some COM components...
May 4, 2005 at 10:23 am
You'd have to build something or use a product like SQLCentric, BMC's Patrol, etc.
May 4, 2005 at 8:16 am
Sorry that you didn't like the topic. It's hard to write about SQL everyday
.
While I did focus on the US and it's H1-B...
May 4, 2005 at 8:05 am
Your example can handle some things, but it's not as clean, not does it easily work with non-US phones, etc. Using a CLR language and regular expressions, it's more flexible...
May 2, 2005 at 1:44 pm
Viewing 15 posts - 34,096 through 34,110 (of 39,800 total)