1 - In DB2, the following pseudocode doesn't work:
define cursor
open cursor
while (not end of cursor)
make table update
commit;
end-while
close cursor
The reason? The "commit;" statement closes your cursor! you'll have to commit after exiting your loop.
2 - In SQL Server, you can end up with a database that has no owner. (!)
To correct this, us the sp_changedbowner system stored procedure.
example: sp_changedbowner 'sa'
A more thorough treatment of this topic can be found here.
Crazy ...
Subscribe to:
Post Comments (Atom)
The Database is not accessible after creating Always On Availability Group
Having created a fully functional SQL Server Always On Availability Group, I connect using SSMS. Upon trying to expand the database, I get ...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
BibleGateway.com - Passage Lookup: John 10:7, 9-10 9I am the gate; whoever enters through me will be saved.[a] He will come in and go out, a...
-
I spent a lot of time on this one, and it wasn't clear from examples precisely how the various items should be used together. The form...
No comments:
Post a Comment