Viewing 15 posts - 19,936 through 19,950 (of 26,490 total)
You'll have to excuse me, but I'm much more of a visual person, could you show us the various forms the query could take based on the various parameters passed?
July 6, 2009 at 10:07 pm
What application are you tracing? There are several third-party applications that use server-side cursors in this fashion, one such application is PeopleSoft.
July 6, 2009 at 8:53 pm
I'm having a little trouble visualize what you are attempting to accomplish, and I have looked at this several times over the past week. If you could provide the...
July 6, 2009 at 8:49 pm
Here is an alternative solution. I added an additional column to show you what was being returned.
declare @customers table (cus_id int);
declare @orders table (cus_id int, order_date datetime);
insert into @customers...
July 6, 2009 at 8:42 pm
Database Mail is not supported in the Express Edition, nor is SQL Server Agent.
July 6, 2009 at 8:30 pm
I think the major problem here is your using a cursor-based routine inside a database trigger to update a table over a linked server connection.
First, look at changing the cursor-based...
July 6, 2009 at 8:18 pm
Jordan,
I am just making sure that there isn't something occuring to the database between the time you complete the full backup and the differential.
Please post the complete error message you...
July 6, 2009 at 7:51 pm
Just to clarify, you are asking if you can run the same SSIS package under two separate jobs, correct?
July 6, 2009 at 6:55 pm
Sounds like you may have two processes running that want exclusive access to the same file at the same time. What else is running when this job executes?
July 6, 2009 at 6:54 pm
That is a mighty vague and broad topic. There really isn't room to discuss it fully in a forum post. The gist of it usually forms the basis...
July 6, 2009 at 6:50 pm
WayneS (7/6/2009)
GSquared (7/6/2009)
... Heck, I once licked a live electrical cord to see what it would feel like.)Now that explains a few things.:w00t:
Okay... I missed that when it was...
July 6, 2009 at 6:40 pm
My brother-in-law as a Lt Colonel in the USAF stationed at the USAFA his last few years in the Air Force. The General he worked for required everyone to...
July 6, 2009 at 4:38 pm
SSIS (7/6/2009)
July 6, 2009 at 4:01 pm
SSIS (7/6/2009)
July 6, 2009 at 3:51 pm
Just to be sure, are you running anything between these two sets of code?
July 6, 2009 at 3:35 pm
Viewing 15 posts - 19,936 through 19,950 (of 26,490 total)