Viewing 15 posts - 1,096 through 1,110 (of 1,790 total)
What are you seeing for errors when you step through the child packages? I understand that there is no logging but you should be able to see the errors when...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 21, 2008 at 3:47 pm
I know that when I right click on an index and select script to new query window I get the include columns as well as the standard referenced columns. Is...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 21, 2008 at 3:41 pm
Yeah, sorry, didn't read the full post only the part prior to my first response.
bpflanzer (10/21/2008)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 21, 2008 at 3:38 pm
Is your Distribution Clean up job running?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 21, 2008 at 1:52 pm
If it is being run by a job the job account should have access to that folder. Could very well be a permissions issue. I would verify that the account...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 21, 2008 at 1:16 pm
When you say the log record is that the dts package log or for the job that is running the package? Have you checked to see if the job that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 21, 2008 at 1:14 pm
Wow, a lot of questions here....
Is this run by a job? If so, what errors are you seeing there?
Do you have a log for the DTS package?
What...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 21, 2008 at 1:05 pm
There are some third party tools which support that, one being from the sponsor of this site, Red-Gate. The tool is called SQL Prompt. Haven't used any others so I...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 21, 2008 at 1:01 pm
Expand the publications then right click on the subscriptions and select "View Synchronization Status". You can also use Replication Monitor (right click on riplication > select "Launch Replication Monitor").
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 21, 2008 at 12:58 pm
It's the database. That is really annoying. I can't even begin to think why a change to the newer version of the sample database would make the difference in how...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 17, 2008 at 12:26 pm
Your query from the earlier post.
I am going to be putting the 2008 Adventure Works up shortly, couldn't do it with my previous version as the database was newer...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 17, 2008 at 12:16 pm
Ok, I finally bit the bullet and removed the pre-release version and installed the RTM version of Developer and, I was able to get a recommendation. Again, not a good...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 17, 2008 at 11:44 am
Jack Corbett, a frequent poster on this site, has a bunch of "how to" videos here - http://www.jumpstarttv.com/Search.aspx?terms=profiler
This should give you some great information to get started.
Enjoy!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 16, 2008 at 9:47 pm
Try the following links;
http://support.microsoft.com/kb/329332
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2676050&SiteID=1
http://support.microsoft.com/kb/816701
Hopefully this will help.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 15, 2008 at 9:07 pm
Not that I know of. Did you make sure you compressed the file first?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 15, 2008 at 7:32 am
Viewing 15 posts - 1,096 through 1,110 (of 1,790 total)