Viewing 15 posts - 76 through 90 (of 113 total)
August 18, 2003 at 6:08 am
be aware that altering a table and disabling a trigger is DDL and cannot be part of a transaction!
another possibility would be (yes - ok, hit me!) a global variable...
August 7, 2003 at 2:22 am
try
select serverproperty('ServerName')
best regards,
chris.
August 6, 2003 at 4:12 am
hi!
basically the code should work, except that i wouldn't assign a string to the Activeconnection property, which in fact is a ADODB.Connection object (this is just hidden by script-kiddy ASP).
try...
August 6, 2003 at 3:59 am
select object_name(your_resource_id)
best regards,
chris.
August 5, 2003 at 2:59 am
if you really want to use embedded cursors, do it like that:
declare @a int
declare @b-2 int
declare cursor foo for
select a from master_table
open foo
fetch...
August 5, 2003 at 2:58 am
looking at COM you'll see that 80004005 is just the code for E_FAIL, stating that *something* went wrong ... not a specific database/ADO error. you should check your drivers/ADO/OLEDB installation...
August 5, 2003 at 2:52 am
hi!
if you're using triggers and cursors, make sure you implement proper error handling (deallocate your cursor on every possible failure) or declare your cursor "local". otherwise an error that exits...
August 4, 2003 at 4:02 am
maybe a dumb question, but did you make sure you installed sybase client tools on the sql server machine, you'll run your DTS package on?
asking because that's happened to me...
August 4, 2003 at 3:57 am
use a bit variable for your break-condition and add it to your while:
@do_break = 0
while @counter < @upper_limit and @do_break = 0 begin
...
if [your_condition]
...
July 31, 2003 at 5:40 am
just for a quick hack:
select 'insert into your_table (fld1, fld2) values (' +
char(39) + fld1 + char(39) + ', ' + char(39)...
July 31, 2003 at 5:27 am
SQLBill is correct.
Nevertheless, if you do not want to create transaction log backups, which you will need for restores in the future, you can switch your database to "Simple" recovery...
July 29, 2003 at 5:40 am
hi!
quote:
How can we restrict the snapshot from recreating the whole db instead of just the newly created table .
July 25, 2003 at 5:24 am
hi!
why don't use something like that (no need to create a temporary table) - hope i really understood what you want to achieve:
create procedure sel_from_table_limited
@p_start_row int,
@p_row_limit...
July 25, 2003 at 5:18 am
try turning on MS DTC (distributed transaction coordinator) service.
best regards,
c.
July 24, 2003 at 4:02 am
Viewing 15 posts - 76 through 90 (of 113 total)