Forum Replies Created
Viewing 15 posts - 2,251 through 2,265 (of 2,486 total)
-
RE: DTS No longer working
What's your access level on the laptop? I had something similar happen to me when the IT department took away my local admin privelages on a new notebook.
Hope this helps
Phill...
-
RE: @@LOCK_TIMEOUT
Have a look at the TABLOCK option for BULK INSERT in Books Online
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
-
RE: Task Dependancy on Concurrent Tasks
Set up 'On Success' workflow from step 2 to step 3 to step 4. Also add 'On Succes' from step 1 to step 4.
Having two 'On Success' constraints on Step...
-
RE: DTS calling a VB exe -- unstable behavior
You can setup the trace data to go into a table on the server. This reduces some of the overhead. Have a look at the xp_trace_... procedures in BOL.
Hope this...
-
RE: Results need to be Fields
You'd probably have to put the results into a temp table and then do something like the old MS Acess crosstab query.
I think I saw a script that does something...
-
RE: Using DTS in an off the shelf application
Before you get too heavily tied into using DTS as part of your application, take a look at the following.
http://www.timeline.com/021903PR.htm
http://www.timeline.com/PatentMemo.pdf
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click...
-
RE: Loading Databases SQL 7.0
quote:
The Database was in 'loading' mode, looking via Enterprise Manager, and wasn't changing its status for over an hour!August 28, 2003 at 5:23 am
-
RE: SQL error 2501: help
Have a look at the following KB article,
http://support.microsoft.com/default.aspx?scid=kb;en-us;288745
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
-
RE: C: drive full after install
Do you want to move the distribution database or the Snapshot folder?
To move the distribution database see the following KB article,
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
To send the snapshots to a different folder you'll need...
-
RE: BCP Utility
Have you tried using a format file? Easiest way to create a format file is to BCP out from the destination table without providing any parameters. It will then prompt...
-
RE: Example of a linked server to AS400 ODBC
Don't know if this will be of any help, but this is how we link in our Progress database which resides on a UNIX server.
EXEC dbo.sp_addlinkedserver... -
RE: Results need to be Fields
How about,
select day(callwhen) as day
from billable_transactions
group by day(callwhen)
UNION
select count(callwhen)
from billable_transactions
group by day(callwhen)
order by day(callwhen)
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
-
RE: DTS calling a VB exe -- unstable behavior
Are you able to make modifications to the VB exe's? If so, one thing I've found handy is to have all database actions and results that the EXE logged to...
-
RE: MSX server
You could try sp_msx_defect. Look it up in BOL.
Just make sure your jobs don't get gunned down by the reds as they climb over the wall
Hope...
-
RE: Loading Databases SQL 7.0
Define what you mean by 'stuck'.
Generally most quick ways aren't really safe. You could try restarting the MSSQLServer service. I've found in the past that SQL generally recovers pretty well...
Viewing 15 posts - 2,251 through 2,265 (of 2,486 total)