Viewing 15 posts - 31 through 45 (of 63 total)
Is the DTC service running on the remote system?
Can you make a call to the remote SP outside of the trigger?
February 18, 2005 at 3:18 pm
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>
February 18, 2005 at 2:39 pm
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...
February 18, 2005 at 1:09 pm
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...
February 18, 2005 at 12:51 pm
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...
February 17, 2005 at 12:42 pm
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...
February 17, 2005 at 12:26 pm
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...
February 11, 2005 at 2:01 pm
See post here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=160718&edit=1
February 11, 2005 at 1:51 pm
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...
February 10, 2005 at 10:07 am
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...
February 10, 2005 at 9:56 am
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...
February 10, 2005 at 9:36 am
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...
February 3, 2005 at 3:43 pm
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...
January 28, 2005 at 3:23 pm
You may want to shoot me, but what you've described could almost be implemented using a merge replication scenario. See BOL if interested...
January 28, 2005 at 1:08 pm
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...
January 24, 2005 at 10:03 am
Viewing 15 posts - 31 through 45 (of 63 total)