Tag Info

New answers tagged

2

I did a little bit more research and found the answer to the problem. Even though the first parameter for DBMS_OUTPUT.PUT_LINE is listed as item in the 10g documentation for DBMS_OUTPUT. The actual name for the parameter is A. You need to bind the name using DBMS_OUTPUT.PUT_LINE(A => 'random text'). The actual parameter names for stored procedures can ...


0

The DMV columns sys.dm_db_index_usage_stats.last_user_*xxx* will tell you which tables were accessed since the instance last started, assuming you have a typical indexing strategy. Other DMVs will tell you which SPs are in use, but only while their plans are in cache; again, only since the instance started. If you have a relatively small application and ...


0

Even limited to just tables and stored procedures there isn't anything built in that will give you the information you are looking for. But there are things that will get you close. Tables - run a query that will give you the table name and the row count, then wait and run it again. Stackoverflow Question - get all table names and row counts. But this ...


2

Just in case this helps, I'm posting some code that might help you work out what account that sid represents: USE tempdb; GO -- to translate SID in binary format to AD format CREATE FUNCTION [dbo].[fn_SIDToString] ( @BinSID AS VARBINARY(100) ) RETURNS VARCHAR(100) AS BEGIN IF LEN(@BinSID) % 4 <> 0 RETURN(NULL) DECLARE @StringSID VARCHAR(100) ...


2

Yes, you can do this, and in fact with just 2 data centers you really have no other choice. Essentially, whenever you do not have a primary you can still do a reconfig but you must pass in {force:true} to make it happen on a non-primary node. This is listed in the docs for the rs.reconfig() command and in detail (with examples) as part of a tutorial which ...



Top 50 recent answers are included