Viewing 15 posts - 196 through 210 (of 253 total)
very helpful. We'd like to run this delete once or twice a year over a weekend.
I'm thinking the best choice may be to script the indexes for all the tables,...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
September 28, 2004 at 8:45 pm
Good idea, But we use a moderately complex select to discover the rows to delete and the tables will have millions of rows after the deletion is performed.
Next?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
September 28, 2004 at 2:06 pm
Thanks for all your help. Here is a version that works. I decided to count the rows that match. In a perfect world, it would only display results where the...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
June 17, 2004 at 11:05 am
This almost works:
Declare @tablename varchar(255)
Declare tablecursor CURSOR For
Select TABLE_NAME from INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'QTY_PO'
OPEN tablecursor
FETCH NEXT from tablecursor into @tablename
while @@fetch_status = 0
BEGIN
print @tablename
select QTY_PO...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
June 16, 2004 at 4:32 pm
Thanks for the Quick excellent response.
Here is another Haiku in gratitude.
A Phoenix arose
from my grandfather's ashes
"Got a light?", it said
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
May 6, 2004 at 10:30 am
Not being a wiz at running stored procedures and figuring out the correct parameters, I used Steve's idea. It reassignes the owner to the current user's account. Seems to do...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
April 12, 2004 at 3:32 pm
Sorry that wasn't really necessary. Excuse the space.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 1, 2004 at 4:30 pm
That works, but I need a 2 digit year in front.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 1, 2004 at 3:58 pm
The Mdac version was the problem. When I updated to 2.7 SP1 Refresh, the problem vanished.
Midnight on the bridge
Icy wind and yellow moon
rising. No wetsuit.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
November 18, 2003 at 2:01 pm
Directly on the server means running the 40 pages of select statements in query analyzer on the server. Mdac version is 7.6 sp2.
Yes we use an instance name. The...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
November 18, 2003 at 10:36 am
Thanks for the great response.
Midnight on the bridge
Icy wind and yellow moon
rising. No wetsuit.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
November 4, 2003 at 10:33 am
ok Thanks for all your help. That code was very interesting.
spring, summer, fall now
dawn breaks on cold, white magic
Winter's chill is nigh
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
August 6, 2003 at 3:06 pm
Can this be converted to a function? That would involve replacing the sp_executesql statement with an xp_ statement.
spring, summer, fall now
dawn breaks on cold, white magic
Winter's chill is nigh
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
August 6, 2003 at 9:49 am
Solution:
Even though the Access database was secured using the default MDW file, I had to grant read access rights to the Access tables using the Admin id.
This solved...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
August 4, 2003 at 2:49 pm
I double checked that. The error message remains the same. Perhaps I am using the wrong driver?
spring, summer, fall now
dawn breaks on cold, white magic
Winter's chill is nigh
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
July 30, 2003 at 3:56 pm
Viewing 15 posts - 196 through 210 (of 253 total)