Forum Replies Created

Viewing 15 posts - 31 through 45 (of 63 total)

  • RE: problem calling a remote sp from a trigger

    Is the DTC service running on the remote system? 

    Can you make a call to the remote SP outside of the trigger?

  • RE: Default constraint question

    No, but given your situation, I would just do what "rhunt" described above.

    <quote>Can I still achieve this functionality if I create/alter the table the way you suggested?</quote>

  • RE: Unable to use RESTORE FILELISTONLY

    Don't have the solution, but I noticed that you specified 'C:\Database\Backup\TestBackup.bak' in your first "RESTORE FILELISTONLY" statement, then later 'C:\Projects\ASDOS\DataBase\TESTBackup.bak' and then finally 'C:\Projects\ASDOS\DataBase\TEST.bak' in the error message.  Each of these has...

  • RE: Default constraint question

    Well,

    OK I'm curious why you want to have two columns that contain exactly the same information -- seems unnecessary, redundant, and it violates basic normalization principles.

    Must you have a constraint...

  • RE: ADO.NET vs result set from stored procedure

    Well here's an example using code I use to fill a combo box ["lbDBA"].  May not be the most efficient, but it certainly works.  I take the easy approach and choose...

  • RE: SQL Mail

    Well, I was trying to think of a possible workaround myself, but the prev. poster is really asking all the right questions here.  

    You really need to think about the answers...

  • RE: TSSQL ???

    Might be easier if you just write to a SQL table.

    Here's some quick 'n dirty code for you.  I just took a S.W.A.G. at the field lengths in...

  • RE: syntax error in t-sql stored procedure

    To investigate the problem further, I would run SQL Profiler and see what syntax is being issued from VB.NET.

    Extract the line with the Transact SQL command from profiler and try executing it...

  • RE: Merging data from 3 sources

    Well, without knowing too much other than what you've described:

    I would try to avoid loading (potential) duplicate records in the final table, and then having to perform processing to remove the dups. It would be better to insert only the...

  • RE: merge replication

    Well, I haven't worked with merge replication per se, but I've seen this type of error in other replication scenarios.

    If I recall correctly, we need to make sure the account the SQL...

  • RE: BCP call to SP with temp table not working

    I wouldn't try to use a global temporary table--or a temporary table at all for that matter if you are going to be doing BCP.  Use a permanent table.

    You can name...

  • RE: Just discovered this but where is it documented so...

    Another (basic) approach that I like to use is to force the case on both sides of the equation.  Not rocket-science or anything, but it works:

     

    SELECT * FROM FinCenters

    WHERE UPPER(FC_NAME) LIKE...

  • RE: Multi Thread Question

    You may want to shoot me, but what you've described could almost be implemented using a merge replication scenario.  See BOL if interested... 

  • RE: Subset Data Extraction from PROD DB set

    OK.

    If you're that concerned about "Select into" vs "delete from" or "insert into" performance, then it sounds like you need another strategy. 

    I suggest you create a multi-step SQL Agent job to do...

Viewing 15 posts - 31 through 45 (of 63 total)